supplied argument is not a valid MySQL result resource

[EonStrife]

Just wondering, I keep getting this warning message :
supplied argument is not a valid MySQL result resource

when I use mysql_fetch_row or other function...

Anyone know why ?

Here's the code :

<?php
$link=mysql_connect("localhost","aaa.com","aaa");
if(!mysql_select_db("aaa_com",$link)) die("Database tidak bisa dipilih");
$result=mysql_query("SELECT * FROM 011110164",$link);

while($baris=mysql_fetch_row($result))
{
	print("$baris[0] - $baris[1] - $baris[2]");
}


mysql_close($link);

?>

Thanks.

[laserlight]

Very likely your query is wrong.
I suspect that "011110164" is not a valid table.
To help debug:

<?php
$link = mysql_connect("localhost", "aaa.com", "aaa");
mysql_select_db("aaa_com", $link)
	OR die("Database tidak bisa dipilih");
$result = mysql_query("SELECT * FROM 011110164", $link)
	OR die(mysql_error()); //to help in debugging

while ($baris = mysql_fetch_row($result))
{
	//not sure which one you actually want:
	//echo $baris[0] - $baris[1] - $baris[2];
	echo $baris[0] . " - " . $baris[1] . " - " . $baris[2];
}

//calling mysql_close() generally isnt needed though
mysql_close($link);
?>

[EonStrife]

Thanks, it works now 🙂

The problem is the table name, beginning with number is not valid(although it's valid with phpAdmin, I create the table with it). I change the table name to b011110164, and it works !