[PHP-DB] search query

2004-09-15 Thread peppe
Hi I have a option box with values select name=prijsklasse class=bodyzwart id=prijsklasse option value=1 selectedLess than 150.000 option value=2tot 175.000 option value=3tot 200.000 option value=4tot 250.000 option

RE: [PHP-DB] Search Query

2003-12-18 Thread Ford, Mike [LSS]
On 18 December 2003 05:26, Ng Hwee Hwee wrote: Dear all, i need help with my search query statement.. what is wrong with my code? Nothing obvious that I can see, except a little inefficiency. Where do $keyword and $table come from? -- is this a register_globals issue? snip $word

Re: [PHP-DB] Search Query

2003-12-18 Thread Ng Hwee Hwee
thanx Mike for your help!! appreciatively, hh - Original Message - From: Ford, Mike [LSS] [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; DBList [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 6:06 PM Subject: RE: [PHP-DB] Search Query On 18 December 2003 05:26, Ng Hwee

[PHP-DB] Search Query

2003-12-17 Thread Ng Hwee Hwee
Dear all, i need help with my search query statement.. what is wrong with my code? snip $word = split( , $keyword); $num_words = count($word); $word_str = ; $criteria = ; for ($i=0; $i$num_words; $i++) { if ($i) $word_str .= and colName

[PHP-DB] search query problem

2003-07-26 Thread Ahmed
hi i am making a simple search form how can i search more than one table for the same word i used a query and it failed here it is @ $db = mysql_connect("localhost");mysql_select_db("egycds"); $test_tr = mysql_query("select newdvd.date, newpcgames.date, olddvd.date,

[PHP-DB] search query problem

2003-07-26 Thread Ahmed Abdelaliem
hi i am making a simple search form how can i search more than one table for the same word i used a query and it failed here it is @ $db = mysql_connect(localhost); mysql_select_db(egycds); $test_tr = mysql_query(select newdvd.date, newpcgames.date, olddvd.date, screener.date, newdvd.type,

[PHP-DB] Search Query

2001-07-27 Thread Steve Fitzgerald
I'm trying to build a search query that will allow users to search (via a textbox) different tables. For example, I have a table name contacts with columns ContactID, FirstName, LastName, and Active. I want to be able to search for John Smith or Smith where Active=yes (as opposed to Active=no