do/while

nogard

Ok sem to have most of this yet do not know why the }else{ line shows a Parse Error.

mysql_select_db("coachin3",$db);
$result = mysql_query("SELECT * FROM event",$db);
echo "<table border=1>\n";
echo "<tr><td>Name</td><td>Type</tr>\n";
do {
printf("<tr><td> %s</td><td>%s</tr>\n", $myrow["name"], $myrow["type"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry, no records were found!";
}
mysql_close ($db);
?>

This code worked fine when I did the tutorial at ...
http://hotwired.lycos.com/webmonkey/99/21/index3a_page2.html?tw=programming

Anon

you haven't copied te webmonkey code correctly

hope this helps,
stef

nogard

Well I used copy paste and changed the array names and db info ...
It would be nice if you could point out what I didn't copy and paste correctly. It is not like I am asking you to write all my code for me. If I had the answer I would not have posted this thread to a forum for HELP with php.

brandonschnell

the else has to be balanced with an if.

go back to webmonkey and look at the line:
if ($myrow = mysql_fetch_array($result)) {

you need that to balance the else.

like the previous guy was saying, if you don't understand the code then try it without serious modifications. copy and paste new code into your scripts. change as little as possible to make it work. once you've got the basics, then try to change one thing at a time until you understand what the code does.

nogard

OK that took an hour 🙂 I saw I was missing the "if" statement from the tutorial.

Still does not run correctly.

Can someone point out the correct way to write the INSERT INTO code?

nogard

Thanks Brandon

I did the tutorial as is and it worked fine. I am just not thinking like a coder yet.