Stupid Syntax Question

[Anon]

I am creating a dynamic table on a member page that lists only the items that the member has purchased with a link to that product page....

I keep trying different syntax (see comment below for area) but keep getting confused...I think what I am trying to do will work, but just need the proper syntax...

Please help...

Thanks,
Ryan

<tr><td colspan="2" valign="top">
<?$basic_query = "SELECT product_info.product_name, product_info.product_link FROM purchases,product_info WHERE purchases.username = '$username' and purchases.product_id = product_info.product_id ";
$basic_result = mysql_query($basic_query);

		while ($basic_row = mysql_fetch_array($basic_result)) 
			{ 

// NEED HELP WITH SYNTAX BELOW
echo <a href=$basic_row[product_link]>$basic_row[product_name]; </a>?></td></tr><?
}

[van__]

don't be ending your php during a loop...
<?
while ($basic_row = mysql_fetch_array($basic_result))
{
echo '<a href="'.$basic_row[product_link].'">'.$basic_row[product_name].'</a></td></tr>';
}
?>

[Anon]

Thanks...worked like a charm...sometimes syntax can be so frustrating....

I appreciate your help...