MySQL

[deep]

Hello,

Im trying to make a code that will chech the db if the user already exists and if the user does not exist then the script should add the user to the db.

here is the code:

$result = mysql_query("SELECT * FROM users WHERE username = $regUser", $db); // I ussually get an error here 🙁
$col = mysql_fetch_array($result);
if ($col['username'] != $regUser) {

								$sql = "INSERT INTO users (username, user_password, user_name, user_lastname)
										VALUES ('$regUser', '$regPass', '$regName', '$regLastName')";

								$result = mysql_query($sql);

My code is not working... can you pls help!

[TTT]

i think you get error because there is no results

$result = mysql_query("SELECT * FROM users WHERE username = $regUser", $db); 
   if(mysql_num_rows($result) != 0) {
      $col = mysql_fetch_array($result); 
    //....
   } else {
      echo "Unknown username";
   }

[deep]

hmm.. now i get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/public_html/status.php on line 61
Unknown username

[dopey]

Hi,

It's prob. falling over because you haven't quoted the username e.g.

$result = mysql_query("SELECT * FROM users WHERE username = '$regUser'", $db);

You'll probably want to addslashes to $regUser too if you've not done so already.

[deep]

Yea, that was the problem, Thanks!