Why wont this one work? //Edit $result to be your query $querry = "SELECT * FROM flash DESC LIMIT 10"; $result = mysql_query($querry); OR die(mysql_error()); echo "$result"; ?> And while we are on the subject, in the table "flash" i have 3 rows called "name" "size" and "date", how have i display these at diffrent places on a page? let's say like this the name is "name" the size is "size" the date added is "date"
You need to remove "DESC". When you use DESC, you need to specify an ORDER BY field (you call it row) name. For example: $querry = "SELECT * FROM flash ORDER BY date DESC LIMIT 10"; Edit: as premiumscripts said, you also need to change the query statement into: $result = mysql_fetch_assoc(mysql_query($querry));
You need to look at http://php.net/mysql_fetch_assoc -- look at the examples there. It's clear to me that you should buy a book on the subject though.