NEED HELP: While loop is skipping records, why?

[hellrising]

I may of been looking at this for to long, but I have got 10 records in a database, all with the same album id. BUT it will only display 5 of them.... Why!

 

$gal = mysql_query("SELECT * FROM albums WHERE profilename = '$DisplayProfile'");
	while($albums = mysql_fetch_assoc($gal)){
	//generate information for albums

	$albumid = $albums["ID"];  //ID
	$albumname = $albums["albumname"];  //name
	$albumshot = $profile["profilename"]; //profilename

	$galimage = mysql_query("SELECT * FROM content WHERE albumid = ".$albumid." AND AdminAuth = 'true'"); 

	//display generated information for albums

	echo "<h3>".$albumname."</h3>";
	while($albumphotos = mysql_fetch_assoc($galimage)){
		$albumimage = $albumphotos["contenturl"]; //content location
		echo "<img src='content/" . $albumshot . "/" . $albumimage . "/>";
		}

	}

 

Looking at the MySQL database it looks like it is skipping alternate records...I am baffled..... Please help

[TeddyKiller]

I'm confused as to why you have a second while?

<?php
$gal = mysql_query("SELECT * FROM albums WHERE profilename = '$DisplayProfile'");
while($albums = mysql_fetch_assoc($gal)){
//generate information for albums
$albumid = $albums["ID"];  //ID
$albumname = $albums["albumname"];  //name
$albumshot = $profile["profilename"]; //profilename
$galimage = mysql_query("SELECT * FROM content WHERE albumid = ".$albumid." AND AdminAuth = 'true'"); 
//display generated information for albums
echo "<h3>".$albumname."</h3>";
$albumphotos = mysql_fetch_assoc($galimage);
$albumimage = $albumphotos["contenturl"]; //content location
echo "<img src='content/" . $albumshot . "/" . $albumimage . "/>";
}
?>

 

Like I say, you don't need it.. so you might aswell stick with that.

[hellrising]

The first while...

while($albums = mysql_fetch_assoc($gal)){

lists and loops all albums, and the second while...

while($albumphotos = mysql_fetch_assoc($galimage)){

lists all the photos in the album.

 

But i tryed just listing all the photos and removed the albums, but it would still only display 5 out of 10 photos skipping alternate records.

[Pikachu2000]

I'd start by echoing the query, then pasting it in to phpMyAdmin, or the mysql> client to see exactly what it returns, then debug from there.

[hellrising]

it so strange because i have other query's on the page that are displaying all the records its just this query that is doing it... but ill try and post the result!

[hellrising]

it displays all 10 records...

SELECT *
FROM Content
WHERE albumid =7
AND AdminAuth = 'true'

this is correct so the problem is not in the query...

[TeddyKiller]

Does something like this work?

$galimage = mysql_query("SELECT * FROM content WHERE albumid = 7 AND AdminAuth = 'true'");
while($image = mysql_fetch_array($galimage)){
echo $image['imagecollumname'];
}

[hellrising]

Stunned....

while($albumphotos = mysql_fetch_assoc($galimage)){
		$albumimage = $albumphotos["contenturl"]; //content location
		echo $albumimage;
		}

 

worked, it displays all records but why not.

 

	

while($albumphotos = mysql_fetch_assoc($galimage)){
$albumimage = $albumphotos["contenturl"]; //content location
echo "<img src='content/" . $albumshot . "/" . $albumimage . "/>";

}

[hellrising]

i knew id been looking at it to long and totally missed a single '

 

while($albumphotos = mysql_fetch_assoc($galimage)){
$albumimage = $albumphotos["contenturl"]; //content location
echo "<img src='content/" . $albumshot . "/" . $albumimage . "/>";

}

 

<img src='content/" . $albumshot . "/" . $albumimage . "'/>

[TeddyKiller]

The question is.. why would a simple ' display every other image?

[hellrising]

i supose because its not closing the src... I have no idea...lol