[RESOLVED] cannot select anything from DB???

[jeepin81]

Hello - Ok this should be easy and I don't know what I am doing wrong. This is just dumbed down code for testing.

I'm just trying a basic SELECT * FROM statement and I keep getting this error?

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /data/9/1/12/115/1827767/user/1982282/htdocs/test.php on line 11

I can run this script on my local PC and it works fine. When I upload it to a network solutions server it will not work. Same schema, same db, same across the board. I can INSERT INTO just fine but when I try to get data out, no luck????

Any Ideas?

require_once('ADMIN/db_connect.php');

$conn = db_connect();

$query = "SELECT * FROM USER ";

	   $result = mysql_query($query, $conn);
	   while($row = mysql_fetch_assoc($result)){
	   echo $row['USER'];
	   }

	   ?>

Thanks in advance!
j

[bradgrafelman]

Try adding or die(mysql_error()) onto the end of your mysql_query() call so you can see what error message MySQL is returning.

[jeepin81]

Thank You Good Sir - I add the error())(which I'm not sure why I didn't put that in there to begin with) and it was revealed that I was calling my table name in uppercase and it is lowercase.

It always seems like it's the small things that catch you.

Thanks Again,
j

[Weedpacket]

Yes, a stupid design decision on MySQL's part means that table names are case-sensitive (except on Windows machines), in violation of the SQL spec.