jarv
07-30-2008, 12:00 PM
All i get is a blank screen
html form:
<form action="search_results.php" class="searchform" method="POST" name="search">
<input type="textbox" value="Search" name="hsearch" class="searchbox" onFocus="document.forms['search'].elements['hsearch'].value = ''" onBlur="document.forms['search'].elements['hsearch'].value = 'Search'" />
<input name="hsearch" class="button" value="Search" type="submit" />
</form>
php
<?php
$Searchresult = $_GET['hsearch'];?>
<?php
// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = "SELECT * FROM Headertbl WHERE HeaderName like %".$Searchresult."% ORDER BY HeaderDate DESC LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . $query);
$i=0;
while($row = mysql_fetch_array($result)){
echo "animatedcollapse.addDiv('jason$i', 'hide=1', 'fade=1,height=180px')\n";
$i++;
}
?>
html form:
<form action="search_results.php" class="searchform" method="POST" name="search">
<input type="textbox" value="Search" name="hsearch" class="searchbox" onFocus="document.forms['search'].elements['hsearch'].value = ''" onBlur="document.forms['search'].elements['hsearch'].value = 'Search'" />
<input name="hsearch" class="button" value="Search" type="submit" />
</form>
php
<?php
$Searchresult = $_GET['hsearch'];?>
<?php
// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = "SELECT * FROM Headertbl WHERE HeaderName like %".$Searchresult."% ORDER BY HeaderDate DESC LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . $query);
$i=0;
while($row = mysql_fetch_array($result)){
echo "animatedcollapse.addDiv('jason$i', 'hide=1', 'fade=1,height=180px')\n";
$i++;
}
?>