can't get info from mysql

[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 ! ";