In Progress

SIMPLE php/ mysql search query

I have a search form that needs to populate a mysql select query, the html form will be:

Cuisine (Multiple select)

Name (Matched LIKE %string%)

Zip (Matched LIKE %string%)

Delivery ( equals 1 or 0)

Area of town: (Multiple select)

These need to post to the php script and dynamically create the select query.

SELECT * FROM restaurants WHERE cuisine in () AND name LIKE '%%' AND zip LIKE '%%' AND delivery in() AND areaoftown in () ORDER BY name ASC

I realize this project is VERY small, its late and dont want to fool with it.


Beceriler: PHP

Daha fazlasını gör: string search in c, search string in c, search string c, search string, search c string, php string to html, n query, n equals, c string search, c search string, asc it, search search, simple query, PHP simple, Mysql, mysql query, cuisine, script multiple pending order, create restaurants, string search

İşveren Hakkında:
( 53 değerlendirme ) katy, United States

Proje NO: #126374