Page 1 of 1

help to find mistake

Posted: Sat Apr 15, 2006 4:35 pm
by kreoton
I make search script, and i got mysql_num_rows error that argument is not valid, pls help to find mistake

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>";
			}
		}
thanks

Posted: Sat Apr 15, 2006 4:41 pm
by feyd
You need a space following "WHERE" when $query is set.

Posted: Sat Apr 15, 2006 4:44 pm
by shiznatix
for future help do:

Code: Select all

$result = mysql_query($sql) or die(mysql_error());
...notice the mysql_error();

Posted: Sat Apr 15, 2006 4:52 pm
by kreoton
thanks, problem sloved

P.S. its realy stupid misteke :oops: