Error when testing MySQL installation

[Davve]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\server_test.php on line 5

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\server_test.php on line 6

<?
 $sql="SELECT count(user) FROM user";
 $conn=mysql_connect("192.168.0.116", "root", "");
 mysql_select_db("mysql");
 $result=mysql_query($conn,$sql);
 $siffra=mysql_num_rows($result);
 echo $siffra;
?>

The "funny" part is that when my fried tries this on his MySQL server, it works!

I've installed PHP and MySQL on an Win 2000 Advanced Server.


Help, please!

[randem]

I believe your problem is in the syntax of your mysql_query() command, in which the SQL statement should come first, and the connection is second.

you should test the results of each step... never count on it all working.

Plus, this is far easier to debug...

<?php
$sql="SELECT count(user) FROM user";
if($conn=mysql_connect("192.168.0.116", "root", "")){
    if(!mysql_select_db("mysql", $conn)){
        mysql_close($conn);
        die ("unable to select database");
    }
    if($result=mysql_query($sql,$conn)){
        $siffra=mysql_num_rows($result);
        echo $siffra;
    }
    mysql_close($conn);
}else{
    die ("unable to connect to mysql");
}
?>

[Davve]

Good thinking! But, I still get the errors, only this time I get only one of them!

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\server_test.php on line 8

<?php
$sql="SELECT count(user) FROM user";
if($conn=mysql_connect("192.168.0.116", "root", "")){
    if(!mysql_select_db("mysql", $conn)){
        mysql_close($conn);
        die ("unable to select database");
    }
    if($result=mysql_query($conn,$sql)){
        $siffra=mysql_num_rows($result);
        echo $siffra;
    }
    mysql_close($conn);
}else{
    die ("unable to connect to mysql");
}
?>

But! I just remembered something. When I installed MySQL using Kevin Yank's tutorial, he was talking about renaming a .fnc file or something. The thing is that I never found the file that was to be renamed! So I never renamed and moved it.

Maybe this is why? MySQL-Link sounds like something like that...

[randem]

you still have your $conn and $sql arguments backwards in the mysql_query() command.

re-read my previous reply

[Davve]

I'm really sorry... Thanks! It's working now.