dns-daniel
10/11/2016 - 11:16 AM

phpMyAdmin Format for Multi-Variable Query - continue to add next consecutive number (note: variable field does not display in phpMyAdmin un

phpMyAdmin Format for Multi-Variable Query - continue to add next consecutive number (note: variable field does not display in phpMyAdmin unless exist in code and var must be in uppercase)

multiVar.sql
content_copyfile_download
SELECT
  car_id,
  make,
  price,
  mileage,
  description
FROM
  cars
INNER JOIN
  makes USING(make_id)
/* WHERE make = '[VARIABLE]' AND price <= [VARIABLE2] */
ORDER BY
  price