I am new to PHP/MYSQL but I've done a little. I am actually using code that worked on a different site of mine but I can't seem to get info from the database now. I am able to use a form to add info but when trying to display it I get an error.

I get this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vqtkkzap/public_html/may30/confirmed/display.php on line 14

The code on line 14 it references is this:

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

I am not sure what I am doing wrong. Can anyone help?

This errors means that you either heven't fired the sql query with mysql_query(), or that there was an error when you did.

Check the query result with something like

PHP Code:

$result=mysql_query($query);
if ($result === FALSE){
  print mysql_error();
  die();
} 


I put that code in there and get this: No database selected

So, select a database after connecting to the server.
http://www.php.net/manual/en/functio...-select-db.php

i like doing

$result=mysql_query($query) or die ("Mysql Error - " . mysql_error());

that way if i screw up.... the site slaps me in the face

anyway looks liek your missing

mysql_select_db("your database name");