correct mysql syntax
Posted: Wed Sep 28, 2005 5:27 am
Hi there,
my issue:
Given this:
An update should be conducted on wt_licences with 2 data sets.
It's about the WHERE clause:
The field 'strLogin' is in another table (tblWebuser)
How can I get this working- with join?
Thanks
Jan
my issue:
Given this:
Code: Select all
UPDATE wt_licences SET
customer_id ='".$GLOBALS["webuser"]["id"]."',
domains =$amounttracker WHERE
strLogin='".addslashes($GLOBALS["webuser"]["strLogin"])."'" ;It's about the WHERE clause:
The field 'strLogin' is in another table (tblWebuser)
How can I get this working- with join?
Thanks
Jan