Selecting rows from database with different ids

liam_d · Jan 6, 2008

Hi all i am trying to select topics from many forums (in phpbb3) and this is the code:

PHP:

	if (preg_match ("/^([0-9.,-]+)$/", $forum)) 
	{
		$sql = $db->sql_build_query('SELECT',
		array(
		'SELECT'   => 'p.*, u.*',
		'FROM'      => array(
			POSTS_TABLE   => 'p',
			USERS_TABLE   => 'u',
		),
		'WHERE'      => "p.topic_id = '{$topics[$i]['topic_id']}'
			AND p.forum_id = '{$forum}'
			AND p.poster_id = u.user_id",
		'ORDER_BY'   => "post_id ASC"
		));
	}

And you see the "($forum)" well it currently only works if i use one number, but what if i want to select from more than one forum, how do i use more numbers in there?

Albino · Jan 6, 2008

are you not able to place that in a for loop, like:

for(i=0;i>=4;i++){

$forum = i;
//code here;

}

like so

liam_d · Jan 6, 2008

I really don't understand that

Eric · Jan 6, 2008

PHP:

 if (preg_match ("/^([0-9.,-]+)$/", $forum)) 
    {
        $sql = $db->sql_build_query('SELECT',
        array(
        'SELECT'   => 'p.*, u.*',
        'FROM'      => array(
            POSTS_TABLE   => 'p',
            USERS_TABLE   => 'u',
        ),
        'WHERE'      => "p.topic_id = '{$topics[$i]['topic_id']}'
            AND p.forum_id IN('{$forumids}')
            AND p.poster_id = u.user_id",
        'ORDER_BY'   => "post_id ASC"
        ));
    }

Where $forumids would be a comma separated list of forum id's

liam_d · Jan 6, 2008

Thanks a lot someone on devshed said the same, but note you can't put '' around the (1,3,5) or it gives an error.

So it would read:

PHP:

if (preg_match ("/^([0-9.,-]+)$/", $forum)) 
    {
        $sql = $db->sql_build_query('SELECT',
        array(
        'SELECT'   => 'p.*, u.*',
        'FROM'      => array(
            POSTS_TABLE   => 'p',
            USERS_TABLE   => 'u',
        ),
        'WHERE'      => "p.topic_id = '{$topics[$i]['topic_id']}'
            AND p.forum_id IN ({$forum})
            AND p.poster_id = u.user_id",
        'ORDER_BY'   => "post_id ASC"
        ));
    }

Thanks buddy

Ps. it needed to stay as "$forum" as well, as it is used throughout my script

Selecting rows from database with different ids

The original NP Emo KidEstablished Member

Munky DesignsEstablished Member

The original NP Emo KidEstablished Member

VIP Member

The original NP Emo KidEstablished Member

Daisy.co

Kave.com

Stork.me

betindia.com

Reveal.com

thecraftroom.com

Fortnite.live

SandWax.com

0.VG

Stime.io

Similar threads

We're social

Daisy.co

Kave.com

Stork.me

betindia.com

Reveal.com

thecraftroom.com

Fortnite.live

SandWax.com

0.VG

Stime.io

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy