Code: Select all
SELECT
`m_type`,`m_title`,`m_url`,`m_description`
FROM
`t_media`
Code: Select all
SELECT
`title`,`url`,`content`
FROM
`t_pages`
Moderator: General Moderators
Code: Select all
SELECT
`m_type`,`m_title`,`m_url`,`m_description`
FROM
`t_media`
Code: Select all
SELECT
`title`,`url`,`content`
FROM
`t_pages`
Code: Select all
$rssquery="SELECT m_type,m_title,m_url,m_description, m_date FROM t_media WHERE m_submapproved='Y' ORDER BY m_id DESC LIMIT 10";
//echo $query;
$rssqresult = mysql_query($rssquery);
$array = array();
while ($rssline = mysql_fetch_object($rssqresult))
{
$array[] = $rssline;
}
$rssquery="SELECT title,url,content,date FROM t_pages ORDER BY id DESC LIMIT 10";
//echo $query;
$rssqresult = mysql_query($rssquery);
while ($rssline = mysql_fetch_object($rssqresult))
{
$array[] = $rssline;
}Code: Select all
$rssquery="SELECT m_type,m_title,m_url,m_description, m_date FROM t_media WHERE m_submapproved='Y' ORDER BY m_id DESC LIMIT 10";
//echo $query;
$rssqresult = mysql_query($rssquery);
$array1 = array();
$array2 = array();
$newarray = array();
while ($rssline = mysql_fetch_object($rssqresult))
{
$array1[] = $rssline;
}
$rssquery="SELECT title,url,content,date FROM t_pages ORDER BY id DESC LIMIT 10";
//echo $query;
$rssqresult = mysql_query($rssquery);
while ($rssline = mysql_fetch_object($rssqresult))
{
$array2[] = $rssline;
}
for($x =0; $x < 10; $x++)
{
if ($array1[$x]->m_date < $array2[$x]->date1)
for($i = 10; $i > $x; $i--)
{
$array1[$i+1] = $array1[$i];
}
$array1[$x] = $array2[$x];
}
for($x =0; $x < 10; $x++)
{
if ($array1[$x]->m_date <> "")
echo $array1[$x]->m_date ."<BR>";
else
echo $array1[$x]->date1 . "<BR>";
}