RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group

2003-07-30 Thread Ow Mun Heng
Hi Ramil, I'm also facing a similar problem, I would like to get the list based on user Input. Please input 1st Letter of designers wanted : A, D, P I've tried using OR but it somehow screws things up. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168

RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group

2003-07-30 Thread Ow Mun Heng
: Wednesday, July 30, 2003 7:18 PM To: Ow Mun Heng; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Aaron Wolski Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group Where $string = 'A, D, P' $fstring = str_replace(',',',',$string); $query = SELECT * FROM Table WHERE

[PHP-DB] RE: Session help...

2003-07-29 Thread Ow Mun Heng
As mentioned previously in this list, $_SESSION and session_register, session_is_register, is not compatible with each other. Anyway, I used your idea as inspiration for my own code.. My code works.. Try to change From: if (!session_is_registered(valid_user)) { To: if

[PHP-DB] WHY need to query 2x to get results

2003-07-22 Thread Ow Mun Heng
Hi, I have a code that goes like this. Scroll down to the -- sign. How come I need another $result = mysql_query($sql) at that location? If I don't have it, the results coming out will only start printing from the 2nd Row.. Omitting the 1st. Results as wanted row 1

RE: [PHP-DB] WHY need to query 2x to get results

2003-07-22 Thread Ow Mun Heng
It worked like a charm. (initially I was trying to use reset() guess it was the wrong call) One other thing, The 1st call was supposed to get the Column Headers and the second to get the results. I thought they are independent of each other?? Guess not? thanks very much. Cheers, Mun Heng, Ow

[PHP-DB] Pros/Cons Database vs Excel

2003-07-22 Thread Ow Mun Heng
Hi, I'm having a problem convincing my boss of the benefits of using a database vs just using excel as a way of tracking events. The boss' stance is that excel is more 'simple' columns can be expanded as and when it's wanted. You can put links into excel that points to files

RE: [PHP-DB] getting MySQL column header?

2003-07-21 Thread Ow Mun Heng
Hey John, This is another person asking the same question as I did.. thanks again for your help.. :) Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, July