Apache/Mysql/php problem?

Ok... he is the problem, I hoper I can be clear about it...

I was runing windows 2000 Pro, I had installed Apache2/PHP/Mysql and everything worked fine, I then began to program a game.... then like an idiot, I decided why not switch to WIN XP.. so I did a fresh install.... after the install I tried to re-install and setup the server items... but now I get this error when I try to test my gaem, which I have not edited in ayway since before the XP install....



Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in L:\Sites\game\chat2.php on line 6


anyhelp would be greatly appreciated...

You can contact me on AIM(RezinGuitaristFG) YIM(kronikentertainment) or MSN(SSJ4Goku_elite@hotmail.com)

[Xnuiem]

Posting the code on that line and the line that created the MySQL result would be helpful.

Alright, here is the entire section of code for that error, though now, all of the scripts I have, that did work, have similar errors... so I think i've done something with the installation, rather than the code, because I havent edited the actual in any way.

session_start();
include 'mysql_connect.php';
$username = $_POST['username'];
$password = $_POST['password'];
$sql = mysql_query("SELECT * FROM user WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);

if($login_check > 0){
while($row = mysql_fetch_array($sql)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
session_register('username');
$_SESSION['username'] =$username;
session_register('user_id');
$_SESSION['user_id'] = $user_id;
$log = "UPDATE user SET loggedin='yes' WHERE (username='$username')";
mysql_query($log);

include 'logfresh.php';
}
}

Err.. *the actual code

Sorry for the double post.

[gesf]

I don´t see any mysql_fetch_row() function in the code!
Is that the chat2.php file´s code !?

[Xnuiem]

A good way to find out MySQL issues is to die with error.

Example:

For every result/query set, use "or die(mysql_error())" at the end.

Ergo, $sql = mysql_query("select * from users) or die(mysql_error());

This way it will die and print the error.