need help urgently

[dudeky]

Can some one help me with this code? I need some modification..

this is a working search result code.. the problem is the display part.. when the search results were found it will display example 10 rows in a page but it has no break..

the number page is shown like this.

[1] [2] [3] [4] [5] [6] ...

it will continue to go until no end if the results are huge.

I need a previous and next option, each page only display 1 - 10.

look like this:

<< previous [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] Next >>>

Can some one help me?

Another problem is I can't display the message that there is no result found.. really cause me headache.

here is my code:

<?
require ("config.php") ;
if (!IsSet($page))
{
$page=1 ;
}
$start_num = ($page-1)* $ads_pro_page ;

$end_num = $start_num + $ads_pro_page ;

if ($work=="1")
$work2="" ;
else
$work2="work='".$work."'" ;

$stampmebaby =getdate(time()) ;
$day= $stampmebaby[mday] ;
$month=$stampmebaby[mon] ;
$year=$stampmebaby[year] ;

$year1=$year-$Age1 ;

$year2=$year-$Age2 ;

$checkage="(( bday<='$day' AND bmonth<='$month' AND byear='$year1' ) OR ( byear<'$year1' )) AND (( bday<='$day' AND bmonth<='$month' AND byear='$year2' ) OR ( byear>'$year2' ))" ;

include ("config.php") ;

$query="SELECT * FROM money WHERE ".$checkage." ".$where." order by ID desc" ;
$result = mysql_query($query)
or die(mysql_error());

$n = 1 ;

while ($row = mysql_fetch_array($result) )
{

$stampmebaby =getdate(time()) ;
$day= $stampmebaby[mday] ;
$month=$stampmebaby[mon] ;
$year=$stampmebaby[year] ;

$age_year= $year-$row[byear] ;
$age=$age_year ;

if ($month>=$row[bmonth] AND $day>=$row[bday])
$age=$age_year ;
else
$age=$age_year-1 ;

if ( $n>$start_num and $n<=$end_num)
{

?>

My Work Search results: <? echo $row[10]; ?>

<?

}
else
{
echo("Sorry, no results") ; // This pasrt cannot be display if no result.. I do not know why???? PLease help
}

$n = $n + 1 ;

}

echo ("<table>");
$total_records = mysql_num_rows($result) ;
$number_pages = 1 + $total_records / $ads_pro_page ;

$aarrgghh1=urlencode($Age1);
$aarrgghh2=urlencode($Age2);
$aarrgghh=urlencode($country);

echo ("<tr>");
$c = 1 ;
while ($c <= $number_pages)
{
echo ("<TD WIDTH=\"20,\" ALIGN=\"LEFT\"><a HREF=\"$PHP_SELF?Age1=$aarrgghh1&Age2=$Age2&work=$aarrgghh&page=$c\">$c</a></td>") ;
$c = $c + 1 ;
}
echo ("</tr></TABLE>") ;

?>

Million thanks to those that help.

[cgraz]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10219415&highlight=display

Cgraz

[dudeky]

Cgraz

how do I insert into my code...?

[cgraz]

Did you read the comments? It is 110% commented.

Cgraz

[dudeky]

I can't blend your code into mine at all..
I don;t know how..

can you tell me which part on my code should I change?

[cgraz]

this part:

$server = "localhost";
$username = "user";
$password = "pass";
$database = "your_db";
$table = "your_table";

this part: (if you want 10 results per page, change 1 to 10)

// set number of results to display per page
$pagelimit = "1";

this part:

// run query (change yourtable to the name of your table)
$strSQL = mysql_query("SELECT * FROM $table");

anywhere you see yourpage.php,replace with the name of your script

thent his

$strSQL = mysql_query("SELECT * FROM $table LIMIT $start,$pagelimit");

notice how this query is EXACTLY the same as the first query, only with the LIMIT $start.. . part

then just display your results however you want.

Cgraz

[dudeky]

hmm.. I mean which part of MY code do I need to change.. I am really lost..

[cgraz]

ok, i did the best to include all your code, so if somethings not working right, just modify it. I may have left out some of your code. Look at ALL the comments and do as they say. In particular, put in your mysql specs (where i specify) and towards the end of the code in the while loop, display the results as you wish.

<?

include("config.php");

// put in your mysql variables here

$server = "localhost";
$username = "user";
$password = "pass";
$database = "your_db";
$table = "your_table";


if ($work=="1") {
   $work2="" ; 
} else {
   $work2 = "work='" . $work . "'"; 
}

$stampmebaby = getdate(time()); 
$day= $stampmebaby[mday]; 
$month=$stampmebaby[mon]; 
$year=$stampmebaby[year]; 

$year1 = $year-$Age1; 

$year2=$year-$Age2; 

$checkage ="(( bday<='$day' AND bmonth<='$month' AND byear='$year1' ) OR ( byear<'$year1' )) AND (( bday<='$day' AND bmonth<='$month' AND byear='$year2' ) OR ( byear>'$year2' ))" ; 




// Connect To MySQL Server
@mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database
@mysql_select_db($database) or die("Couldn't Select Database");

// set number of results to display per page
$pagelimit = "10";

// run query (change yourtable to the name of your table)
   $strSQL = mysql_query("SELECT * FROM money WHERE " . $checkage. " " . $where . " ORDER BY ID desc") or die(mysql_error());

// count number of matches
   $totalrows = mysql_num_rows($strSQL);

// determine how many pages there will be by using ceil() and dividing total rows by pagelimit
   $pagenums = ceil ($totalrows/$pagelimit);

// if no value for page, page = 1
    if ($_GET["page"] == ''){
        $page = '1';
    }
// create a start value
    $start = ($page-1) * $pagelimit;

// blank matches found
echo "<b>" . $totalrows . " matches found</b><br>\n";

// Showing Results 1 to 1 (or if you're page limit were 5) 1 to 5, etc.
$starting_no = $start + 1;

if ($totalrows - $start < $pagelimit) {
   $end_count = $totalrows;
} elseif ($totalrows - $start >= $pagelimit) {
   $end_count = $start + $pagelimit;
}


echo "Results $starting_no to $end_count shown.<br>\n";

// create dynamic next, previous, and page links

/* lets say you're set to show 5 results per page and your script comes out with 7 results.
this will allow your script to say next2 if you're on the first page and previous5 if you're on the second page. */

if ($totalrows - $end_count > $pagelimit) {
   $var2 = $pagelimit;
} elseif ($totalrows - $end_count <= $pagelimit) {
   $var2 = $totalrows - $end_count;
}

$space = "&nbsp;";

// previous link (make sure to change yourpage.php to the name of your page)
if ($_GET["page"] > 1) {
        echo "« <a href='$PHP_SELF?page=".($page-1)."' class=main>Previous" . $space . $pagelimit . "</a>" . $space . $space . "";
    }

// dynamic page number links (make sure to change yourpage.php to the name of your page)

for ($i=1; $i<=$pagenums; $i++) {
    if ($i!= $_GET["page"]) {
        echo " <a href='$PHP_SELF?page=$i' class=main>$i</a>";
    }
    else {
        echo " <b>$i</b>";
    }
}


// next link (make sure to change yourpage.php to the name of your page)

if ($_GET["page"] < $pagenums) {
    echo "" . $space . $space . $space . $space . " <a href='$PHP_SELF?page=".($page+1)."' class=main>Next " . $var2 . "</a> »";
}


   $strSQL = mysql_query("SELECT * FROM money WHERE " . $checkage. " " . $where . " ORDER BY ID desc LIMIT $start,$pagelimit");

while($row = mysql_fetch_array($strSQL)) {

// display the results here however you want



}



?>

Cgraz

[dudeky]

thanks! I try it now.

[dudeky]

hi,

got some errors.

you said:

// previous link (make sure to change yourpage.php to the name of your page)

if ($_GET["page"] > 1) {
echo "« <a href='$PHP_SELF?page=".($page-1)."' class=main>Previous" . $space . $pagelimit . "</a>" . $space . $space . "";
}

you mean change the page inside the ($_GET["page"] > 1) ?

(make sure to change yourpage.php to the name of your page)

where is it?

[cgraz]

don't worry about it, $PHP_SELF takes care of that.

Cgraz

[dudeky]

ok, it can display out the result with the numbers

[1] [2] [3]... next 10 >>

but when I click on the numbers or on the next 10 >> it display blank... and when I click << previous it display blank page also, why is it so?

[dudeky]

I get the problem.

My result shown 15, and it should display only 10 rows per page.

It did show

[1] [2] Next 10 >>

after I clicked on submit it did displayed the 10 result on first page but when I clicked on the number 2 page, it show blank, and when I clicked on previous 10, it show blank also, 15 results only display 10, 5 missing..

how to solve this problems? thanks alot

[cgraz]

change

if ($_GET["page"] == ''){
    $page = '1';
}

to

if ($_GET["page"] == '') {
    $_GET["page"] = '1';
}

Cgraz

[dudeky]

hi, this time no result is deisplay..

[cgraz]

do you have globals set to on or off? Meaning when you access form variables, can you simply use $var_name or do you have to use $_POST['var_name']

Cgraz

[dudeky]

I have to use $_POST['var_name']

so how?