i get the following error:
Parse error: parse error, unexpected ';' in
C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s
ervices.php on line 4
from the following code:
<?php
//Database Querys
$dbconn = mysql_connect($dbHost , $dbName , $dbPassword)
or die("Could not connect to server, incorrect username,
password or host : ".mysql_error();
$connection=Mysql_connect($dbHost , $dbName , $dbPassword)
//function zone
//creates table
function tablecreate($num,$connection){
$items=mysql_query('SELECT Row_Decription, Required_Items, Misc FROM
RuneRunner WHERE ID = $num',$connection);
$item=mysql_fetch_array($items);
$users1=mysql_query('SELECT RuneRunner.rune, RuneRunnerprices.price FROM
RuneRunner INNER JOIN RuneRunnerprices ON RuneRunner.User_Id =
RuneRunnerprices.User_Id WHERE RuneRunnerprices.ID = $num AND
RuneRunnerPrices.user_id = 1',$connection);
$user1=mysql_fetch_array($users1);
$users2=mysql_query('SELECT RuneRunner.rune, RuneRunnerprices.price FROM
RuneRunner INNER JOIN RuneRunnerprices ON RuneRunner.User_Id =
RuneRunnerprices.User_Id WHERE RuneRunnerprices.ID = $num AND
RuneRunnerPrices.user_id = 2',$connection);
$user2=mysql_fetch_array($users2);
print ('<tr><td>' . $item[1] . '</td><td><img
src=module/runescape/Runerunner/' . $user1[1] . '.gif>' . $user1[2].
'<br><img src=module/runescape/Runerunner/' . $user2[1] . '.gif>' .
$user2[2]. '</td><td>' . $item[2] . '</td></tr>');
};
//this function is called by another
function picscreate($Rune,$username,$num){
print('<img src=module/runescape/Runerunner/' . $Rune . '.gif>' . $username
. '<br>');
${'' . $num . ''}=$Rune;
};
//gets data form database and sends it to pics()
Function picspprep($usernum,$connection){
$pict=mysql_query('SELECT username,rune FROM RuneRunner WHERE User_ID =
$usernum',$connection);
$pic=mysql_fetch_array($pict);
picscreate($pic[1],$pic[2],$usernum);
};
?>
<i><u><b>Welcome to the RuneRunners Runescape service page</b></u></i><br>
<i>The currrent Runerunners are:<br>
<!--begin Database Data-->
<?php
picspprep(1,$connection);
picspprep(2,$connection);
?>
<!--end Database Data-->
<hr>
To order a service, click on the running rune below that matches the one on
the player you want to buy from above
</i>
<table cellspacing="2" cellpadding="2" border="1">
<tr>
<td>Service</td>
<td>Prices</td>
<td>Required Items</td>
</tr>
<!--loop database data to create table-->
<?php
$id=1;
while($id<=296){
tablecreate($id,$connection);
$id=$id+1;
};
?>
<!-- end loop -->
</table>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
