turn mysql_fetch_array into seperate array

AsianGuyJTran

i am stumped on what to do:

how do i turn this:

<?
//open database connection
require ("./phpBB/config.php");
mysql_connect ("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db ($dbname);

$query1 = mysql_query("SELECT * FROM `phpbb_forums` WHERE `forum_id` !=3 AND `forum_id` !=5 AND `forum_id` !=20 AND `cat_id`=4");

$fetch1 = mysql_fetch_array ($query1, MYSQL_BOTH);

echo ("$fetch1[0]");
while ($fetch1 = mysql_fetch_array ($query1, MYSQL_BOTH)){
echo (",$fetch1[0]");
}
?>

into an array so that i can execute another mysql query 😕

devinemke

not sure i understand your question. but in this example:

require('./phpBB/config.php');
mysql_connect($dbhost, $dbuser, $dbpasswd) or exit(mysql_error());
mysql_select_db($dbname) or exit(mysql_error());

$result = mysql_query('SELECT * FROM phpbb_forums WHERE forum_id NOT IN(3,5,20) AND cat_id = 4') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[] = $row;}

...$array is now a 2 dimensional array with each row as as array index. is that what you mean?

AsianGuyJTran

sorry about that. i am bad at explaining things

using my php code above, my result is 15,16,17,19,21,23.

i want to turn into an array so that that in my next query to mysql using

SELECT * FROM `phpbb_topics` WHERE `forum_id` = $result

i will get all the topics that are from forum_id 15,16,17,19,21,23 where the actual query would look like

SELECT * FROM `phpbb_topics` WHERE `forum_id` = 15 OR `forum_id` = 16 ...

does that make it any easier to understand?

devinemke

if you are using a version of mySQL that supports subqueries (4.1 or higher) then this all can be done in a single query:

$result = mysql_query('SELECT * FROM phpbb_topics WHERE forum_id IN(SELECT forum_id FROM phpbb_forums WHERE forum_id NOT IN(3,5,20) AND cat_id = 4)') or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {$print_r($row);}

if you are using an older version then do two separate queries:

$result = mysql_query('SELECT forum_id FROM phpbb_forums WHERE forum_id NOT IN(3,5,20) AND cat_id = 4') or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {$array[] = $row['forum_id'];}

$result = mysql_query('SELECT * FROM phpbb_topics WHERE forum_id IN(' . implode(',', $array) . ')') or exit(mysql_error()); 
while ($row = mysql_fetch_assoc($result)) {$print_r($row);}

AsianGuyJTran

thanks so much. it works 😃