On 19-Sep-2001 Tom Churm wrote:
> hi,
> could someone please tell me why this doesn't work?  i thought that
> string functions could be used in select statements?  i dunno...
> SELECT User, SendDate FROM my_form 
> WHERE substr(SendDate, 0, 2)=19;
> and i've tried the damn thing with brackets around all different parts.

Try to figure out the damn difference between PHP substr() & SQL SUBSTRING().

> thanks much,

your welcome,
Don Read                                       [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to