Can any one see anything wrong with this code

[GPCoin]

Ive made this code:

<?php

$button = $_GET['submit'];
$search = $_GET['search'];


$s = $_GET['s'];
if (!$s)
$s = 0;


$e = 10; 


$next = $s + $e;
$prev = $s - $e;




if (strlen($search)<=2)
  echo "Must be greater then 3 chars";
else
{
  echo "<br /><table><tr><td><img src='juzzy.jpg' /></td><td><form action='search.php' method='GET'><input type='text' onclick=value='' size='50' name='search' value='$search'> <input type='submit' name='submit' value='Search'></form></td></tr></table>";
  
  
  mysql_connect("localhost","*********","*******");
  mysql_select_db("************");
   
   
   $search_exploded = explode(" ",$search);
   
   foreach($search_exploded as $search_each)
   {
   
        
    $x++;
    if ($x==1)
     $construct .= "keywords LIKE '%$search_each%'";
    else
     $construct .= " OR keywords LIKE '%$search_each%'";
   
   }
   

  $constructx = "SELECT * FROM searchengine WHERE $construct";
  
  $construct = "SELECT * FROM searchengine WHERE $construct LIMIT $s,$e";
  
  $run = mysql_query($constructx);
  
  $foundnum = mysql_num_rows($run);  //here is the thing which is causing the error.

  $run_two = mysql_query("$construct");
  
  if ($foundnum==0)
   echo "No results found for <b>$search</b>";
  else
  {
   echo "<table bgcolor='#0000FF' width='100%' height='1px'><br /></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><div align='right'>Showing 1-10 of <b>$foundnum</b> results found for <b>$search.</b></div></td></tr></table><p>";
   
   while ($runrows = mysql_fetch_assoc($run_two))
   {
   
   $title = $runrows['title'];
   $desc = $runrows['description'];
   $url = $runrows['url'];
   
   echo "<table width='300px'>
   <h4><a href='http://$url'><b>$title</b></a><br />
   $desc<br>
   <font color='00CC00'>$url</font></table></h4>
   ";
   }
?>

<table width='100%'>
<tr>
<td>
<div align="left">

<?php
if (!$s<=0)
echo "<a href='search.php?search=$search&s=$prev'>Prev</a>";

$i =1; 
for ($x=0;$x<$foundnum;$x=$x+$e)
{


echo " <a href='search.php?search=$search&s=$x'>$i</a> ";


$i++;


}

if ($s<$foundnum-$e)
  echo "<a href='search.php?search=$search&s=$next'>Next</a>";

}
}  


?>
</div>
</td>
</tr>
</table>

 

And when ive uploaded it to the host and tryed to search using it (this is just the main code, not the index code) it comes up with this one error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/seanhall/public_html/Search/search.php on line 54

[anevins]

What is line 54

[GPCoin]

ive marked it

  $run = mysql_query($constructx);
  
  $foundnum = mysql_num_rows($run);  //here is the thing which is causing the error.

  $run_two = mysql_query("$construct");

[creata.physics]

That means your query is getting an error.

 

echo $contructx;

copy the query it echos.

when you get that query, run it in phpmyadmin, it should tell you what the error is.

[GPCoin]

i dont understand?.

[kenrbnsn]

Change

<?php
$run = mysql_query($constructx);
?>

to

<?php
$run = mysql_query($constructx) or die("Problem with the query: $constructx<br>" . mysql_error());
?>

This should tell you the problem.

 

Ken