# Help on mysql

**URL:** <https://forum.kirupa.com/t/help-on-mysql/211050>\
**Category:** Uncategorized\
**Created:** [December 26, 2006, 2:03pm UTC](https://forum.kirupa.com/t/help-on-mysql/211050 "2006-12-26T14:03:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![redune](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@redune](https://forum.kirupa.com/u/redune)\
**Post date:** [December 26, 2006, 2:03pm UTC](https://forum.kirupa.com/t/help-on-mysql/211050/1 "2006-12-26T14:03:59Z")

</div>

mysql\_select\_db(“jieneng\_database”, $connection) or die(“Error selecting database”);  
$result = mysql\_query(“SELECT \* FROM wnav ORDER BY nid”, $connection) or die(“Error querying database”);  
while($result\_ar = mysql\_fetch\_assoc($result)){  
if ($result\_ar[‘type’]==cat) {  
echo "\<p\>- "  
. $result\_ar[‘name’]  
. "\<br\>  
";  
$result2 = mysql\_query(“SELECT \* FROM wnav WHERE cup = $result\_ar[‘nid’]”, $connection) or die(“Error querying database”);  
while($result2\_ar = mysql\_fetch\_assoc($result2)){  
echo "&nbsp;&nbsp;- "  
. $result\_ar[‘name’]  
. "\<br\>  
";  
}  
}  
}

i got this error:

Parse error: syntax error, unexpected T\_ENCAPSED\_AND\_WHITESPACE, expecting T\_STRING or T\_VARIABLE or T\_NUM\_STRING in /home/jieneng/domains/jieneng.com/public\_html/index.php on line 56

thanks in advance
