[RESOLVED] Query Help

thekidscareya

I have a query

$next_sql = "SELECT id FROM `tbl_images` WHERE `album_id` = '".$row['album_id']."'"

it will return 4 rows, but how do i get get all the tbl_images.id from the db in an array $next_row?

toplay

Don't use a "WHERE" clause at all and that will select all the rows in the table. You have to loop through the results table to retrieve all the rows. As you do that, you can always assign it to $next_row. Given the example code at:
http://www.phpbuilder.com/board/showpost.php?p=10648003&postcount=4

In the while loop, you would do:

$next_row[] = $row['id']; // Assigns just the id

hth.

thekidscareya

So something like this:

$other_sql = "SELECT * FROM `tbl_images`"
$other_query = mysql_query($other_sql) or die(mysql_error());

while($other_row = mysql_fetch_array($other_query))
	{
	if($other_row['album_id'] == $row['album_id'])
		{
                $next_row[] = $row['id'];
		}
	}

foreach($next_row AS image_id)
	{


}

One more question, the $next_row array can be used after the while loop right?

toplay

I don't understand what your trying to do with this line:

if($other_row['album_id'] == $row['album_id'])

Where is $row defined?

If you want only certain rows, then use the "WHERE" clause just like in your original post. Maybe I misunderstood what you want.

If you want to retrieve just the four rows, then do:

// I don't know where $row is set!
$other_sql = "SELECT id FROM `tbl_images` WHERE `album_id` = '".$row['album_id']."'";
$other_query = mysql_query($other_sql) or die(mysql_error());

while($other_row = mysql_fetch_array($other_query))
{
         $next_row[] = $other_row['id'];

}

If you want to retrieve all row ID's, then do:

$other_sql = "SELECT * FROM `tbl_images`"
$other_query = mysql_query($other_sql) or die(mysql_error());

while($other_row = mysql_fetch_array($other_query))
{

  $next_row[] = $other_row['id'];

}

thekidscareya

I have another query above...where the $row array is set...the $row['album_id'] has a number which is a foreign key for the tbl_images table.

toplay

OK. Well, I hope you're straight on this now.

You can join tables together to have just one SQL query. Look in my signature line in the MySQL area for links to tutorials on joins.

I have to run and do some house painting, yuk!

Bye.

thekidscareya

Thanks...problem solved