On Tuesday 21 February 2006 14:27, Ray Cantwell wrote: > Hi all, > I am a noob and super confused right now. I have some really simple code > and i am getting an error that reads: > *Parse error*: syntax error, unexpected T_VARIABLE in > */var/www/mysql_up.php* on line > > here is the code: > > <html> > <head><title>Test MySQL</title></head> > <body> > <!-- mysql_up.php --> > <?php > $host="localhost" > $user="ray" > $password="*****" > > mysql_connect($host,$user,$password) ; > $sql="show status"; > $result = mysql_query($sql); > if ($result == 0) > echo "<b>Error " . mysql_errno() . ": " > . mysql_error() . "</b>"; > else > { > ?> > <!-- Table That Displays the results --> > <table border="1"> > <tr><td><b>Variable_name</b></td><td><b>Value</b> > </td></tr> > <?php > for ($i = 0; $i < mysql_num_rows($result); $i++) { > echo "<TR>"; > $row_array = mysql_fetch_row($result); > for ($j = 0; $j < mysql_num_fields(result); $j++) > {/ > echo "<TD>" . $row_array[$j] . "</td>"; > } > echo "</tr>"; > } > ?> > </table> > <?php } ?> > </body></html> > > I am really confused because i cannot see any obvious errors. > any help would be appreciated. > > Ray. It looks like you need some semi-colons after assigning values to variables at the top of your file. If that's not the problem, let us know what line number this is happening on. It makes it a lot easier to spot the problem ;) -- Ray Hauge Programmer/Systems Administrator American Student Loan Services http://www.americanstudentloan.com 1.800.575.1099 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php