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 >

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: > > $sql = "SELECT col1, col2, col3, col4 as colx, col5 > FROM my_table > WHERE col2 LIKE '%$search%' > ORDER BY col3 > LIMIT $from, $max_results"; > > $result = mysql_que

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 try

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

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