| Problem in foreach loop with unserialized content
unserialzed |
canabatz
msg:4515835 | 12:14 pm on Nov 5, 2012 (gmt 0) |
Hi,
i got problem in foreach loop, the code is stuck on first loop.
any one see any problem in the code?
im stuck on it for a day now.
thanks !
function get_rss()
{
global $catArray, $yesterday, $date;
$rss = mysql_query("SELECT id, cat, tcat, title, pic FROM portal_coverages WHERE v = 1 AND date BETWEEN ('" . $yesterday . "') AND ('" . $date . "')ORDER BY id DESC");
$resultp = array();
while($row = mysql_fetch_object($rss))
{
$resultp[$row -> cat][$row -> tcat] = $resultp[$row -> cat][$row -> tcat] . "
<tr>
<td><p style='color:#F91010;'>" . $catArray[$row -> cat . "," . $row -> tcat] . "</p></td>
<td><img src='http://dossinet.me/" . $row -> pic . "' width='50' height='50' /></td>
<td>" . $row -> title . "</td>
<td><a href='http://dossinet.me/view," . $row -> id . ".html'>קישור </a></td>
</tr>
";
}
return $resultp;
}
include("rss/mail_class.php");
$kk=1;
$query = mysql_query("SELECT rss_id, user_id FROM `portal_rss`")or die(mysql_error());
$get_rss = get_rss();
while($row = mysql_fetch_object($query))
{
$rss_id = unserialize($row -> rss_id);
$kk++;
foreach($rss_id as $key)
{
$x = explode(',', $key);
if(!empty($get_rss[$x[0]][$x[1]]))
{
$title .= $catArray[$key] . ', ';
$result .= $get_rss[$x[0]][$x[1]];
}
}
if(!empty($result))
{
$query = mysql_query("SELECT * FROM `user` WHERE `userid` ='" . $row -> user_id . "'")or die(mysql_error());
$rowz = mysql_fetch_array($query);
$user['name'] = $rowz['username'];
$user['email'] = $rowz['email'];
echo $user['email'];
$params = array(
'file' => 'rss',
'subject' => "עדכוני קטגוריה - " . $title,
'from_name' => "עדכוני קטגוריה ",
'vars' => array('cat' => $title, 'post' => $result, 'name' => $user['name']),
);
Mail::To($user['email']);
Mail::set_mail($params, true);
Mail::send_mail($params);
}
}
|
lostdreamer
msg:4515841 | 1:02 pm on Nov 5, 2012 (gmt 0) |
I dont know for sure (indenting here is not so nice) but I believe you are overwriting the "$query" variable inside the query, thus; when looping over the first $query object the second time, it's not the original one anymore.
try changing:
$query = mysql_query("SELECT * FROM `user` WHERE `userid` ='" . $row -> user_id . "'")or die(mysql_error());
$rowz = mysql_fetch_array($query);
to
$query2 = mysql_query("SELECT * FROM `user` WHERE `userid` ='" . $row -> user_id . "'")or die(mysql_error());
$rowz = mysql_fetch_array($query2);
To test my hypothesis ;)
|
canabatz
msg:4516047 | 9:02 pm on Nov 5, 2012 (gmt 0) |
Thanks, that was the problem!
|
|
|
