Okay, sorry. I stand corrected. :) Either way, the query still failed for some reason. The recommendation to use MySQL_error() is still a good one...
---John Holmes... > -----Original Message----- > From: Chris Knipe [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 2:44 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [PHP] convertion from string to time & substracting > > ----- Original Message ----- > From: "John Holmes" <[EMAIL PROTECTED]> > To: "'juaid'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 07, 2002 8:29 PM > Subject: RE: [PHP] convertion from string to time & substracting > > > > That error means your query failed and the result set is not valid. You > > can't use LIKE on a TIME column. > > Since when????? > > mysql> describe blah; > +-----------+------------+------+-----+----------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+------------+------+-----+----------+----------------+ > | ID | tinyint(4) | | PRI | NULL | auto_increment | > | TimeStart | time | | MUL | 00:00:00 | | > +-----------+------------+------+-----+----------+----------------+ > 2 rows in set (0.00 sec) > > mysql> SELECT * FROM blah; > +----+-----------+ > | ID | TimeStart | > +----+-----------+ > | 1 | 10:00:00 | > | 2 | 01:00:00 | > | 3 | 11:00:00 | > | 4 | 12:00:00 | > | 5 | 12:12:00 | > | 6 | 11:12:00 | > +----+-----------+ > 6 rows in set (0.00 sec) > > mysql> SELECT * FROM blah WHERE TimeStart LIKE '12%'; > +----+-----------+ > | ID | TimeStart | > +----+-----------+ > | 4 | 12:00:00 | > | 5 | 12:12:00 | > +----+-----------+ > 2 rows in set (0.04 sec) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > You just need to have the correct syntax in the LIKE clause :-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
