A little bit of SQL help.
Posted: Sun Sep 18, 2005 8:00 am
Hi Guys,
Can any of you give me advice on how this SQL would work?
Would it update all the columns in the database where the companyname and coursetitle are?
or would it update just one?
Thanks in advance.
Can any of you give me advice on how this SQL would work?
Would it update all the columns in the database where the companyname and coursetitle are?
or would it update just one?
Code: Select all
$status = "ONLINE";
$sql = "UPDATE courses SET status='$status' WHERE coursetitle='$_SESSION['coursetitle']' AND companyname='$_SESSION['companyname']' ";