help to find mistake
Posted: Sat Apr 15, 2006 4:35 pm
I make search script, and i got mysql_num_rows error that argument is not valid, pls help to find mistake
thanks
Code: Select all
if (isset($_POST['kriterijus'])) {
$kriterijus = $_POST['kriterijus'];
$query = "SELECT V.vartotojo_id,
V.vartotojo_vardas,
D.darbuotojo_vardas,
D.darbuotojo_pavarde
FROM darbuotojai D
INNER JOIN vartotojai V ON V.vartotojo_id = D.vartotojo_id
WHERE";
switch ($_POST['kur']) {
case "v_vardas":
$query .= "V.vartotojo_vardas LIKE '$kriterijus'";
break;
case "d_vardas":
$query .= "D.darbuotojo_vardas LIKE '%$kriterijus%'";
break;
case "d_pavarde":
$query .= "D.darbuotojo_pavarde LIKE '%$kriterijus%'";
break;
default:
$query .= "V.vartotojo_vardas LIKE '%$kriterijus%'";
break;
}
$result = mysql_query($query);
if (mysql_num_rows($result) > 0) {
echo "<table border=\"1\" width=\"50%\">";
while ($res = mysql_fetch_row($result)) {
echo "<tr>
<td>".$res[1]."</td>
</tr>
";
}
echo "</table>";
}
}