help to find mistake

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
kreoton
Forum Commoner
Posts: 42
Joined: Fri Mar 03, 2006 7:27 pm

help to find mistake

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

You need a space following "WHERE" when $query is set.
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

for future help do:

Code: Select all

$result = mysql_query($sql) or die(mysql_error());
...notice the mysql_error();
User avatar
kreoton
Forum Commoner
Posts: 42
Joined: Fri Mar 03, 2006 7:27 pm

Post by kreoton »

thanks, problem sloved

P.S. its realy stupid misteke :oops:
Post Reply