i have a two drop down list 1st one is make and 2nd one is model in one mysql table name= (car)
if i select 1st drop down list - make = honda means,
it will show 2nd drop down list - all model = city, crv. like that
i was working in php and mysql and here i attached mysql data table screenshot, please help me anyone..
This query will get you a list of unique values from the make column. I suggest adding an index to that column on your table so that this query runs optimally.
SELECT DISTINCT make FROM car ORDER BY make
Given a specific make value, this query will get you a list of the model values associated with that make value. Again, index the make column so this runs optimally.
SELECT model FROM car WHERE make = ? ORDER BY model
In your PHP code, you'll need to use a prepared statement to specify the make value selected by the user as the value of the ? marker in the above query.
If you specify which extension you're using to access your database (e.g. PDO, mysqli, etc.) I can provide more information on where to look in the PHP documentation regarding prepared statements.
<select> elements using JS. Beyond that, you should be able to use the various documentation links we've provided to construct the code you're wanting. To be blunt, I don't think this is a situation where we can easily write code for you that will work with your codebase and environment. You're going to have to learn how to do that yourself.