Basis sporgsmaal, omkring Mysql/php
Hejsa, jeg har noget jeg ikke kan forstaa, og jeg haaber at der er nogen der kan hjaelpe mig med det.jeg bruger denne form
<html>
<head><title>formern</title></head>
<body>
<form action="results.php" method="get">
Item:<input type="text" name="item">
Proffesion:<select name="class">
<option value="alchemy">Alchemy
<option value="blacksmithing">Blacksmithing
<option value="cooking">Cooking
<option value="enchanting">Enchanting
<option value="engineering">Engineering
<option value="leatherworking">Leatherworking
<option value="tailoring">Tailoring
</select></option>
<input type="submit">
</form>
</body>
</html>
og her er results.php
<html>
<head><title>results</title></head>
<body bgcolor="#FFFFFF">
<?
/* declare some relevant variables */
$DBhost = "localhost";
$DBuser = "i8470";
$DBpass = "******";
$DBName = "tobenski_dk_-_items";
$table = $_GET["class"];
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = 'SELECT * FROM $table WHERE Item = $_GET["item"]';
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);
$i = 0;
if ($number < 1) {
print "<CENTER><P>There Were No Results for Your Search</CENTER>";
}
else {
while ($number > $i) {
$item = mysql_result($result,$i,"Item");
$link = mysql_result($result,$i,"Link");
$reagents = mysql_result($result,$i,"Reagents");
$Creators = mysql_result($result,$i,"Creators");
print "<p><b>Item:</b> $item<br>
<b>Link:</b>$link<br>
<b>Reagents:</b>$reagents<br>
<b>Creators:</b>$creators</p>";
$i++;
}
}
?>
</BODY></HTML>
og jeg faar folgende fejl:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /var/www/html/results.php on line 17
(og den finder ikke det item den skulle)
