QUERY: SELECT t.*, DATE_FORMAT(t.date_added, '%a, %b %D') AS date_str, DATE_FORMAT(t.date_added, '%l:%i%p') AS time_str FROM zips AS t WHERE zip = '90001' ORDER BY date_added DESC LIMIT 1
ERROR: Table 'farmtoschool_db.zips' doesn't exist
QUERY: (SELECT 'distro' AS type, z.zip AS zip, d.title AS title, d.id AS pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM distributors AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.zip_code) UNION (SELECT 'farmer' AS type, z.zip AS zip, d.title AS title, d.id as pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM farmers AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.zip_code) UNION (SELECT 'school' AS type, z.zip AS zip, d.title AS title, d.id as pid, SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM programs AS d, zips AS z WHERE SQRT( POW(69.1 * (z.lat - ), 2) + POW(53.0 * (z.lng - ), 2) ) < 0 AND z.zip = d.contact_zip)
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 2) + POW(53.0 * (z.lng - ), 2) ) AS dist FROM distributors AS d, zips AS' at line 1
Search page - California FarmToSchool - Bringing farms to schools
Join Now!   Already a member? Sign in
            
    Home > Search page

Do you have information to add to this site? Click here to sign up!

Search: 
Search for:  
  Schools
  Distributors
  Farmers
Distance:
Zip:
 

Search results:

Nothing found!