PHP/SQL Question
PHP/SQL Question
- Started
- Last post
- 6 Responses
- ********
If anyone can solve: How do I prevent a default TIME value from displaying? i.e, the default in MySQL is 00:00:00.. I want to filter that...
If you could, it'd be grand...
- ********0
Well what do you want instead?
- ********0
Nothing. Or maybe just "All Day" would suit my needs i guess. But you can't insert text into a TIME col..... :(
- waska0
off course you can't add string to a datetime or time field.
why not let your PHP script check if the time's 00:00:00, and then print something like "all day".
not sure what's your question is about, though.
- ********0
how to do what you said is what i need to know... i'm new at this!
i've been playing around with str _ replace ?! No luck...
- cosmo0
can we see some code?