php problem

mrDuke

this code deosnt seem to print back out the data from my table, any suggestions wud be appreciated


GLOBAL $bookmark_table, $cell_color;

$query = "SELECT id, site_name, url, DATE_FORMAT(date_added,'%m-%d-%Y') AS
date_added, description
FROM $bookmark_table
ORDER BY date_added DESC";

$result = count($id);

print "<div align=\"center\"><table cellpadding=\"2\" cellspacing=\"1\"
border = \"0\" width = \"600\">";

for ($row = $result; $row >= 1; $row-=1) :

print "<tr><td>";
print "<b>".$row["site_name"]."</b> | Posted:
".$row["date_added"]."<br>";
print "</td></tr>";

print "<tr><td>";
print "<a href = \"http://".$row["url"]."\"&gt;
http://".$row["url"]."</a><br>";
print "</td></tr>";

print "<tr><td valign=\"top\">";
print $row["description"]."<br>";
print "</td></tr>";

print "<tr><td><hr></td></tr>";

endfor;

Adam

You're not actually executing the mysql query. Set $result=mysql_query($query); and then $row=mysql_fetch_array($result);

mrDuke

cheers that work a sweet!

Adam

No probs!