CHEERS
MySQL multiple <option value>
Moderator: General Moderators
-
Todlerone
- Forum Commoner
- Posts: 96
- Joined: Sun Oct 28, 2007 10:20 pm
- Location: Hamilton, Ontario, Canada
MySQL multiple <option value>
Hello everyone and again thank-you in advance for any suggestions to this post. I have recently successfully populated a form with a <option value> populated from MySQL database. All the dates from my database appear in the dropdown menu perfectly. My problem is that I need a second identical <option value> list with the same MySQL database "Date" information. I have tried the RESET(string) function but it doesn't seem to help. If the code is needed to help I can repost with it attached.
CHEERS
CHEERS
Re: MySQL multiple <option value>
Use to "rewind" the result.
EDIT: Sorry - forgot to pass the resource.
Code: Select all
mysql_data_seek($sql_result, 0)EDIT: Sorry - forgot to pass the resource.
Last edited by VladSun on Thu Jan 24, 2008 8:03 am, edited 1 time in total.
There are 10 types of people in this world, those who understand binary and those who don't
-
Todlerone
- Forum Commoner
- Posts: 96
- Joined: Sun Oct 28, 2007 10:20 pm
- Location: Hamilton, Ontario, Canada
Re: MySQL multiple <option value>
Thank-you for your quick response VladSun. I'll give it a try.VladSun wrote:Useto "rewind" the result.Code: Select all
mysql_data_seek(0)
TTFN
Re: MySQL multiple <option value>
Why not just build both lists at the same time, in the same loop?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Re: MySQL multiple <option value>
It could not be done if it's in different FORMs e.g.pickle wrote:Why not just build both lists at the same time, in the same loop?
Another way to do this is to have a string containing the generated HTML in one loop .
Edit: In fact, I don't know what do you mean
There are 10 types of people in this world, those who understand binary and those who don't