while array SQL problem
Posted: Wed May 31, 2006 8:47 pm
Hi all ,i spent some time baking in front of my CRT and keep on getting this error:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/noob/public_html/admin/tabview.php on line 34
I read almost all concat guides and cant seem to find problem(i know its simpe for you all) HEre it is:
It must be a simple problem with concat or maybe something else i have done wrong( i think im trying to hard).
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/noob/public_html/admin/tabview.php on line 34
I read almost all concat guides and cant seem to find problem(i know its simpe for you all) HEre it is:
Code: Select all
echo '<table cellspacing=\"7\">';
echo '<th>Offer Name</th>';
echo'<th>User completing Offer</th>';
echo'<th>Complete?</th>';
while($array = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo '<tr>' .$array['offer_name']</tr>;//THIS IS LINE 34!!!!!!!!!!!!!!!!!!!!!
echo '<tr>' .$array['username']</tr>;
echo '<tr><a href=do.php?act=approve&entry='.$array['id']>Approve</a></tr>;//the link which allows us to approve the entry
}
echo '</table>';//closes the dynamic table
echo '<br>';
echo '<hr>'; //hrozontial rule
echo 'Here are the offers that are completed:';
$query = "SELECT * FROM coffers"
$result = mysql_query($query);
$hits = mysql_num_rows($result);