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

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones

Module pool selction screen parameters combination logic
Hi floks,
Am new to the module pool development ,Recently i have created one program based on

Re-Order by ID Number
I have a cms set up for inputting an image, thumb, title, pdf, and eps. When input the database ass

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

PHP doesn't send my mail
Hi all, I found this and used it to send mail. Simple contact form with some required fields. The va

Sending UDP Raw socket
I truly need help on this. I am trying to write a test program that simulate a network environment

update post issues
I am trying to create an update to a post function, while the update does occur, the page routing an