This topic is locked

$StrUpdate two tables

9/4/2008 8:00:43 AM
PHPRunner General questions
M
motfuz author

Hi,
//global $conn;

//$strUpdate = "update _tbl_order set o_statusfactuur = 'wel'";

//db_exec($strUpdate,$conn);
This event works fine, but I want to add a where clause in this event: where _tbl.product.abonnement = 'nee'
I keep getting errors because I use two tables. Please help me with this event.
Thnx,
Wim

J
Jane 9/5/2008

Hi,
you can't update one table with where clause for another table.

Please clarify what you want to achieve and I'll try to help you.