This is what I had:
<?php
$dbconnect = mysql_connect("localhost", ":norris:", ":norris:");
mysql_select_db(":norris:", $dbconnect);
$articles = mysql_query("SELECT * FROM Articles");
while ($row = mysql_fetch_array($articles))
{
print('<a class="pagetitle" href="' . $row['url'] . '">' . $row['title'] . ' </a>');
print("\n<br />\n");
print('<div class="creator">' . $row['creator'] . '</div>');
print("\n<br />\n");
print('<div class="description">' . $row['description'] . '</div>');
print("<hr>\n");
}
mysql_close($dbconnect);
?>This is what I tried:
<?php
$dbconnect = mysql_connect("localhost", ":norris:", ":norris:");
mysql_select_db(":norris:", $dbconnect);
$articles = mysql_query("SELECT * FROM Articles");
$temp = 0;
while ($row = mysql_fetch_array($articles))
{
$row['title'] = $title[$temp];
$row['description'] = $description[$temp];
$row['creator'] = $creator[$temp];
$row['url'] = $url[$temp];
$temp++;
}
$temp = 0;
while ($temp < count($title))
{
print('<a class="pagetitle" href="' . $url[$temp] . '">' . $title[$temp] . ' </a>');
print("\n<br />\n");
print('<div class="creator">' . $creator[$temp] . '</div>');
print("\n<br />\n");
print('<div class="description">' . $description[$temp] . '</div>');
print("<hr>\n");
}
mysql_close($dbconnect);
?>
I want to make the query:
1
2
3
4
5
6
Become:
6
5
4
3
2
1
I can't store it into an array for some reason...
Any ideas why?