Select option base from the database
whats the right codes using the select option that the choices came from the database. In my database i have a table name loan which has a acctNo.
The problem is i want to make the select options that the choices came from the database.
and i made this but i know this is not right.
View All Loan in <select name = "AcctNos"><option><?php Select * acctNo from loans ?></option></select>
Any Suggestion please.. I need it As soon as possible. Thanks
Specifics depend on what database extension your are using.
General idea is to either execute the query, the within a while() loop read each result row via the applicable "fetch" function for the DB extension in question and output the results within <option> tags; or with some DB extensions it's easy to fetch all the results into one PHP array, then do a foreach() loop on that array.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)