Why do I get a 'Supplied argument is not a valid MySQL result resource' error? — OZONE Asylum, home of the Mad Scientists

FAQ

Why do I get a 'Supplied argument is not a valid MySQL result resource' error?

This page's ID: 5673

You are editing "Why do I get a 'Supplied argument is not a valid MySQL result resource' error?"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	There are a number of possible solutions (which are largely connected with the preceeding SQL statement rather than anything on the line the error number is for (mysql_num_rows() is commonly indicated if it is being used): 1. Make sure the tables and fields exist in your SQL statement. 2. If you are passing a variable in the SQL make sure it is probably escaped (usally in single quotes, but don't forget to addslash() if it came from outside (ie. get/post/cookie) and magic_quotes_gpc is off. Look those up in [url=http://www.php.net/manual/en]the php manual[/url] if you don't know what they mean). Not doing this will generate the error: [code]$sql = "SELECT something FROM table WHERE something = $variable";[/code] and this will fix things: [code]$sql = "SELECT something FROM table WHERE something = '$variable'";[/code] Note: you could also use double quotes, but not within a double quoted string... --------------------------- Relevant links: [url=http://www.webmasterworld.com/forum13/2138.htm]PHP/MySQL error[/url] [url=http://www.experts-exchange.com/Web/Q_20525512.html]Minor mySQL troubles (in PHP)[/url] _____________________ [internallink=4626]Emperor[/internallink] [small][i](Edited by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Tyberius+Prime]Tyberius Prime [/url] on Mon 12-May-2003)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Back to Why do I get a 'Supplied argument is not a valid MySQL result resource' error?

Admin
Preserve
Manage

Advanced Search
Quick Changes
RSS Changes
Member List
Your profile
Admin Log

- Copyright ©1994-2024 by Doctor Thaddeus Ozone, all rights reserved. -
- Grail copyright ©2000-2024 by Tyberius Prime, all rights reserved. -

Debug: This page needed 0.00439286 seconds to process.

Show Forum Drop Down Menu

Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
*WARNING* BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail