oh... duh why didn't i see that
"Mikhail U. Petrov" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to