Deleting data from 2 fields but not the whole row

big-dog

Is there a way to delete data from 2 fields in a table record?
I have a table with date1, time1, date2, time2, date3, time3, date4, time4
I would like to delete the data from date1, and time1
Something like this
DELETE FROM Venues WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= Date1';
but not the whole row also instead of just the date1 field delete the time1 field data as well then when the next date is 1 day old it deletes date2 and time2. and so on till date4 and time4 is 1 day old and it deletes the record.

I’m using a webpage to display records and want it to be updated or only show date and time if the date and corresponding time field is not in the past

dagon

UPDATE Venues set date1='', time1='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= Date1';

big-dog

So would I add 4 lines simular to the excample but change the dat1 time1 parts
and what or how would it delete the whole row at the last date time ie date4 time4

dagon

yes, and with delete

big-dog

errors out and dont know errors good enough to know what it is teliing me

mysql_select_db($db_name,$link);
$query = 'UPDATE Venues set date1='', time1='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date1`';
$query = 'UPDATE Venues set date2='', time2='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date2`';
$query = 'UPDATE Venues set date3='', time3='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date3`';
$query = 'DELETE FROM Venues WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date4`'; 
mysql_query($query);

Parse error: syntax error, unexpected T_STRING in /home5/public_html/venues/venuespg.php on line 18 Line 18 is the first update line

dagon

strings

big-dog

I tried this in mysql

UPDATE Venues set date_1='', time_1='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date_1`;
UPDATE Venues set date_2='', time_2='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date_2`;
UPDATE Venues set date_3='', time_3='' WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date_3`;
DELETE FROM Venues WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY) >= `Date_4`;

And it deleted all row even the ones two weeks from now

djjjozsi

example to put ' and " in a string:

$string="'";  

$string='\'';  

$string="\"";