Search found 2 matches
- Mon Jun 30, 2008 12:16 pm
- Forum: Databases
- Topic: [SOLVED]SQL is valid, PHP won't accept
- Replies: 2
- Views: 492
Re: SQL is valid, PHP won't accept
There is obviously something wrong. It is difficult to tell without exact line numbers and a little more code to look at. As always, the solution was anything but obvious but a fantastic learning experience. The error lies in the fact that SQL statements aren't evaluated the same in the mysql conso...
- Mon Jun 30, 2008 3:45 am
- Forum: Databases
- Topic: [SOLVED]SQL is valid, PHP won't accept
- Replies: 2
- Views: 492
[SOLVED]SQL is valid, PHP won't accept
Here's my SQL statement. select tblCalendars.calName, tblEvents.eventName, date(tblEvents.eventBegins), time(tblEvents.eventBegins), time(tblEvents.eventEnds), period_diff(tblEvents.eventEnds, tblEvents.eventBegins) from tblEvents, tblCalendars where tblCalendars.calId = tblEvents.calId and date(t...