RE: [PHP] Building an array, kind of?

> -----Original Message----- > From: Dan Shirah [mailto:mrsquash2@gmail.com] > Sent: Friday, October 24, 2008 9:52 AM > To: PHP LIST > Subject: [PHP] Building an array, kind of? > > TGIF? > > Apparently my brain isn't working this Friday. > > I'm trying to query my table to get the first 16 ID's. I then want > to assign the ID's to a variable and have them comma seperated. > > // My query to select the first 16 rows > $get_charges2 = "SELECT FIRST 16 * FROM history WHERE id = '$id"; > > // Executing the query > $charge_result2 = ifx_query ($get_charges2, $connect_id); > > How would I assign the result to a variable? > > For instance, say my query returns rows like: > > 1234 > 1235 > 1236 > 1237 > 1238 > 1239 > > How would I go about putting that in a variable to equal > "1234,1235,1236,1237,1238,1239" ? I think someone's already used foreach() in an answer, but I don't see the point in building an array and then immediately joining it to a string and discarding the array... $t = ''; foreach($resultset as $row) $t .= ',' . $row; Done and done. Todd Boyd Web Programmer