Re: keeping given order in resulset

2002-03-22 Thread Jayasimhan A
Try "order by id". All the best, Jayasimhan A - Original Message - From: Mickael Bailly <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 3:13 PM Subject: keeping given order in resulset > > Hello ! > > I got a table having an a

Re: group by timestamp field

2002-03-22 Thread Jayasimhan A
Hi!! You can try select format_date(field2, '%m %d %Y)as timestamp, count(*), field1 from mad group by field1 all the best, Jayasimhan A - Original Message - From: cristian ditoiu <[EMAIL PROTECTED]> To: mysql <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 1:20 PM

Re: fecth_array error

2002-01-23 Thread Jayasimhan A
Hi! Why dont u try this, if(mysql_num_rows($var1)>0) { mysql_free_result($var1); delete; } else { echo("record doesnot exists"); } cheers, Jayasimhan A - Original Message - From: Palafox, Alfredo <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: We