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

Here's another easy way. $data = array(); while ($row = ifx_fetch_row ($charge_result2, "NEXT"){ $data[] = $row['id']; } ifx_free_result ($res_id); $comma_sep = implode(', ', array_values($data)); Thomas Shaw php.coder@tx.rr.com -----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" ?