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
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
You'll need three pages:
in the first one put
submit it to the second page where you have:
$sql = "select * from contacts where (FirstName like '%$contactname%' or
LastName like '%$contactname%') and Active='yes' order by ID";
$result = mysql_query($sql);
$numrows = mysql_num_rows(