Defining A Variable

[tarheel2002]

Help, I can't figure this one out...

I want to create a comma delimited list of results from a MYSQL query and store it as $variable so that I can use it in a SELECT IN($variable) statement later on.

Thanks in advance!

[jatar_k]

well,

1. construct your query
2. use mysql_query to get your results from the db
3. use a loop to append each value to a variable

for int coltype
$var1 = "";
while($row = mysql_fetch_array($result)) {
$var1 .= $row['mycol'] . ',';
}

for varchar coltype
$var1 = "";
while($row = mysql_fetch_array($result)) {
$var1 .= "'" . $row['mycol'] . "',";
}

4. chop the trailing comma
$var1 = substr($var1,0,strlen($var1)-1);

5. use this var to create your new query

[tarheel2002]

Works like a charm... thanks!