Søge i mysql database
Hej, jeg prøvet søge i en mysql database, jeg kan ikke få det virke.Jeg får følgende 2 fejl:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in sog.php on line 25
---------------------------------------------
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in sog.php on line 49
Håber der er nogen der kan hjælpe mig er ved at køre død i det...
Mit cript ser sådan her ud:
<?
function ShowTable($name){
MYSQL_CONNECT(localhost, xxxx, xxxx) OR DIE("Unable to connect");
@MYSQL_SELECT_DB("data") OR DIE("Unable to select database");
$query = $_POST['query'];
$resultat = mysql_query("select * from subs where cder like '$query'") or die(mysql_error());
$result = mysql_query($query);
$total_rows = mysql_num_rows($resultat);
if ($total_rows=="") {
print "<HTML><BODY><h1>Ingen resultater</h1></BODY></HTML>";
return;
}
$row = mysql_fetch_row($result);
$total_cols = count($row);
$style = '<link href="style.css" rel="stylesheet" type="text/css">';
$div = '<div id="container">
<img src="header2.jpg"/>';
print "<HTML>";
print "<HEAD>";
print $style;
print "</HEAD>";
print "<BODY>";
print $div;
print "<table width='100%' border='0' cellspacing='0' cellpadding='0' align='center'>";
print "<tr class='blue'><td colspan=$total_cols align=center>Din søgning gav: $total_rows resultater</td></tr>";
print "<tr>";
print $tallet;
$i=0;
while($i < $total_cols){
print "<td>";
print $row[$i];
print "</td>";
$i++;
}
print "</tr>";
while($row = mysql_fetch_row ($result)) {
$i = 0;
print "<tr>";
while($i < $total_cols){
print "<td>";
print $row[$i];
print "</td>";
$i++;
}
print "</tr>";
}
print "</TABLE></BODY></HTML>";
}
?>
<?
ShowTable("Subs");
echo $order;
?>
På forhånd tak,
