Hi
I have a option box with values
Less than 150.000
tot 175.000
tot 200.000
tot 250.000
tot 300.000
tot 350.000
tot 400.000
More than 400.000
I need help when the user
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
Sub
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?
>
> $wor
Dear all,
i need help with my search query statement.. what is wrong with my code?
$word = split(" ", $keyword);
$num_words = count($word);
$word_str = "";
$criteria = "";
for ($i=0; $i<$num_words; $i++)
{
if ($i)
$word_str .= "and colN
To start with:
Go to one of the on-line SQL tutorail sites and learn how to
formulate a query.
Then make a simple query, and figure out how it works.
After that add fields from related tables, one table at a time,
so that you can see the effect of how joining tables
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, ne
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.ty
where ContactID='$ID'";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if ($numrows>0) {
while ($list = mysql_fetch_array($result)) {
just echo the details that you need.
}}
Hope this is what you want
Kind Regards,
Cami
-Original Message-----
Fro
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 whi