Jump to content

php help


blingd

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.