Searching and displaying

[lancey10]

ok im having problems with a script, what have i done wrong:

i made a search submit page that looks like:

<form action="search.php" method="post" enctype="multipart/form-data">
            <strong>Search our site</strong>:
        <input type="text" name="name" id="search" size="50"/>
        <input type="hidden" name="mode" value="search"/>
        <input class="button" type="submit" value="Go!" />
        </form>

and a retreive page with a query like:

$query = "SELECT * FROM $table LIKE '%$searchArray%' ORDER by data DESC LIMIT $limitvalue, $pp " or die ('cant select namemap');

is this correct

[Kudose]

SELECT * FROM $table WHERE column_name LIKE '%$searchArray% ORDER BY ...

Although I dont know how great your results will be using an array, usually the array is broken up into strings and each string is searched in the DB.

[lancey10]

well for the entire code i got this:

<?

function per_page($link, $offset) {
  global $numofpages, $page;
  $numofpages = round($numofpages);

  $pagesstart = round($page-$offset);
  $pagesend = round($page+$offset);

  if ($page != "1" && round($numofpages) != "0") {
    echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">&laquo;</font></a>&nbsp; ');
  }

  for($i = 1; $i <= $numofpages; $i++) {
    if ($pagesstart <= $i && $pagesend >= $i) {
      if ($i == $page) {
        echo "<b>[$i]</b>&nbsp;";
      }
      else {
        echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a>&nbsp; ');
      }
    }
  }
  if (round($numofpages) == "0") {
    echo "[$i]";
  }

  if ($page != round($numofpages) && round($numofpages) != "0") {
    echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">&raquo;</font></a>');
  }
}


/* Connect to mysql */
$db=mysql_connect ("BLOCKED","BLOCKED","BLOCKED") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("db154983921");



/* Set How many results to display per page */
$pp = "40";

/* Select the table that you want to view, you can add things like WHERE something='something' */
$table = "namemap";

$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table"),0);
$numofpages = $total / $pp;   

if (!isset($_GET['page'])) {
  $page = 1;
}
else {
  $page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
$searchArray = $_POST;
/* Display the rows */
$query = "SELECT * FROM $table WHERE column_name LIKE '%$searchArray%' ORDER by data DESC LIMIT $limitvalue, $pp " or die ('cant select namemap');
$result = mysql_query($query);

//$i=1;
//$color1 = '#717171';
//$color2 = '#464646';
function kMGTB($size)
{
  $kB = 1024;
  $MB = $kB*1024;
  $GB = $MB*1024;
  $TB = $GB*1024;

  if($size < $MB)
    return (round($size/$kB, 2)).' kB';
  elseif($size < $GB)
    return (round($size/$MB, 2)).' MB';
  elseif($size < $TB)
    return (round($size/$GB, 2)).' GB';
  else
    return (round($size/$TB, 2)).' TB';
} 

while($r=mysql_fetch_array($result)){
$seeds = $r['seeds'];
$leechers=$r['leechers'];
echo '<table class="main_table" width=100%>
<tr>
  <td width=19%>
<font size=2>
'.$r['data'].'</font></td>
<td width="58%" align="center"><div align="left"><a href="torrents.php?mode=details&amp;id=">'.$r['filename'].'</a></div></td>
<td width="10%"><div align="center"><font size=2>'.kMGTB($r['size']).'</font></div></td>
<td width="6%"><div align="right"><font size=2>
<div class='.(($seeds<50)?'r':'g').'>
'.$r['seeds'].'</div></font></td>
<td width="7%"><div align="right"><font size=2><div class=b>'.$r['leechers'].'</div></font></td>
</tr>
</table>'; }
//$i++;
/* Display the pages down the bottom */
echo '<br>Pages: '.round($numofpages).'<br>';

per_page("?page=%page", "5");

?>

and for some reason i tried ur code and still no luck

[Kudose]

I'm not saying this IS the problem, but I noticed you didnt change column_name to reflect the name of the column you are searching. If there are multiple, you will need to specify that:

SELECT * FROM table WHERE column1 LIKE 'string' OR column2 LIKE 'string' OR column3 LIKE 'string' WHERE ...

[lancey10]

oh so by column #, ahhh i c, and not by column name?

[lancey10]

so i inserted:
$query = "SELECT * FROM $table WHERE column_filename LIKE '%$searchArray%' ORDER by data DESC LIMIT $limitvalue, $pp " or die ('cant select namemap');

is this ocrrect? because "filename" is the name of the column, and its like the second culumn

[Kudose]

SELECT * FROM $table WHERE filename LIKE '%$searchArray%' ...

http://dev.mysql.com/doc/refman/5.0/en/select.html

[lancey10]

ahh ok, thganks
simple enough