sql update

[Anon]

Hi,

this may be a repost, but i forgot the subject...

I am trying to update a database... I have a stock line written:

$SQL = "UPDATE table SET compname='$compname',activities='$activities',url='$url',confirm_auth='$ath' where (date='$date')";

The problem is that i don't want the old values replaced with ' ' if the variables are null. Is there an elagant solution to this?

Thanks in advance.

[tinuviel]

HMM, don't know how elegant this is...but here goes:

$sql = "UPDATE table SET ";
if ($compname){
$sql .= "compane='".$compname."' ";
}
if ($activities){
$sql .= ",activities='".$activities."' ";
}
if ($url){
$sql .= ",url='".$url."' ";
}
if ($confirm_auth){
$sql .= ",confirm_auth='".$confirm_auth."' ";
}
$sql .= "where (date='$date')";

It may need some altering with the quotes and the comma if company name isn't used but activites is (there would be an extra comma in the front)
Hope this helps 🙂
Tinuviel

[Anon]

hmm, i was trying to avoid doing that, the table has a lot of fields.

thanks though,

ryan