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(); ?> Link to comment https://forums.phpfreaks.com/topic/150105-php-help/ 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 Link to comment https://forums.phpfreaks.com/topic/150105-php-help/#findComment-788463 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.