DarthViper3k Posted April 19, 2003 Share Posted April 19, 2003 my error Warning: Supplied argument is not a valid MySQL result resource in c:apachehtdocsadminedituser.php on line 4 my code [php:1:ff6f2dbf6b]<?php $info_query = mysql_query(\"SELECT * FROM users WHERE id=\'$id\'\"); $result = mysql_query($info_query); $info = mysql_fetch_array($info_query)[/php:1:ff6f2dbf6b] Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/ Share on other sites More sharing options...
metalblend Posted April 19, 2003 Share Posted April 19, 2003 your query failed. use something like this to check for that and avoid the errors:[php:1:557323ef68]if ($result==FALSE) { # query failed.. do this print \"QUERY FAILED<br>\".mysql_error(); } else { # query was successful $info = mysql_fetch_array($info_query); }[/php:1:557323ef68] basically just remember that mysql_query returns a result handler on success, FALSE on failure. you can use this method to avoid the ugly errors hope that helps. Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1215 Share on other sites More sharing options...
DarthViper3k Posted April 19, 2003 Author Share Posted April 19, 2003 your query failed. use something like this to check for that and avoid the errors:[php:1:538252109a]if ($result==FALSE) { # query failed.. do this print \\\"QUERY FAILED<br>\\\".mysql_error(); } else { # query was successful $info = mysql_fetch_array($info_query); }[/php:1:538252109a] basically just remember that mysql_query returns a result handler on success, FALSE on failure. you can use this method to avoid the ugly errors hope that helps. ahhh thx man at least somebody knows some SQL Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1216 Share on other sites More sharing options...
DarthViper3k Posted April 19, 2003 Author Share Posted April 19, 2003 ok I figured out WHY the result was false (didn\'t connect to the database lol) but.... when I include() or require() or just copy my database connection onto the page I get this... You have an error in your SQL syntax near \'Resource id #2\' at line 1 but when I remove the code to connect to the database... its fine Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1217 Share on other sites More sharing options...
metalblend Posted April 19, 2003 Share Posted April 19, 2003 you should get no SQL syntax errors when connecting to the db can you show me how exactly you\'re connecting? Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1220 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 you should get no SQL syntax errors when connecting to the db can you show me how exactly you\'re connecting? thats the thing thats not the problem b/c if it was then I\'d be getting that same error on all of the pages that I use that connection with that connection is in my functions.php page and I use require on all my pages to get that connection when I use require or include on this new page I get that weird error so I copied the connection code over and replaced the require/include same error I remove it no errors so I can see it\'d be natural to think it was my connection but thats just it it can\'t be b/c I don\'t get that error on ANY other page that I required functions.php from Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1228 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 you\'re positive you have 0 queries executed in functions.php ? it would help to see some code. Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1233 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 you\'re positive you have 0 queries executed in functions.php ? it would help to see some code. *shrugs* alright fucntions.php (part of it) [php:1:9a06a29786] <?php $location = \"localhost\"; $username = \"DarthViper3k\"; $password = \"\"; //password removed $database = \"admin\"; $conn = mysql_connect(\"$location\",\"$username\",\"$password\"); if (!$conn) die (\"Could not connect MySQL\"); mysql_select_db($database,$conn) or die (\"Could not open database\"); [/php:1:9a06a29786] [php:1:9a06a29786] <?php require(\"fucntions.php\"); $info_query = mysql_query(\"SELECT * FROM users WHERE id=\'$id\'\"); $result = mysql_query($info_query); if ($result==FALSE) { # query failed.. do this print \"QUERY FAILED<br>\".mysql_error(); } else { # query was successful $info = mysql_fetch_array($info_query); } ?>[/php:1:9a06a29786] I know I missspelled functions but I spelled it like that when I made the file Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1235 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 There\'s absolutely nothing wrong with that code. Going back over the error, where would \"Resource id #2\" come from? The error looks like there\'s an attempt to query the database where \"Resource id #2\" is in the query.. any idea? Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1237 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 There\'s absolutely nothing wrong with that code. Going back over the error, where would \\\"Resource id #2\\\" come from? The error looks like there\'s an attempt to query the database where \\\"Resource id #2\\\" is in the query.. any idea? I don\'t have a \"Resource id #2\" as a query though ANYWHERE I\'ve never see that error before and I only get it when I try to connect to the database Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1238 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 Using this, do you still get an error:[php:1:521bbbb532]<?php $location = \"localhost\"; $username = \"DarthViper3k\"; $password = \"\"; //password removed $database = \"admin\"; $conn = mysql_connect(\"$location\",\"$username\",\"$password\"); if ($conn==FALSE) die (\"Could not connect MySQL\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\"Could not open database\"); $info_query = mysql_query(\"SELECT * FROM users WHERE id=\'$id\'\"); $result = mysql_query($info_query); if ($result==FALSE) { # query failed.. do this print \"QUERY FAILED<br>\".mysql_error(); } else { # query was successful $info = mysql_fetch_array($info_query); } ?>[/php:1:521bbbb532] This sure is frustrating Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1240 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 Using this, do you still get an error:[php:1:8c5c88e16b]<?php $location = \\\"localhost\\\"; $username = \\\"DarthViper3k\\\"; $password = \\\"\\\"; //password removed $database = \\\"admin\\\"; $conn = mysql_connect(\\\"$location\\\",\\\"$username\\\",\\\"$password\\\"); if ($conn==FALSE) die (\\\"Could not connect MySQL\\\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\\\"Could not open database\\\"); $info_query = mysql_query(\\\"SELECT * FROM users WHERE id=\'$id\'\\\"); $result = mysql_query($info_query); if ($result==FALSE) { # query failed.. do this print \\\"QUERY FAILED<br>\\\".mysql_error(); } else { # query was successful $info = mysql_fetch_array($info_query); } ?>[/php:1:8c5c88e16b] This sure is frustrating yup the only time I don\'t get that error is if I leave out the connection to the database however I need that connection in order for this page to work properly its part of the admin panel and this is the \"Edit Users Profile\" page edit: and I agree it is VERY frustraiting Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1241 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 ok start narrowing it down.. does this cause an error?[php:1:61e98c0148]<?php $location = \"localhost\"; $username = \"DarthViper3k\"; $password = \"\"; //password removed $database = \"admin\"; $conn = mysql_connect(\"$location\",\"$username\",\"$password\"); if ($conn==FALSE) die (\"Could not connect MySQL\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\"Could not open database\"); ?>[/php:1:61e98c0148] Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1244 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 ok start narrowing it down.. does this cause an error?[php:1:e46a5ffdac]<?php $location = \\\"localhost\\\"; $username = \\\"DarthViper3k\\\"; $password = \\\"\\\"; //password removed $database = \\\"admin\\\"; $conn = mysql_connect(\\\"$location\\\",\\\"$username\\\",\\\"$password\\\"); if ($conn==FALSE) die (\\\"Could not connect MySQL\\\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\\\"Could not open database\\\"); ?>[/php:1:e46a5ffdac] nope it doesn\'t nothing wrong with that thats what I was saying before I\'m using that code on a lot of pages (by including it) so thats not the problem the rest of it has no problems either I\'ve already done some narrowing down of it none of it causes an error unless I try to connect to the database I\'ve been talkin with other peeps nobody has ever seen it before and all I hear is \"it doesn\'t make sense\" so... I\'m guessing its one of the many bugs that has never been seen before and will hopefuly be fixed once I get this reported thats the only logical explaination I can come up with Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1247 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 none of it causes an error unless I try to connect to the databasethat code does in fact connect to the database. try creating a new file (test.php) and use this code:[php:1:34891f45c8]<?php $location = \"localhost\"; $username = \"DarthViper3k\"; $password = \"\"; //password removed $database = \"admin\"; $conn = mysql_connect($location,$username,$password); if ($conn==FALSE) die (\"Could not connect MySQL\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\"Could not open database\"); $query = mysql_query(\"SELECT * FROM users\",$conn); if ($query==FALSE) { print \"<code><b>ERROR :</b> QUERY FAILED<br>\".mysql_error().\"</code>\"; } else { print \"Found \".mysql_num_rows($query).\" record(s)\"; } mysql_close($conn); ?>[/php:1:34891f45c8] if you get no errors then there\'s something stray in this page you\'re having trouble with. let us know what happens. Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1249 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 none of it causes an error unless I try to connect to the databasethat code does in fact connect to the database. try creating a new file (test.php) and use this code:[php:1:d7338bb9c4]<?php $location = \"localhost\"; $username = \"DarthViper3k\"; $password = \"\"; //password removed $database = \"admin\"; $conn = mysql_connect($location,$username,$password); if ($conn==FALSE) die (\"Could not connect MySQL\"); $db = mysql_select_db($database,$conn); if ($db==FALSE) die (\"Could not open database\"); $query = mysql_query(\"SELECT * FROM users\",$conn); if ($query==FALSE) { print \"<code><b>ERROR :</b> QUERY FAILED<br>\".mysql_error().\"</code>\"; } else { print \"Found \".mysql_num_rows($query).\" record(s)\"; } mysql_close($conn); ?>[/php:1:d7338bb9c4] if you get no errors then there\'s something stray in this page you\'re having trouble with. let us know what happens. not a single error but what would be causing the problems?? I can\'t find anything there thats causing the problem can you? Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1250 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 I don\'t know.. there\'s nothing wrong with what you\'ve showed me so far. If it\'s not in functions.php , it\'s in this file you\'re having trouble with. I don\'t know what else to say.. you\'ve only showed me bits of the code. Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1256 Share on other sites More sharing options...
DarthViper3k Posted April 20, 2003 Author Share Posted April 20, 2003 I don\'t know.. there\'s nothing wrong with what you\'ve showed me so far.If it\'s not in functions.php , it\'s in this file you\'re having trouble with. I don\'t know what else to say.. you\'ve only showed me bits of the code. I\'ve shown you all of the PHP on the page everything else (so far at least) is HTML edit: if you want I can send you the files themselves Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1257 Share on other sites More sharing options...
metalblend Posted April 20, 2003 Share Posted April 20, 2003 sure.. email them to me: laggor@phirebrush.com Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1258 Share on other sites More sharing options...
DarthViper3k Posted April 21, 2003 Author Share Posted April 21, 2003 thx for tryin to help metalblend I talked to effigy and he solved my problem I was doin something stupid lol Quote Link to comment https://forums.phpfreaks.com/topic/366-not-a-valid-mysql/#findComment-1260 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.