Install/compile problems

?xml version=1.0 ?html head title/title /head body div align=leftfont face=Arialspan style=font-size:10ptHi, /span/font/div div align=leftbr//div div align=leftfont face=Tahomaspan style=font-size:10ptSYSTEM: Compaq Alpha, Tru64 5.1, mysql4.0.15a. /span/font/div div align=leftbr/ /div div

date_add function

the values from one (or 2) fields. Ideally I just want the return the time +7 hours. What would also help out is if someone can explain if there is a general rule for using literal strings and column values? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library

SUMMARY how to retrieve data from two tables?

get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668

SUMMARY: how to update time field with current time?

Thanx to all those how answered: hcir walt William Mussatto David Yahoo The answer was now() or update tab_name set fd_name = (now()) where_expr; I had tried this but was missing a pair of brackets (honest..) MYSQL dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo

how to retrieve data from two table?

with but once I add AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? Thanx. Dp. sql,mysql,query. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668

how to update time field with current time?

Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432