Re: [PHP] Looking for pointers to mysql functions

2004-11-11 Thread bbonkosk
This would be handled in your query, so get a SQL book or look into the mysql documentation... Look at the select statement, to request specific fields, as well as the Limit keyword to return a certain number of results per page. -B - Original Message - From: Stuart Felenstein [EMAIL

Re: [PHP] Looking for pointers to mysql functions

2004-11-11 Thread Stuart Felenstein
--- [EMAIL PROTECTED] wrote: This would be handled in your query, so get a SQL book or look into the mysql documentation... Look at the select statement, to request specific fields, as well as the Limit keyword to return a certain number of results per page. -B So there is no php

RE: [PHP] Looking for pointers to mysql functions

2004-11-11 Thread Graham Cossey
-Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 11 November 2004 11:32 To: [EMAIL PROTECTED] Subject: [PHP] Looking for pointers to mysql functions I'm building a search function and I think most of the search part is solid. Now I'm trying to

RE: [PHP] Looking for pointers to mysql functions

2004-11-11 Thread Stuart Felenstein
--- Graham Cossey [EMAIL PROTECTED] wrote: Is this something like what you are after: ?php $sql = SELECT col1, col2, col3, col4 as colx, col5 FROM my_table WHERE col2 LIKE '%$search%' ORDER BY col3 LIMIT $from, $max_results; $result =

Re: [PHP] Looking for pointers to mysql functions

2004-11-11 Thread bbonkosk
- Original Message - From: Stuart Felenstein [EMAIL PROTECTED] Date: Thursday, November 11, 2004 7:13 am Subject: Re: [PHP] Looking for pointers to mysql functions --- [EMAIL PROTECTED] wrote: This would be handled in your query, so get a SQL book or look into the mysql