hi all. i am making a small database of links. each link is categorised depending on the category it is entered into.
i am having trouble displaying the links correctly. for some reason I cannot seem to get the links listed in the correct category, nor will they align alphabetically. here is the display code I am using, can anyone spot the problems? <?php $sql = "SELECT * FROM info ORDER BY catagory"; $result = mysql_query($sql) or die('There are currently no links in the database.'); $temp = ""; while ($row = mysql_fetch_assoc($result)) { $catagory = $row['catagory']; $url = $row['url']; $title = $row['title']; if ($catagory != $temp) echo "</ul>\n</div>\n\n<div class='left'>\n<h1>$catagory</h1>\n<ul>\n"; $temp = $catagory; echo "<li><a href='$url' target='_blank'>$title</a></li>\n"; } echo "</ul>\n"; echo "</div>\n\n"; ?> Community email addresses: Post message: php-list@yahoogroups.com Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/