List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 25 2000 1:15am
Subject:Re: Zip codes...
View as plain text  
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
Thread
Zip codes...Roy Nasser25 Feb
  • Re: Zip codes...Dan Nelson25 Feb
    • RE: Zip codes...Roy Nasser25 Feb
      • Re: Zip codes...Dan Nelson25 Feb
        • RE: Zip codes...Roy Nasser25 Feb
          • Re: Zip codes...Dan Nelson25 Feb
            • RE: Zip codes...Roy Nasser25 Feb
              • Re: Zip codes...Benjamin Pflugmann25 Feb
    • Re: Zip codes...James Treworgy25 Feb
  • Re: Zip codes...Graeme B. Davis25 Feb
    • Re: Zip codes...James Treworgy25 Feb
      • Re: Zip codes...Robert Crawford25 Feb