2 replies to this topic

[niurexx]

can someone please tell me whats wrong with this code, because i got some error using it...

$w = mysql_query("SELECT * FROM users WHERE username='$username'");
$arr = mysql_fetch_row($w);
if (!$arr) 
show_error_msg("Error", "Unable to create the account. The user name is possibly already taken.");

this is my screenshot

Edited by niurexx, 12 December 2008 - 12:00 AM.

[rc69]

Please read: http://www.pixel2lif...showtopic=36853

[derek.sullivan]

Gotta do a specific search rather than a general search... you have SELECT * FROM do something like SELECT `user` FROM that should help, mysql_fetch_row is fetching a row where the username=$user or whatever. if you do mysql_fetch_array then SELECT * FROM would be proper.