I have the following $sql statement in a PHP script:
is it possible to include a Truncate command on a tables TABLE1,TABLE2 within this bit of code prior to running the INSERT statement? I basically need to empty some tables before I INSERT. How do I best do this?
$sql = "INSERT INTO simages (sImage_Name) VALUES ('".$record[$primary_key]."_".$record[$mls_key]."')";