Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2000071

Re: [PHP] Database Browsing From: Alex Black (enigma <email protected>)
Date: 07/03/00

well, you can do that with mySQL and SQLServer, but not with oracle.

bummer :)

_a 

--
Alex Black, Head Monkey
enigma <email protected>

The Turing Studio, Inc.
http://www.turingstudio.com

vox+510.666.0074
fax+510.666.0093

Saul Zaentz Film Center
2600 Tenth St Suite 433
Berkeley, CA 94710-2522

> From: smasiello <email protected> ("Sam Masiello")
> Newsgroups: php.general
> Date: 3 Jul 2000 07:59:14 -0700
> Subject: RE: [PHP] Database Browsing
> 
> 
> If you want to limit the number of records you receive by query, you can use
> the LIMIT suffix with your query.  For example, if you want to display the
> first 5 records based on some certain criteria, you can do:
> 
> SELECT <fields> FROM <table> WHERE ... .. ...  LIMIT 0,5
> 
> Or you can do:
> 
> SELECT <fields> FROM <table> WHERE ... .. .. ORDER BY <some_field_list>
> LIMIT 0,5
> 
> Then if the user clicks that they want to see the next page, display your
> records using:
> 
> SELECT <fields> FROM <table> WHERE ... .. .. ORDER BY <some_field_list>
> LIMIT 6,10
> 
> Etc etc....perhaps control which group of results to show with some sort of
> flag on your page which is modified depending on which group of results that
> you want to display to your user.
> 
> 
> Sam Masiello
> System Analyst
> Chek.Com
> (716) 853-1362 x289
> smasiello <email protected>
> 
> -----Original Message-----
> From:  Sean Mathews [mailto:smathews <email protected>]
> Sent: Monday, July 03, 2000 10:56 AM
> To: php-general <email protected>
> Subject: [PHP] Database Browsing
> 
> Hey Guys
> 
> I was wondering if anyone would be willing to provide some theory as to how
> to implement database browsing (preferably without altering the structure of
> the DB).  You know like in a web server, where you can limit the number of
> hits, and the browse them page by page.
> 
> Thx
> Sean
> 
> 
> 
> 
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>