[PHP-Simple] Comma Seperated Implode of SQL Data
Posted: Fri Jul 23, 2010 1:14 pm
Ive done it before but cannot remember how to do it..
code im using so far only returns the last record
Trying to get all the productids, seperate by commas
code im using so far only returns the last record
Code: Select all
$query = "SELECT productid FROM templates_products_associated WHERE templateid={$req_vars['id']}";
$sql = pg_query($db,$query);
$pub = pg_fetch_assoc($sql);
$pubs = implode(',',$pub);
print_r($pubs);