Re: [PHP-DB] ummm i am confused

[water_foul]

oh... duh why didn't i see that
"Mikhail U. Petrov" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi!
> Insert one more bracket!
>  //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>  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 ('' . $item[1] . ' w> src=module/runescape/Runerunner/' . $user1[1] . '.gif>' . $user1[2].
> w> '' .
> w> $user2[2]. '' . $item[2] . '');
> w> };
>
> w> //this function is called by another
> w> function picscreate($Rune,$username,$num){
> w> print('' .
$username
> w> . '');
> 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> Welcome to the RuneRunners Runescape service
page
> w> The currrent Runerunners are:
> w> 
> w>  w> picspprep(1,$connection);
> w> picspprep(2,$connection);
> ?>>
> w> 
> w> 
> 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> 
> w> 
> w> 
> w> Service
> w> Prices
> w> Required Items
> w> 
> w> 
> w>  w> $id=1;
> w> while($id<=296){
> w> tablecreate($id,$connection);
> w> $id=$id+1;
> w> };
> ?>>
> w> 
> w> 
>
>
>
> -- 
> 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

Re: [PHP-DB] ummm i am confused

[Mikhail U. Petrov]

Hi!
Insert one more bracket!
 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>  //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 ('' . $item[1] . ' src=module/runescape/Runerunner/' . $user1[1] . '.gif>' . $user1[2].
w> '' .
w> $user2[2]. '' . $item[2] . '');
w> };

w> //this function is called by another
w> function picscreate($Rune,$username,$num){
w> print('' . $username
w> . '');
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> Welcome to the RuneRunners Runescape service page
w> The currrent Runerunners are:
w> 
w>  picspprep(1,$connection);
w> picspprep(2,$connection);
?>>
w> 
w> 
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> 
w> 
w> 
w> Service
w> Prices
w> Required Items
w> 
w> 
w>  $id=1;
w> while($id<=296){
w> tablecreate($id,$connection);
w> $id=$id+1;
w> };
?>>
w> 
w> 



-- 
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

[PHP-DB] ummm i am confused

[water_foul]

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:
' . $item[1] . '' . $user1[2].
'' .
$user2[2]. '' . $item[2] . '');
};

//this function is called by another
function picscreate($Rune,$username,$num){
print('' . $username
. '');
${'' . $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);
};
?>
Welcome to the RuneRunners Runescape service page
The currrent Runerunners are:




To order a service, click on the running rune below that matches the one on
the player you want to buy from above



Service
Prices
Required Items






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