a Simple database question...

[TitanKing]

I am so confused... if anyone could help me out i would really appreciate...

This is my database query (A), I need all the post id's thats joined to my threadsid meaning for example threadid nr 1 has say 4 post ids of values 4, 9, 8, 3 I get it out using this simple script;

$posts = $DB_site->query("SELECT postid FROM vb3_post WHERE threadid = $attach");
while ($row = mysql_fetch_array($posts))

{ 

$postid = $row['postid'];

}

Now I need to use all the postid's I gathered and do exacly the above query to get all my attachmentid's this would be for example postid 4 has 7 attachmentid's of values 1,2,3,4,5,6,7,8,9

(😎

$attachments = $DB_site->query("SELECT attachmentid FROM vb3_attachment WHERE postid = 172");
while ($row = mysql_fetch_array($attachments))

{ 

$attachmentid = $row['attachmentid'];

now how can I make this all a automated process to list all my attacmentid's from all my postid's considering I first have to get the postid's through the threadid's.

---

I hope I wasnt to confusing, its just something I dont understand and help would be so much appreciated...

[xblue]

First suggestion: make $postid and $attachmentid become arrays. Otherwise you keep overwriting them in the while loops. Like
$postid[] = $row['postid'];

Then, look into implode() to turn the $postid array into comma separated numbers that you be used in the 2nd query, like
WHERE postid IN (

• )
  this would be definitely more efficient than executing single queries in a loop.

  It may actually be possible to do it in one query, but I don't have the time right now to dive deeper into this, sorry.

[paulnaj]

Apart from typo's, I think this is the sort of thing you're after ...

<?php 
$all = $DB_site->query("
SELECT vb3_post.postid, vb3_attachment.attachmentid
FROM vb3_post 
LEFT JOIN vb3_attachment USING ( postid )
WHERE vb3_post.threadid = ".$attach."
");

$postid = '';
while($row = mysql_fetch_array($all)){ 
	if($row['postid'] != $postid){ // Find where postid changes, if necessary
		$postid = $row['postid'];
		echo '<hr>Post ID: <strong>'.$postid.'</strong>';
	}
	$attachmentid = $row['attachmentid'];
	echo '<br>Attachment ID: '.$attachmentid;
}
?>

Paul 🙂

[TitanKing]

Thank you very very much for your help guys it is so very much appreciate !!!! I will let you know if I come right...

[TitanKing]

Thank you people it works perfect !