display mysql entries on site?

[auriaks]

you must say:

$query = mysql_query("SELECT * FROM `table` ORDER BY 'date' DESC") or die(mysql_error());

I think you must say ORDER BY

[Nile]

Yes, order by is a must, but we dont know if he has a date column.

[liamallan]

no, just name and profile. will i need to add an id or date column?

[Nile]

Yes. In PHPmyadmin click on the table you're using and then press SQL and put this code in:

 ALTER TABLE `table-name` ADD `id` INT NOT NULL AUTO_INCREMENT ,
ADD PRIMARY KEY ( `id` )

Then for the query:

$query = mysql_query("SELECT * FROM `table` ORDER BY 'id' DESC") or die(mysql_error());

[liamallan]

thanks guys, working perfect now! top dollar!

[Nile]

Glad to help you! Your welcome!

It seems your topic is solved... Please set the status to resolved.. To do this:
Go to your first post ->
Edit your first post ->
Click "Go Advanced" ->
Then in the drop down next to the title, select "RESOLVED"