Re: Blasted #$%$^$^ host has v3.23 when i need UNION

2003-09-15 Thread Mixo Shiburi
You may also want to look at http://www.php.net/manual/en/function.mysql-num-rows.php Ryan A wrote: Hey, Thanks for replying. Nope, the whole reason for selecting the data is the count, i need to display to the client how many records of each category he has...if there is any other way to do that (

Re: Dates

2003-09-01 Thread Mixo Shiburi
Joseph Bueno wrote: . . . rt3=# select age(now(),'2003-08-26'::timestamp); age 6 days 10:14:43.421275 +++ Thanks, and select age('2003-08-26',resolved) where 'resolved' is a 'timestamp'. -- MySQL General Mailing List For list archi

Dates

2003-09-01 Thread Mixo Shiburi
I am in the process of porting some python scripts to Mysql. Currently, the scripts I have queries a Pg database for entries (made) between certain dates. The python script snippet of the query mainQuery = """ select distinct id,queue,owner,created,now(),age