[PHP-DB] order by group by...

2001-09-16 Thread hassan el forkani
hi, i am trying to build a message board in php with mysql as back end; what i want to do is to query the database in a certain way that the result is returned in the correct order for php to display the discussion thread properly here is my table structure: mysql> show fields from posts -> ; +-

Re: [PHP-DB] Re: Search Results - Next 10 records

2001-09-03 Thread hassan el forkani
hi ...and to be able to know the exact number of pages do $result = mysql_query("select count(*)"); $nb_pages = $result/$nb_records_per_page; et voila! add this to marcus's suggestion and you have a full paging script, if you want some inspiration check out http://phpclasses.upperdesign.com i

[PHP-DB] order by group by...

2001-08-31 Thread hassan el forkani
hi, i am trying to build a message board in php with mysql as back end; what i want to do is to query the database in a certain way that the result is returned in the correct order for php to display the discussion thread properly here is my table structure: mysql> show fields from posts -> ; +-

Re: [PHP-DB] Getting info from Cookie

2001-08-15 Thread hassan el forkani
$http_cookie_vars['name_of_cookie'] At 09:57 15/08/01, Cato Larsen wrote: >Hi! >How can you extract a certain form of info from a Cookie? > >Im my case the cookie name is "crispy". It has been stored with a session id >and a charnick. > >How do I extract the charnick and use it in the page as "$

Re: [PHP-DB] True and Flase in mysql !!

2001-05-10 Thread hassan el forkani
you could also use a char(0) field in which case you can only have two possible records: NULL and ' ' (empty string) regards 09/05/01 22:42:04, "Zak Greant" <[EMAIL PROTECTED]> wrote: >Use an enum field. > >--zak > > >- Original Message - >From: "DesClub.com" <[EMAIL PROTECTED]> >To: