Search found 2 matches

by HelpyMcHelperson
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...
by HelpyMcHelperson
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...