Php + Mysql Question! While inserting data into MySQL, how can I know if the data Im in

[GaiaZone 0]

Basically, I want to know if the Data I'm inserting through a Form is already there or not. Sort of a Username registration page.

I have this, but it doesn't appear to work...

$result = mysql_query("SELECT * FROM users WHERE username='$username'");if($result == 1)	{	echo '<h1>ERROR!</h1>The username you have chosen already exists!';	}

[sonesay 7]

$result will equal a resource object I beleive so comparing it to 1 will always result in false.You can use

$count = mysql_num_rows($result);

Then compare $count == 1 in your if statement.

Edited January 12, 2008 by sonesay (see edit history)

[GaiaZone 0]

It works perfectly.Thank you. =]

[slu 0]

...or let MySQL do the counting:

$result = mysql_query("SELECT count(*) as count FROM users WHERE username='$username'");$count = mysql_result($result, 0, "count");

and I would change the compare to $count > 0 in the if statement, just to be sure.

[galexcd 0]

...or let MySQL do the counting:

$count = mysql_result($result, 0, "count");
linenums:0'>$result = mysql_query("SELECT count(*) as count FROM users WHERE username='$username'");$count = mysql_result($result, 0, "count");
and I would change the compare to $count > 0 in the if statement, just to be sure.

That would result in an error if there were no rows matching that query. mysql_num_rows is the best function to use.