Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Nested Array

Nested Array

Thread began 2/04/2011 10:47 am by swolock397582 | Last modified 2/04/2011 3:51 pm by swolock397582 | 726 views | 1 replies

2/04/2011 3:51 pmJason ByrnesWebAssist

create a recordset for each category to return the records for that category: for example:
rsCatA:
SELECT widgetID FROM widgets WHERE category = 'categoryA'

then use a recordset repeat to add each id to an array;

php:

<?php 

$categoryA = array();

do {

  $categoryA[] = $row_rsCatA['widgetID'];

} while ($row_rsCatA = mysql_fetch_assoc($rsCatA));

?>

you can display the ID's as a comma separated list using this code:

php:

<?php echo(implode(", ",$categoryA)); ?>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.