Page 1 of 1

Check data from database through query BY "WHERE"

Posted: Mon Aug 27, 2007 4:24 am
by avmohankumar
Dear Friends,

I have three dates in the database called, date1, date2, date3.
I have to write a query. the query has to search the date by WHERE condition in database.
If the date is find, I have to add some amount value on that day.

How can I create by using php and mysql.

Please Help me,

Thanks in advance.

Regards,
maza.

Posted: Mon Aug 27, 2007 7:03 am
by xpgeek
You need to use sql update statement.

Code: Select all

mysql_query("update table1 set value = 13 where date1 between '2007-09-15' and '2007-09-28' ");
For more information please use Job Hunt thread.