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

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

check_changed_data - I can't get data from the called method event
I use check_changed_data to trigger my event method.

The method delivers er_changed_data.

Using real time in php
I'm very average at PHP and im looking to introduce time to something on my site.
Its a sports si

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv

Sorting JTable on more than just the values listed in the columns
I have a collection of objects that store (among other things) two integer values. I only want to di

Disabling SAP menu
How do I disable SAP menu for all the users and just restrict them to User Menu in SAP ECC 6.0?

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa