Hi Beau,
I have a form that selects an rv electric record here is a snip and if you
need more tell me.
This just returns a blank page.
$current_date = date("M");
$pkwh =.064;
$get_electric = "SELECT * FROM electric WHERE rv_space = $row[rv_space]";
$result = mysql_query($get_electric) or die(mysql_error());
$row = mysql_fetch_array($result);
$tot_used = $row[end] - $row[begin];
$ppkwh = .064;
$sub_total = $tot_used * $ppkwh;
$puf = '11';
$total = $sub_total + $puf;
echo "<h1><center>Salmon Shores RV Park</center> </h1>";
echo "<h2><em>Electric Bill for Space $rv_space</em></h2>";
echo "Month $current_date";
echo "<body bgcolor=#00C0C0>";
echo "<table width= 100%><tr><td width='10%'>Space </td><td> Begin</td><td>
End</td><td>Total KWH Used</td><td>Subtotal</td><td>Public Use
Fee</td><td>Total</td>";
echo "<tr><center><td width='10%'>$rv_space</em></td><td
width='10%'>$row[begin]</td><td width='10%'>$row[end]</td><td
width='15%'>$tot_used</td><td width='10%'>$sub_total</td><td
width='12%'>$puf.00</td><td>$total</td></center></table>";
echo "<p><a href='index.php'>Return to Main Menu</a> or<BR>";
echo "<a
href='search_elec_space_record.php?record=$row[rv_space]-1'>Previous
Record</a></p>";
echo "<a href='search_elec_space_record.php?record=$row[rv_space]+1'>Next
Record</a></p>";
echo "<a href='search_elec_space.php'>Search Another Record</a></p>";
I can get the first record say I choose space 35 if I click the link for
$row[rv_space]+1 then it returns a blank page what can I do to fix this?
Thanks again
Jennifer
"Beau Lebens" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> jen,
> assuming you are "currently" looking at a page which is something like
> php.php?record=3, then you should be able to just do
>
> <a href='php.php?record=<?php echo ($record-1) ?>'>Previous record</a><a
> href='php.php<?php echo ($record+1) ?>'>Next record</a>
>
> and then on the php.php page, you would obviously being grabbing something
> from the database using a unique identifier or similar.
>
> one "gotcha" to be careful of - if there is a chance that your id field
will
> have a gap in it (ie. not be perfectly consecutive) then you should make
> your query something like
>
> SELECT * FROM table LIMIT $record, 1
>
> rather than
>
> SELECT * FROM table WHERE id='$record'
>
> Since that takes them in whatever order, but only SELECTs from $record and
> gets 1 record.
>
> HTH
>
> Beau
>
>
> // -----Original Message-----
> // From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
> // Sent: Monday, 13 May 2002 1:14 PM
> // To: [EMAIL PROTECTED]
> // Subject: [PHP-DB] Link for next db record
> //
> //
> // Hi all,
> //
> // Wondering if you could help or point me to a tut where I
> // can use a link to
> // get the next record in the db?
> //
> // Like <a href='php.php'>Previous record</a><a
> // href='php.php'>Next record</a>
> //
> // How do I go about doing this.
> //
> // Thanks
> // Jennifer
> //
> // --
> // The sleeper has awaken
> //
> //
> // ---
> // Outgoing mail is certified Virus Free.
> // Checked by AVG anti-virus system (http://www.grisoft.com).
> // Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
> //
> //
> //
> // --
> // PHP Database Mailing List (http://www.php.net/)
> // To unsubscribe, visit: http://www.php.net/unsub.php
> //
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
