In the last episode (Feb 24), Roy Nasser said:
> Actually i had corrected that but it didnt get rid of the following error:
>
> MySQL said: You have an error in your SQL syntax near 'ABS(zipcode - 01450),
> p.CinemaID, p.MovieID, p.time ASC' at line 1
>
> The query is:
> SELECT c.name as CinemaName, c.CinemaID, c.zip as zipcode, p.time, m.name as
> MovieName, m.MovieID, m.rating, m.duration FROM tbl_Movies as m, tbl_Playing
> as p, tbl_Cinemas as c WHERE c.CinemaID=p.CinemaID and p.MovieID=m.MovieID
> and p.time > '21:29:00' and p.start < '2000-02-24' and p.end > '2000-02-24'
> ORDER BY ABS(zipcode - 01426), p.CinemaID, p.MovieID, p.time ASC;
What version of mysql is this? A similar function certainly works for
me.
--
Dan Nelson
dnelson@stripped
