How I can create a two cloumns combo list and pull information from MYSQL database table?
Thanks,
Jimmy
How I can create a two cloumns combo list and pull information from MYSQL database table?
Thanks,
Jimmy
There is no easy way to create two columns combo in html. You can implement this using CSS/Javascript, but this will not be regular element. Try to look at demos section on jQuery, Mootools and other javascript frameworks.
As for populating MySQL query results into two columns, here is the code:
[php]
<?php $n = 2; // number of columns to display // query mysql database $r = mysql_query("select FieldName1, ID from SAMPLETABLE order by FieldName1"); echo ''.htmlspecialchars($f["FieldName1"]).' | '; if($i%$n==$n-1) echo ''; } echo ''; } echo ' |
[/php]