php help

[blingd]

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();

?>

[GingerRobot]

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