tuukie

Want to make a pulldown for hours and I want it to be on the hour now (it is now 22:40 so the pulldown should be on 22). Here is the code: [CODE=php] <?php $hour_now= date(G); $minute_now=date(i); ?> <form action="index.php" method="post" id="schedule_form"> <p> <label>Hour</label> <select name="send_hour"> <?php for($i = 0; …

I have a query which works in MYSQL 5, but doesn't work in MYSQL 4.. anybody ?? [CODE] SELECT DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%v') as date, DATE_FORMAT(DATE_ADD(DATE_ADD(CURDATE(), INTERVAL 0 - '52' WEEK), INTERVAL 2 - DAYOFWEEK(CURDATE()) DAY), '%Y%v') as date_ordered [/CODE]

Hello I got a nice one. I have 2 MS SQL 2000 databases on the same server both are almost alike. Both have an items table with the field searchcode I want to copy the searchcode from db1 table1 to db2 table1. So something like this: [CODE] use [db1] select …