[Resolved] Can't read information from database?

Chizzad

I think I have the syntax correct but I am not sure with this.

and this is the error that I get.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/chad1/public_html/APX/index.php on line 32

http://chadcoronato.com/APX/

Any ideas?

Thanks,
Chad

ShawnK

<?php 

$db = mysql_connect("localhost","chad1_chad","iruleu"); 
mysql_select_db("chad1_test",$db); 

$query = mysql_query("SELECT * FROM APX_members"); 

while($row = mysql_fetch_array($query)){  

      echo "<td>".$row[last_name].", ".$row[first_name]."</td>"; 
} 
?>

I revised your code. This new one should work. When you need to extract data from a database into a loop. Do

$query = mysql_query("query...");
while($row = mysql_fetch_array($query)){
     ....
}

Chizzad

hmm gave it a shot. still not working.
did i do it right?

$result = mysql_query("query SELECT * FROM APX_members");

thanks for the help!
chad

ShawnK

Nope. It is:

$result = mysql_query("SELECT * FROM APX_members");

is the database APX? and the table members?

Chizzad

no, the database is chad1_test and the table is APX_members

once again, I appreciate the help.

TheDefender

Add some or die's for error checking:

<?php  

$db = mysql_connect("localhost","chad1_chad","iruleu") or die(mysql_error());  

mysql_select_db("chad1_test",$db) or die(mysql_error());  

$query = mysql_query("SELECT * FROM APX_members") or die(mysql_error());  

while($row = mysql_fetch_array($query)){   

      echo "<td>".$row[last_name].", ".$row[first_name]."</td>";  

}  

?>

Let's see if the query or select are failing... because ShawnK's code should have worked... Are you sure you are putting the right username/host/password, etc? Also, the table and DB names are case sensitive, so double-check that...

Chizzad

awesome! It works! I forget to set the user to the database. Damn newbie mistakes.

Thanks guys,
Chad