Simple db query errors in: 'unexpected T_WHILE...'

[Colloid Snake]

Hello-

I'm trying my hand at php, and seem to be stuck at a pretty basic point.

I'm attempting to create a database driven menu list (such as if the Forums list on theScripts was to have a sub-list that was populated by a db query), and as such was using this page to guide me in trying to fetch the array of possible choices.

This is my code so far (starting basic and working my way up)

<?php
 
// connects to local db with uname nisuser
mysql_connect("localhost", "user", "passswd") or
    die("Could not connect: " . mysql_error());
 
// selects nisinventory db
mysql_select_db("nisinventory");
 
// selects
$result = mysql_query("SELECT Criticality FROM hardwaresorted");
 
// test to see what is in hwarray
echo $result
 
// loop for rows
while ($row = mysql_fetch_array($result) )
{
        echo $row;
}
 
?>
 

And when I run it, I get this error:

PHP Parse error:  syntax error, unexpected ',' /home/user/bin/php/list.php on line 5
 

Can anyone help resolve this error?

[ronverdonk]

Line 14 (echo $result) needs a semi colon.

Ronald

[Colloid Snake]

Line 14 (echo $result) needs a semi colon.

Ronald

Dang, that would do it, wouldn't it? Thanks!