why does this code not work

[john8675309]

$connection = mysql_connect("localhost", "john", "camaro");
$db = mysql_select_db("instant", $connection);
$sql = "select * from users where username = \"$username\" ";
$result = mysql_query($sql,$connection);
$num = mysql_numrows($result);
echo "$num";

I keep getting
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /website/signupdone.php

if I change it to mysql_num_rows I still get
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /website/signupdone.php

any ideas

[theslinky]

change your query to:

$sql = "select * from users where username = '$username'";

use single quotes (') around strings instead of escaped double quotes 🙂

-sridhar

[theslinky]

oh, also, you may want to use LIKE instead of = if you want to do a case-insensitive match

-sridhar

[john8675309]

I still get the same thing

$connection = mysql_connect("localhost", "john", "camaro");
$db = mysql_select_db("instant", $connection);
$sql = "select * from users where username like '$username' ";
$result = mysql_query($sql,$connection);
$num = mysql_numrows($result);
echo "$num";

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource

the other question I have it the row types are set as text in my database might they have to be varchar or something

John

[theslinky]

Are you using PHP 3? If so, then mysql_numrows will return an error if there are no results (meaning now rows match the query). To work around this, see if result is false or do a fetch row to find out if it has a row.

If you are using PHP4, then use mysql_num_rows() instead of mysql_numrows.

-sridhar

[victordb]

I believe the code is mysql_num_rows not mysql_numrows.

[phynias]

Try doing this
$result = mysql_query($sql,$connection) or die("$sql:<br>" . mysql_error());

Than see what happens..

[john8675309]

All Smiles thaks for the tip I found I was calling the wrong column.
😃 😃 😃 😃