can't get info from mysql

[mr e]

ok i have a completely different page, nothing to do with vb, but here's what i have so far...

PHP Code:

$DB = mysql_connect( "localhost", $DBUSER, $DBPASS ) or die("Could not connect to $DBNAME");

mysql_select_db( $DBNAME, $DB ) or die("Could not find database");

function view() {
        $getshouts = mysql_query("SELECT * FROM shouts");
        while(list($shouts) = mysql_fetch_array($getshouts, $DB)) {
        echo $shouts[name];

        }
... 


and yes i DO have more in the view() funcion but i only listed what was neccessary, basically i can't get it to echo anything out, im only using the echo as a test to see if i can actually use the variables, i have tried quite a variety of ways but still can't figure out whats up...hope you can help

[Dark_Wizard]

This:

echo $shouts[name];

should be this:

echo "$shouts[name]";

[mr e]

this is what i have now, i've narrowed it down and i know it's something to do with the SELECT

PHP Code:

$getshouts = mysql_query("SELECT name FROM shouts");
if (!$getshouts) {
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
;}

echo "Your name is $name ! "; 


and i have 4 entries all the same and it prints
Your name is ! Your name is ! Your name is ! Your name is !
so i dunno what the problem is, so hope someone can help

[Dark_Wizard]

Change this:

$getshouts = mysql_query("SELECT name FROM shouts");
if (!$getshouts) {
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
;}

echo "Your name is $name ! ";

to this:

$getshouts = mysql_query("SELECT name FROM shouts WHERE name=$name");
if (!$getshouts) {
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
;}

echo "Your name is $name ! ";

[Ajay]

PHP Code:

        $getshouts = mysql_query("SELECT * FROM shouts"); 


change that to
this should work:

PHP Code:


$getshouts = "SELECT * FROM shouts";
mysql_query($getshouts) 


or something similar

[mr e]

ok i finally got it, thanks all