how can I show data in php from a View in mysql?

[brillantita]

I have a View in mysql and need to show it in php. the View it receives a parameter of a combobox and with this one the consult is created to show the View.

i need help to fill the combobox with the information of my table and to show the View with the information from the mysql.

[Rabbit]

What do you have so far?

[brillantita]

I have a combobox that lists the course and his respective tests now I need that according to the course that was chosen to happen this go and to create the sight. The sight first I have to eliminate it if it is that it exists and later to create the View. (how this works?? .. syntax!) I need help to order the information of the combobox selected to the sql query that creates the view. this is in another another page .php ...

SORRY but I use a translator is very hard to write very well in English ... thank you !

[lyodmichael]

hmm, good day mr, but what language do you preferred for our conversation? i think i can help you, you can use select for your syntax, example.

for the combobox,

select coursecode from table1

for the view, this is just a sample,

select * from table1 where coursecode = '"$combobox"'

this is just a explaination that i create but, i think you already have an idea .

#tip