Re: MySQL Query Help Needed

2003-09-17 Thread Petre Agenbag
I think the most difficult ( if not impossible with just using mysql query) is the part where you apply your logic as to the "most relevant" keyword. You need to be able to have a mechanism of telling the query which keyword is the most relevant, ie, human logic says, the one that matches the searc

Re: MySQL Query Help Needed

2003-09-17 Thread Petre Agenbag
Not sure I understand what you need? Can you create a dummy output table of what you would like your result to look like? At first glance, from reading your question, it sounds like you simply want this: select * from ppc_keywords where keywords like "%job%" [group by keywords] order by bid; whe

MySQL Query Help Needed

2003-09-17 Thread Johan Potgieter
Can anybody help me sort my results in the correct way. My Table description is: +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | id

Re: Mysql query help needed!!

2002-06-16 Thread Zak Greant
Hi Chris, On Fri, 2002-06-14 at 02:08, Chris Kay wrote: > > I have a rather longer query which I would like to get all records past todays date. >Here is my query > > $ttwo = date("YmdGi"); > >'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_

Mysql query help needed!!

2002-06-13 Thread Chris Kay
I have a rather longer query which I would like to get all records past todays date. Here is my query $ttwo = date("YmdGi"); $abc = " select detail.*, type.type_name, status.status_name, staff.staff_name,