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

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

Mail sending is slow on server
Why mail is taking time to be send on apache-linux server

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

How to extract/download content from HTTPS page?
Hello to all the Members of this forum, Im Shoiab, A novice programmer in php.. for my first job I h

PHP XML extraction text
I would like to extract an xml text and have that text directly echo(print) out on my web page. Her

Need help making a script that moves data into acrhive table
Hi,

I'm kinda new to php/mysql

And i wrote a simple script to store sales lead for a b

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we