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

Taking an HTML form and a PHP program and making it into one working file.
Hello,

So I would like to display everything INSIDE a specific directory. In other words, I

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

how to configure ADS in ABAP instance
Hi All,

I am working on r/3 4.7 ABAP system.Can we configure ADS(adobe document services)

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

Intrastat Report Config in ECC 6.0 - goods Movement in EU countries
Colleagues, need ur help to understand the changes require in ECC 6 standard Report configuration se

Redirecting Admin
In my members table, I have a field called "perm" and it's set to zero for all members. Ho