Problem with Foreach

Sayian

Im having problems getting a foreach loop to work for me

What im trying to do is , get "Blasts" aka Comments about articles wrriten , that works , then im trying to get the photo associated with the person who left the "blast".

I have to query my database to get the filename of the photo ( the photo filenames are stored in mysql , and the files on the harddrive ) of each user leaving a blast.

The code is working , but only with 1 problem , it's only returning 1 photo. Instead of Each user's picture.

Please help me find the problem

// Get Users Blasts
$blast_sql = "SELECT `from`, `time`, `blast` FROM `shocc_blasts` WHERE `to` = '$profile_name' ORDER BY `time` DESC";
$blast_query = mysql_query($blast_sql) or die(mysql_error());
if(mysql_num_rows($blast_query)) {
	while($row = mysql_fetch_array($blast_query)) {
## Assign the Blasts to $blasts , and the user who left it to $user
		$blasts[] = $row;
		$user = $row['from'];

	// Get The Users Pic Who left The Blast
foreach($blasts as $blast_photo) {
$firstchar = strtoupper($user[0]);
## Set the Photo Directory on the server so we can get the main photo of the user who left the blast
$images_dir = "/images/".$firstchar."/".$user;
## Get main photo filename from SQL
$sql3 = "SELECT `photo_filename` FROM `shocc_account_photos` WHERE `username` = '$user' AND `main` = 1 LIMIT 1";
$query3 = mysql_query($sql3) or die('Selection of User Main Photo Has Failed because' . mysql_error() . "Contact Support@domain.com");
$result3 = @mysql_result($query3,0,photo_filename);
mysql_free_result($query3);
if($result3) {
## Assign $blast_photo as the Image of the user leaving the blast
$blast_photo = "<img src='".$images_dir."/".$result3."' border='1' width = '85' height = '85' />";
}
}

Kudose

This should work. I made several changes...

<?php
// Get Users Blasts
$blast_sql = "SELECT `from`, `time`, `blast` FROM `shocc_blasts` WHERE `to` = '$profile_name' ORDER BY `time` DESC";
$blast_query = mysql_query($blast_sql) or die(mysql_error());
if(mysql_num_rows($blast_query) <> 0) {
    while(($row = mysql_fetch_array($blast_query)) !== FALSE) {
## Assign the Blasts to $blasts , and the user who left it to $user
        $blasts[] = $row;
    }
}
foreach($blasts as $photo) {
  $user = $photo['from'];
  $firstchar = strtoupper($user[0]);
  ## Set the Photo Directory on the server so we can get the main photo of the user who left the blast
  $images_dir = "/images/".$firstchar."/".$user;
  ## Get main photo filename from SQL
  $sql3 = "SELECT `photo_filename` FROM `shocc_account_photos` WHERE `username` = '$user' AND `main` = 1 LIMIT 1";
  $query3 = mysql_query($sql3);
  $result3 = mysql_fetch_array($query3);
  mysql_free_result($query3);
  if($result3) {
    ## Assign $blast_photo as the Image of the user leaving the blast
    $file = $result3['photo_filename'];    

    $blast_photo = "<img src='".$images_dir."/".$file."' border='1' width = '85' height = '85' />";
    echo $blast_photo;
  }
}         

?>

Sayian

I dont know if this helps any ...

But $blasts[] is assigned to smarty , and then looped over in the template with a foreach in smarty , so i can display all the blasts that people have written.

Im trying to display the picture of the person who wrote the blast , so could i get the user's photo filename and then somehow inject that into the $blast[] array , so that each user's blast would also contain the photo_filename of his pic?

Currently the blast array is setup with ..
to
from
time
blast

... to , being the person who the blast is to , from being the person who it's from
Now couldnt i get the photo_filename of the person who the blast is from and put it in that array somehow? So their photo can be displayed next to their comment?

Sayian

Thanks for your help , but i got a warning ,

Parse error: parse error, unexpected '}'

Kudose

//$blasts is already an array
$photo = array("file");
$photo['file'] = $result['photo_filename'];
array_merge($blasts, $photo);

Kudose

What line is the error on?

Sayian

Im real confused on how to explain this , so im going to try my best ....

I have profiles on my website where people can join , write articles , and then other user's can leave comments (blasts) on their articles.

If my profile was "Shocc" my URL would be /profile.php?u=shocc

If you came to my profile , and left me a blast .. Im trying to get:
1. What you said
2. When you said it
3. Your photo ( filename stored in mysql , image stored on harddrive)

Ive got the first 2 Done. I use smarty as my template engine , So i get all blasts for the user's profile , in our example "Shocc" , and display them.

But im trying to display the picture of the person who left the blast. So i must query the database For each blast that was left , and get the photo_filename for that user who left it.

Since i use smarty , i get the blasts from mysql then assign them into an array
while($row = mysql_fetch_array) {
$blasts[] = $row
}

That allows me to goto my template and use Smarty's foreach

{foreach item=entry from=$blasts}

Then the data is avaliable for me to use in my template.
If i want to display a blast i simple use {$entry.blast} and for the person who it was from i use {$entry.from}

So , since im trying to get an outside source( the users photo who left the blast ) and it's not really a part of the blast itself ( remember , when a user leaves a blast , the only things that are stored is to , from , time , and the blast)

Im really stuck on how i can do this ..... It seems so simple , displaying the picture of the person who left the blast ...

Any ideas on how i could do this , if i havent lost everyone by now

Sayian

$photo = array("file");
$photo['file'] = $result['photo_filename'];
array_merge($blasts, $photo);

With this .. could i use {$entry.photo} Like i described above?

I think that is the key here .... can i put the photo into the array with the blast's ?

Sayian

Im very confused here , sorry if im not following ...

// Get Users Blasts
$blast_sql = "SELECT `from`, `time`, `blast` FROM `shocc_blasts` WHERE `to` = '$profile_name' ORDER BY `time` DESC";
$blast_query = mysql_query($blast_sql) or die(mysql_error());
if(mysql_num_rows($blast_query)) {
	while($row = mysql_fetch_array($blast_query)) {
		$blasts[] = $row;
		$user = $row['from'];
		// Get The Users Pic Who left The Blast
foreach($blasts as $photo) {
$firstchar = strtoupper($user[0]);
$images_dir = "/images/".$firstchar."/".$user;
$sql3 = "SELECT `photo_filename` FROM `shocc_account_photos` WHERE `username` = '$user' AND `main` = 1 LIMIT 1";
$query3 = mysql_query($sql3) or die('Selection of User Main Photo Has Failed because' . mysql_error() . "Contact Support@.com");
$result3 = @mysql_result($query3,0,photo_filename);
mysql_free_result($query3);
if($result3) {
$blast_photo = "<img src='".$images_dir."/".$result3."' border='1' width = '85' height = '85' />";
}
}
$photo = array("file");
$photo['file'] = $result['photo_filename'];
array_merge($blasts, $photo); 
	/////////////////////////	
	}
	mysql_free_result($blast_query);

} else {
	$blasts2 = "No blasts found for this Member ...";
}

Would that put the photo into the $blast array ... so i could call it from my template like {$entry.photo} , like i call the blast {$entry.blast} ?

Kudose

Why does it have to be a part of the blast array? Why cant you add in your proprietary code?

If you can add in your proprietary code, than the process is simple. You can pick pieces of the code apart from the previous entries and build something...

Kudose

No. You've totaly lost me...I am gonna leave this to a more experience person...

Sayian

Its probably not as hard as im making it sound , i just dont know how to explain what im trying to do , im just trying to get the user's image to show with the blast's they leave.