Posted By

deadmoon on 08/30/06

Tagged

mysql
data

Versions (?)

Last Edited at 08/30/06 09:38am

Statistics

Viewed 433 times

Favorited by 0 user(s)

Related snippets

display data from myusql

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

$query = 'SELECT field1, field2 FROM thisTable ORDER BY dateline LIMIT 5';
        $result = mysql_query($query);
        $items = array();
        while ($row = mysql_fetch_assoc($result)) {
            $items[] = sprintf('<li><a href="%s">%s</a></li>', $row['field1'], $row['field2']);
        }
        //do something with $items array;