mysql_query troubles

[Anon]

here is my code snippet

$db_name="auth";
$table_name="auth_users";
$connection = @mysql_connect("localhost", "john", "camaro") or die ("no connect
ion");
$db = @mysql_select_db($db_name, $connection) or die ("no selection");
$sql = "select * from $table_name where username = \"$username\" and password =
password(\"$password\")";
$result = @($sql,$connection) or die ("no executy");
$num = mysql_numrows($result);
if ($num != 0) {
$cookie_name = "auth";
$cookie_value = "googalybear";
$cookie_expire = "";
$cookie_domain = "";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/" , $cookie_domain, 0);
$display_block= "

I know this works I just installed slack 8.1 and that is when the trouble began I can get connected and select the DB but when I run the Sql I either get a blank screen or it automatically defaults to my error page (not shown here) I have recreated the database auth with one user in it and I can go into mysql and select it select * from auth_users but when I query it from php no go. is that a compiling issue or a php.ini ??? any help is apperciated

John

[Anon]

It's always a good idea to echo out your sql statement if your getting problems just to make sure it's formatted right. Try this

$sql = "select * from '$table_name' where username = '$username' and password ='$password'";

Oh and remove the error stopper "@" from mysql might give you more information while coding.

[Anon]

it's mysql_num_rows.

HTH
Justin

[Anon]

mysql_numrows() is also usable, but deprecated.

Still, it's difficult to say what the error may be when all the error messages are suppressed.