dunno, hard to understand ur explaining... so, what i'll do is write a little loop that will generate an array for you. i think this should be enough to get you started at least :
Code: Select all
//....
$sql = "SELECT * FROM rants WHERE rantid='0' AND year='".$in_year."' AND month='".$in_month."'";
$result = mysql_query($sql) or die(MySQL_Error());
$blog = array();
$
$days = array();
// this loop assumes there is a field named Blog and a field named Day since i have no idea what your table's field structure looks like..
while($row=mysql_fetch_array($result))
{
$blog[] = $row['blog'];
$days[] = $row['days'];
}
myarray = array();
for($i=0; $i<count($blog); $i++)
{
$myarray[] = array($blog[$i] -> $days[$i]);
}
dunno.. i coudlnt' really tell what this :
$days = array(
2=>array('/blog/2','linked'),
3=>array('/blog/13','linked'),
8=>array('/blog/14','linked'),
22=>array('/blog/17','linked'),
is suposed to be... i mean, what is 2,3,8,22 ?? what is the linked for ? are they all field values in the table? is the blog and link field values?
more information por favor
