Ray Hunter wrote:
in not following what you are trying to do and what database you are
running the query in.
if you could provide some ddl for the tables that would be great too and
what you are trying to accomplish.
No worries. I figured it out last night after the brain haze had died
down. Here's what I ended up doing, in case someone needs it. I got a
javascript here: http://www.yxscripts.com/cs/chainedselects.html
I used these queries:
$query_r1 = "SELECT distinct apn1 FROM datalilst ORDER BY apn1";
$query_r2 = "SELECT distinct apn2, apn1 FROM `datalilst` order by apn2";
... and this code to generate the the stuff that script looks for. I
know, there are probably a million more eloquent ways to do it, but what
can I say, coding isn't exactly my bag:
addListGroup("apns", "apn1");
<?php do { ?>
addList("apn1", "<?php echo $row_r1['apn1']; ?>", "<?php echo
$row_r1['apn1']; ?>
", "apn1-<?php echo $row_r1['apn1']; ?>
");
<?php
} while ($row_r1 = mysql_fetch_assoc($r1)); mysql_free_result($r1);
do { ?>
addOption("apn1-<?php echo $row_r2['apn1']; ?>" , "<?php echo
$row_r2['apn2']; ?>" , "<?php echo $row_r2['apn2']; ?>");
<?php
} while ($row_r2 = mysql_fetch_assoc($r2)); mysql_free_result($r2);
?>
Hoping it helps someone :)
-V
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
