time

2002-04-25 Thread bob nt
hello, 1) i have a value in a field in the db like 2002-01-02 07:04:19(a date time field) i cannot declare it as a time datatype as i need date also be available in the field. now is the myswl query to get just the time part from the db? 2) Also if i sum up a field which is of time type from a d

average function in mysql

2002-04-24 Thread bob nt
hi, can any one tell me if there is any function to get the average of some values in the mysql database. tnx plz mail to [EMAIL PROTECTED] bobbie __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ --

error : Fatal error: Call to a member function on a non-object

2002-04-15 Thread bob nt
i get an error like Fatal error: Call to a member function on a non-object in the line $result=$dbconn->Execute("update infotab set infomessage='$file_name' WHERE info_id='$ypid'"); here $ file_name returns a file name like mirror.txt or x.gif. & it is doing so. what's the probs can u