[Resolved] MySQL Selections

amadonbass

I need to use the limit feature and still have the latest ID in my table at the bottom.. think chatroom, where the last post is first from the bottom up..

$sql = "SELECT * FROM chattable ORDER BY id ASC LIMIT 10";

Also, what's the most effective way to switch from ordering by ASC and DESC for listing things in alphabetical order?

mrhappiness

$sql = 'SELECT * FROM table ORDER BY id DESC LIMIT 10';
$result = mysql_query($sql);
$results = array();
while ($results[] = mysql_fetch_assoc($result)); //fetch the data
array_pop($results); //remove last entry cause it's waste
$results = array_reverse($results); //reverse the 10 entries

hth

amadonbass

I seem to be having troubles bringing the data to the screen in the loop..

$sql = "SELECT * FROM chattable ORDER BY id DESC LIMIT 10";
$result = mysql_query($sql);
echo "<div style=\"width: 300px; height: 200px; overflow: auto;\">";
echo "<table>";
$data = array();
while($data[] = mysql_fetch_assoc($result))
{
	echo "<tr><td align=\"left\">";
	echo "<span style=\"font-weight: bold; color: red;\">" . $data[1] . ":</span> ";
	echo $data[2];
	echo "</td></tr>";
}
array_pop($data); //remove last entry cause it's waste
$data = array_reverse($data); //reverse the 10 entries
echo "</table>";
echo "</div>";

doing that, it displays this:

:

Array:

Array: Array
Array: Array
Array: Array
Array: Array
Array: Array
Array: Array
Array: Array
Array: Array

mrhappiness

extend my code

$results = array_reverse($results); //reverse the 10 entries
echo '<table>';
foreach ($results as $entry)
  echo '<tr><td>'.implode('</td><td>', $entry).'</td></tr>';
echo '</table>';

this should work

you perhaps also want to do

echo '<pre>';
print_r($results);
echo '</pre>';

and see how the data is stored in the array $resukts

amadonbass

ahh, thanks.. this is prolly a good starting point for me to learn more about arrays 😃

[edit] your example also answered my second question, cheers!