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
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
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
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
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,
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,
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