[Resolved] Displaying only certain data

[simwiz]

hi, For testing purposes I wanted to see if i could insert data from a form to a mysql database.

The problem is when using a loop I get all the data for that table as a output. But instead I only want the last submitted data to be shown as a output not the whole databases table.

$selected = mysql_select_db("form_login",$dbh) or die("Could not select form_login");
$result = mysql_query("SELECT * FROM users");

while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
print " Name: ".$row{'username'}." Password: ".$row{'password'}." News: ".$row{'news'}."<br>";
}

It would be greatful if you could help, thank you.

[bastien]

select * from users [where clause][order by clause] DESC LIMIT 1

will take all data based on optional where and order by clauses sorting from highest to lowest (most recent first) taking only the 1 row

hth

[simwiz]

THanks for the help, I had a feeling that the data could be processed via a query !

I was looking through the manual but couldnt find any information on query functions ! Do you know where i could find relavent information on querys !

cheers

[bastien]

google on sql or try www.mysql.com/documentation

[simwiz]

cheers again !