help... Query mysql. bad scripting?

[Luinva]

I need help from one of you smarty people.
I am trying to run a query and I think this looks good but I must be missing something. Every time I run this is come back with

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in /home/mendezmu/public_html/yeah.php on line 13

Would some one give me some advice?

<?php
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error
connecting to mysql');
echo 'it works!!!';
$dbname = 'mendezmu_testingagain';
mysql_select_db($dbname);
echo 'this too!!'

$result = mysql_query("SELECT * FROM testingagain")
or die(mysql_error());

$row = mysql_fetch_array( $result );

echo "Name: ".$row['Name'];
echo "Age: ".$row['age'];

?>

Thanks

[djjjozsi]

you missed a ; around that line:

mysql_select_db($dbname);
echo 'this too!!';

If you expect one row, you can use that simple mysql_fetch_array

But, if your result is more than one row, lets take that in while,

while($row=mysql_fetch_assoc($result))
{
echo $row["field1"]." -".$row["field2"] . "<br />"; 
}

:

[Luinva]

thank you so much. Any suggestions for tutorials online?