Display help please

leeg_23

Okay hopefully this will make sense to everyone. What I'm trying to do is grab my id out of my database and display it in the browser as a link. For some reason I can't get it to display my auto_increment id number. Here is the code as it is now. Thank you very much for all your help in advance.

$query = ("SELECT defectid, brief, timestamp FROM defect
ORDER BY timestamp DESC
LIMIT 0, 10");
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_object($result))
{
?>
<li><a href="defect.php?defectid=<? echo $row->defectid; ?>">
<?echo $row->brief;?></a>

The <a href> with my defectid is where I am trying to pull up a link with the id number display.

Thanks again

Anon

TRY THIS!!
$query = ("SELECT defectid, brief, timestamp FROM defect
ORDER BY timestamp DESC
LIMIT 0, 10");
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

if ($row=mysql_fetch_array($result)) {
do {
echo "<a href=\"defect.php?defectid=$row["defectid"]\">$row["brief"]</a>";
} while ($row=mysql_fetch_array($result));
} else {
echo "Sorry, No id's were found!";
}