Re: [PHP] Next and Previous links

[Jason Wong]

On Friday 09 August 2002 22:35, webmaster wrote:

> Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
> requires at least 2 parameters where all the examples I find only use
> 1.  Is this a DB configuration problem?

Did you try the obvious step of consulting the manual?

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/*
HELLO KITTY gang terrorizes town, family STICKERED to death!
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Next and Previous links

[webmaster]

I found an answer for anyone who may be interested on phpbuilder.com

 http://phpbuilder.com/annotate/message.php3?id=1010986

-Elkan

webmaster wrote:

> Hello,
>
> I've been trying write a .php page that displays 10 results per page
> with links to the next 10 avail.  I've found a couple examples on how to
> do this with MySQL, and I tried to convert it to work with Postgres with
> no luck.  Has anyone ever done this using PHP4.0.6 and Postgres 7.1?
>
> Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
> requires at least 2 parameters where all the examples I find only use
> 1.  Is this a DB configuration problem?
>
> Thanks in advance,
> -Elkan
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Next and Previous links

[Brian V Bonini]

Could you send me the URL's for the MySQL examples? Thanks!!

> -Original Message-
> From: webmaster [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Next and Previous links
> 
> 
> Hello,
> 
> I've been trying write a .php page that displays 10 results per page
> with links to the next 10 avail.  I've found a couple examples on how to
> do this with MySQL, and I tried to convert it to work with Postgres with
> no luck.  Has anyone ever done this using PHP4.0.6 and Postgres 7.1?
> 
> Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
> requires at least 2 parameters where all the examples I find only use
> 1.  Is this a DB configuration problem?
> 
> Thanks in advance,
> -Elkan
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Next and Previous links

[webmaster]

Hello,

I've been trying write a .php page that displays 10 results per page
with links to the next 10 avail.  I've found a couple examples on how to
do this with MySQL, and I tried to convert it to work with Postgres with
no luck.  Has anyone ever done this using PHP4.0.6 and Postgres 7.1?

Also, I keep getting an error that pg_fetch_row() and pg_fetch_array()
requires at least 2 parameters where all the examples I find only use
1.  Is this a DB configuration problem?

Thanks in advance,
-Elkan


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] next and previous links

[Mick Fitzpatrick]

Hello

After several days of reading various articles on the web I've 'finally' got
a basic database working. The database is for a massive collection of my
vinyl records. Therefore I would like to limit the results to about 20 per
page and move forward/backward with 'next' and 'previous' links.

I'd like to stress at this stage that I'm new to PHP and don't really know
and 'tech speak' related to it ... however I like to think I'm a quick
learner :-)

Below I've pasted a copy of the script I fashioned ... I suppose it's full
of mistakes but it does work!

Any assistance will be appreciated

TIA ... Mick

***




artistsasidebsidelabelnumberpriceoriginformatinfo


" .
$row["artists"] . "" . $row["aside"] .
"" . $row["bside"] . "" . $row["label"] . "" .
$row["number"] . "" . $row["price"] .
"" . $row["origin"] . "" . $row["format"] . "" .
$row["info"] . "");

} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>






-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]