GPCoin Posted March 20, 2011 Share Posted March 20, 2011 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 Quote Link to comment Share on other sites More sharing options...
anevins Posted March 20, 2011 Share Posted March 20, 2011 What is line 54 Quote Link to comment Share on other sites More sharing options...
GPCoin Posted March 20, 2011 Author Share Posted March 20, 2011 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"); Quote Link to comment Share on other sites More sharing options...
creata.physics Posted March 20, 2011 Share Posted March 20, 2011 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. Quote Link to comment Share on other sites More sharing options...
GPCoin Posted March 20, 2011 Author Share Posted March 20, 2011 i dont understand?. Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 20, 2011 Share Posted March 20, 2011 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.