Thanks, this is what was return when I use the mysql_escape, the error disappear but still not return the search term john. Thanks, Gab Results Sorry, your search: "seedtech" returned zero results Couldn't execute query --- On Sat, 8/8/09, Hari KT <kthari85@xxxxxxxxxxx> wrote: From: Hari KT <kthari85@xxxxxxxxxxx> Subject: Re: creating the php search script To: php-objects@xxxxxxxxxxxxxxx Date: Saturday, August 8, 2009, 6:04 AM ok dude some suggestions for you For the query please use mysql_escape( ) or mysql_realescape( ) when executing scripts in sql . Use phpmyadmin or what ever you like to check whether the query works right . Use an echo statement to print the query, keep an exit and test it with values ..... Eg : "select * from table where 1st_field like studentID=' ". mysql_escape( $ studentsID )." ' , Name='". mysql_escape( $ Name) . " ', address= ' ". mysql_escape( $address) ." ' ,phone='". mysql_escape( $ phone) ." ',sex= '". mysql_escape( $sex ) ." ', DOB= ' ". mysql_escape( $DOB ) . " order by 1st_field"; $numresults= mysql_query( $query2); It seems your query itself is wrong . You need to refer mysql select stament Hari K T http://harikt. com/ --- On Sat, 8/8/09, Gab Teo <doneatlast1000@ yahoo.com> wrote: From: Gab Teo <doneatlast1000@ yahoo.com> Subject: creating the php search script To: php-objects@ yahoogroups. com Date: Saturday, 8 August, 2009, 1:33 AM Please, I need help, I am trying to create a search on a website, the below error ( $numrows=mysql_ num_rows( $numresults) ; line 57) keep showing even after I have create the sql query in many forms, the error highlited in blue and the lne of the error in red on the php scrpt. Gab Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\ mydatabase\ search.php on line 57 Results Sorry, your search: "john" returned zero results Couldn't execute query <?php $var = @$_GET['q'] ; $trimmed = trim($var); //trim whitespace from the stored variable $limit=10; if ($trimmed == "") { echo "<p>Please enter a search...</p> "; exit; } if (!isset($var) ) { echo "<p>We dont seem to have a search parameter!</ p>"; exit; } mysql_connect( "localhost" ,"root"," "); //(host, username, password) mysql_select_ db("mydatabase" ) or die("Unable to select database"); //select which database we're using $query = "select * from table where 1st_field like studentID='$ studentsID' ,'Name='$ Name',address= '$address' ,phone='$ phone',sex= '$sex',DOB= '$DOB' \"%$trimmed% \" order by 1st_field"; $numresults= mysql_query( $query2); $numrows=mysql_ num_rows( $numresults) ; This is the line 57 if ($numrows == 0) { echo "<h4>Results< /h4>"; echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>" ; } if (empty($s)) { $s=0; } $query = " limit $s,$limit"; $result = mysql_query( $query2) or die("Couldn' t execute query"); echo "<p>You searched for: "" . $var . ""</p>" ; echo "Results"; $count = 1 + $s ; while ($row= mysql_fetch_ array($result) ) { $title = $row["1st_field" ]; echo "$count.) $title" ; $count++ ; } $currPage = (($s/$limit) + 1); echo "<br />"; if ($s>=1) { // bypass PREV link if s is 0 $prevs=($s-$ limit); print " <a href=\"$PHP_ SELF?s=$prevs& q=$var\"> << Prev 10</a> & nbsp;"; } $pages=intval( $numrows/ $limit); if ($numrows%$limit) { $pages++; } if (!((($s+$limit) /$limit)= =$pages) && $pages!=1) { $news=$s+$limit; echo " <a href=\"$PHP_ SELF?s=$news& q=$var\"> Next 10 >></a> "; } $a = $s + ($limit) ; if ($a > $numrows) { $a = $numrows ; } $b = $s + 1 ; echo "<p>Showing results $b to $a of $numrows</p> "; ?> [Non-text portions of this message have been removed] Looking for local information? Find it on Yahoo! Local http://in.local. yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
