Display last record first.

Posted on 16th Feb 2014 07:03 pm by admin

I need some help how put the last record first and first record last.

Thanks

Code: <?php
include("connect.php");

$query="SELECT * FROM MyNotes ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$username = mysql_result($result,$i,"username");
$notes = mysql_result($result,$i,"notes");
$id = mysql_result($result,$i,"id");

echo "<b>notes:</b> $notes
";
echo "<hr><BR>";

++$i; } } else { echo "The database is empty"; }?>

Your Answer:

Login to answer

Other forums

Executing an exe
Hi. I have some bizarre problem with exec (other any other method) to launch exe's. I am making a ga

Sum of Values in an Array
This is probably really simple... but it's been years since I've written anything, so bare with me!<

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

Reading waves
Hi,

I am trying to find a way of finding the highs and lows on a graph line, the line points

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

Need help: how to catch acess of undefined class properties
Hello. I am learning OO with PHP and have hit a problem.
Some code runs as perfectly valid code,

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

Limiting uploaded file type
I am working on a simple upload script, and I need it to limit the allowed file type that is uploade

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

problems with contact forms that are only protected against SQL injections
What could be a potential problem with contact forms that are only protected against SQL injections