PHP problem
Posted: Sat Mar 04, 2006 8:41 pm
feyd | Please use
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
I have som problems....
I have a database on the server, but now i need to make a php code.
The tables name is "delay_spelningar" and i want to get the following information that are in the table.
artist, city, date, place and link. This is the code right now, what is wrong? It should be sorted by date. It
is supposed to be a "gig guide"Code: Select all
<?include_once('page_header.phtml');?>
<div id="text" style="padding: 25px;">
<?
$db = mysql_query("SELECT date * FROM delay_spelningar GROUP BY date DESC LIMIT 5, 1000");
?>
<b><font color="#B57676"><?=date("Y-m-d", strtotime($r['date']));?></b></font> <b><font color="#3A3A3A"><?=$r['date];?></font></b> - <?=$r['date'];?> <br>
</div>
<?include_once('page_footer.phtml');?> feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]