can anyone tell me why this shouldn't work?

[toddtwiddy]

   <?php

         $query = "select * from items";

         $result = mysql_query($query);

         while ($row = mysql_fetch_row($result))

         {

?>   

             <tr>

               <td>

               <?= $row['name']?>

               </td> 

            </tr>

<?php

}



?>

 

This is the error I'm getting and I just can't figure out why?

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/65/9110965/html/index.php on line 77

[Pikachu2000]

When posting code, enclose it within the forum's

 . . . 

BBCode tags.

 

Do you ever establish a connection to the database in the code?

[scootstah]

Try:

$result = mysql_query($query) or die(mysql_error());

[toddtwiddy]

OMG I am such a friggin MORON!!!!!  dunno why but I didn't select the db, only made a connection to the server  :shrug: :shrug: