I need Help in simple mysql query and PHP

[victoria-vicky]

Hi Boys,

I'm new here and new to mysql/php

I created a mysql table called faq with 2 field
id and info is the field name

and i want to call the last 4 entry on info field and list them from that table

and list the info field like

purple,pink,yellow,orange,grey

thank you for helping a girl out

[Kokos]

The last four entries of the list? Okay, use this code:

<?php
//First connect to the database! I'm not writing that :P
$query = "SELECT * FROM `faq` ORDER BY `id` DESC LIMIT 0,4";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
       echo $row['info']."<br>";
}
?>

That should work

[victoria-vicky]

thank you so much