Weird MYSQL Problem.

[NZB]

Hey.

Firstly ill state what im trying to get. I want to select all the rows in a table. In this table there is a field called ID which is always different, autoincremented, primary etc.. Now i want to take that field and after the select put it all into on value, heres the code im using now..

$GetIDS = $SESSION[DB]->query("SELECT * FROM table");
while($GetIDSInfo = $SESSION[DB]->fetch_array($GetIDS))
{
$str = "$GetIDSInfo[ID],";

    }

echo "$str";

Which i knew before would echo the last ID in the table, i want to get this effect:

$str = "1,2,3,4,5,6...etc";

Any ideas on how i could do it?

[paulnaj]

How about ...

<?php
$strs = array();

$GetIDS = $_SESSION['DB']->query("SELECT * FROM table"); 
while($GetIDSInfo = $_SESSION['DB']->fetch_array($GetIDS)){ 
    $strs[] = $GetIDSInfo['ID']; 
} 

echo join(',', $strs);
?>

Paul 🙂
PS. A tip ... always quote keys in arrays ($_SESSION['DB'])... some servers insist on it and won't work without.

[EWaveDev]

Or, how about:

$str = "";
GetIDS = $SESSION[DB]->query("SELECT * FROM table");
while($GetIDSInfo = $SESSION[DB]->fetch_array($GetIDS))
{
$str .= "$GetIDSInfo[ID],";
}

echo "$str";