Supplied argument not valid!

Anon

Help.

I have a script thjat wehn run gives me:

Warning: Supplied argument is not a valid MySQL result resource in /login.php on line 61

Line 61 reads:
if (mysql_num_rows($verify_user) > 0) {

and $verify user = mysql_query("SELECT * FROM user WHERE username = '$data[0]'");

Now I have another script that runs code that is almost identical (the sql query and variable names are different) and it runs fine! Why?

Nick.

Anon

I hope you cut and pasted your example backwards, because otherwise $verify_user is meaningless.

Put in a debug statement to print out the SQL statement before it is run. Make sure that $data[0] evaluates to something that makes sense.

Anon

Yeah I did paste the code in backwards, I was trying to explain it in English as oppose to code. Little stupid really considering, but it's an old habit from dealing with clients. 🙂

I have solved the problem and I think I know why it happened. It all stems from an earlier post of mine.

I was having a problem getting my login script (this script) to detect an access code from a mysql database and then forward to one of two pages debending on the returned code. The problem was that redirection in php is done using header() and as a header it needs to be defined at the start of the file. A suggestion from my other thread was to use ob_start() near the top of the script to hold everything in a buffer.

Unfortunately this appears to hold EVERYTHING in a buffer including the include statement I have which loads my mysql connection script. Therefore, no connection = invlaid argument.

At least that's what I think it could be; though I'm probably wrong.

So now I have two seperate login pages, one for each kind of user. It's a bit of a lame work around, but I've been stuck on this for days and I've gotten a little pi**ed off with it.

Anon

Well, I was having this exact problem, and it frustrated me for quite some time, while I knew my query statment SHOULD work, it was not. I was just playing around with the statement, and put ()\'s around the WHERE statement, then VOILA! it worked!

try:

$verify user = mysql_query(\"SELECT * FROM user WHERE (username = \'$data[0]\')\");

gushy

So long ago, I can't remember what the solution was. Reading back through my posts I think it was ob_start causing the problem.

I code pages everyday, and I've never yet needed to put brackets around my WHERE statements.

I'm sure it was probably something silly, if I ever get the problem these days it's just down to a typo, or my putting a fetch_array instead of num_rows. things like that.

Thanks for the tip anyway Joe.

-- Nick Gushlow