mysql_fetch_array(): supplied argument is not a valid MySQL

[valen53]

<?
$con=mysql_connect("SERVER","","") or die ("Couldn't connect to SQL Server on SERVER");
$con1=mysql_select_db("project");

$result = mysql_query("select * from corder");
while ($row = mysql_fetch_array($result));
{
echo $row["OrderID"] ;
}
?>

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Apache Group\Apache\htdocs\jin yi\test.php on line 6

OS: win 98 : client
web server : Apache in w2k 2000: server

i can't find out the error, b'cos my PHPMyAdmin was run properly in my web server. anyone else know the error ???
i can run this source file in my home standalone PC , but cannot run in my office network .
thank to helping

[cgraz]

first of all, put your code in php tags [ p h p ] code here [ / p h p ] (minus the spaces). That will make your code a bit more readable. Then change

$result = mysql_query("select * from corder"); 

to

$result = mysql_query("SELECT * FROM corder") or die(mysql_error()); 

mysql_error() will let you know what the problem is.

Cgraz

[alanzhao]

Are you trying to connect to your database server at home from office?

[valen53]

i forget to put "root" at mySql_connect( )