Re: Showing high and low flash clips

Suppose we have a recordset $rs returned by query like that: SELECT mediaID, filename, languageID FROM yabady a INNER JOIN yohoho b on a.ID = b.ID ORDER BY mediaID then to build the array you can write: for ($i = 0; $i <= $rs->getRowCount() - 1; $i++) { $row = $rs->getRow();

$data = array('mediaID'    => $row['mediaID'],
              'filename'   => $row['filename'],
              'languageID' => $row['languageID']);

} Haven't tested it, but have a similar code in one of my scripts here that works fine. Boyan -- daniel@electroteque.org wrote: > Hi there, i'm stumped on a problem, i am trying to create an admin tool, > which will database files which are ftp'd to the server first. A drop down > list of flash files are viewed, and they are seperated into high and low > clips with a language key joined to them. They are stored in the database > like: > > mediaID filename languageID bandwidth > > What i am having problems with is that when editing the record, i would > like to list each with both a high and low pulldown with a language list, > although there is an issue here as each clip has its own entry into the > database so its coming out sequentially and i would like it showing the 2 > drop downs and the language joined to these. The issue is storing the > primary key of these files, so when i hit update it will update each file > record. > > So when abstracting the data, i am trying to push both files into an array > with a language. I want it to look like > > Array > ( > [0] => Array > ( > [0] => Array > ( > [mediaID] => 3 > [filename] => news_hi.swf > [languageID] => 1 > ) > [1] => Array > ( > [mediaID] => 4 > [filename] => news_lo.swf > [languageID] => 1 > ) > ) > > [1] => Array > ( > [0] => Array > ( > [mediaID] => 3 > [filename] => news_hi.swf > [languageID] => 1 > ) > [1] => Array > ( > [mediaID] => 4 > [filename] => news_lo.swf > [languageID] => 1 > ) > ) > ) > > How is it possible ? >