Help with php syntax

metzfan33

I am just starting with mysql, and I was testing displaying table info. I now get an "Unexpected T_WHILE" error when I try it. Please look at the code and try to help me out! Thank you so much!

<?php
$connect = mysql_connect("localhost","root","");
mysql_select_db("mytest");
$query = mysql_query("SELECT * FROM mytest1 WHERE name= 'Chris Weber' ")
WHILE($rows = mysql_fetch_array($query)):
$name = $rows['name'];
$email = $rows['email'];
$message = $rows['message'];

echo "$name<br>$email<br><br>$messsage<br><br><br>";
endwhile;
?>

ewangeorge77

Other than that...I know that EOD; doesn't allow any spaces or tabs before or after it...so make sure there are none in your actual php file - doesn't look like there are here though...

cretaceous

next time paste your text using the PHP tags - much easier for everyone

<?php
$connect = mysql_connect("localhost","root","");
mysql_select_db("mytest");
$query = mysql_query("SELECT * FROM mytest1 WHERE name= 'Chris Weber' ")
WHILE($rows = mysql_fetch_array($query)):
$name = $rows['name'];
$email = $rows['email'];
$message = $rows['message'];

echo "$name<br>$email<br><br>$messsage<br><br><br>";
endwhile;
?>

add a semi colon after this line:
$query = mysql_query("SELECT * FROM mytest1 WHERE name= 'Chris Weber' ")