blingd Posted March 19, 2009 Share Posted March 19, 2009 hey people. I'm having problems in my php code. I'm using WAMP on my laptop and my code doesnt seem to be working I end up with this error message: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\wamp\www\new\test1.php on line 43 I cant seem to figure out what the problem is? is anybody able to help me?? Heres my code for test1.php: <?php $matchtype = $_POST['match']; $usertext = $_POST['text']; $connection = mysql_connect("localhost","root","") or exit ('Could not connect ('.mysql_errno().'): '.mysql_error()); $db = mysql_select_db(""); if ($matchtype == "room") { $query = "select * from laboratories where roomnu like '%".$usertext."%'"; } else if ($matchtype == "building") { $query = "Select * from laboratories where building like '%".$usertext."%'"; } else { $query = "Select * from laboratories where building like '%".$usertext."%'"; } $result = mysql_query($query); while($row = mysql_fetch_assoc($result)) { echo ($row ['roomnu']); } mysql_close(); ?> Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted March 19, 2009 Share Posted March 19, 2009 1.) Please use tags around your code 2.) This forum is for maths-related problems. 3.) I'm pretty sure a blank string is an invalid name for a database 4.) Welcome to the forums Quote Link to comment 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.