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

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass

Help please - How to validate from 2 possible answers
Hi

I hope somebody can help me with what will probably be really simple, I'm pulling my hair

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

include function being weird?
I have a very simple system to grab an IP outputted by a PHP file.. (for a project I have) but it ou

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Default TimeZone 
The server I'm working with is hosted in America so all times inserted into the database are coming 
Add 5 to a variable when a button is clicked, and re-run a for loop 
So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to 
FAGL_FC_TRANSLATION FAS52 New GL ECC 6.0 
Hello,



The new program for Translating GL Balances (FAS 52) gives the option to use diffe
cURL error 
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because 
If a record matches an existing record do nothing  
So I don't know if I should put this here or in mysql, but what my script is for is for people to ad