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