943,962 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 2890
  • MySQL RSS
Feb 20th, 2005
0

Connection problem

Expand Post »
Hi,
I have a small problem I have a flash game SWF file not the fla and it sends and recieves values from a PHP file send - update and recieve is INIT

Great except the person who gave me the SWF and PHP file did not tell me how to set up the database If I was to post the code could someone tell me the table layout to wright with PHP My Admin?

I know its only a small database we are talking 4 or 5 objects in 1 table but I just cant get my head around the code not knowing PHP

Cheers

Kev
Similar Threads
Reputation Points: 11
Solved Threads: 0
Light Poster
kevin_smithers is offline Offline
44 posts
since Feb 2005
Feb 21st, 2005
0

Re: Connection problem

Sure, post the code. It'd help.
Team Colleague
Reputation Points: 53
Solved Threads: 5
PHP/vBulletin Guru
Gary King is offline Offline
360 posts
since Nov 2003
Feb 21st, 2005
0

Re: Connection problem

[PHP]<?

if ($command=="init"){
$link = @mysql_connect("localhost", "username", "password");

if (!$link){
print "&message=Error connecting to database";
exit;
}

if (!@mysql_select_db("kevinsmi_game")){
print "&message=Couldn't select database";
exit;
}

$players = "";
$scores = "";
$distances = "";
$victims = "";
$innerquery = "SELECT * FROM game ORDER BY scores DESC";
$innerresult = @mysql_query($innerquery);
$numPlayers=mysql_num_rows($innerresult);
for($loop=0;$loop<$numPlayers; $loop++) {
$newPlayer = mysql_result($innerresult,$loop,"players");
$newScore = mysql_result($innerresult,$loop,"scores");
$newDistance = mysql_result($innerresult,$loop,"distances");
$newVictim = mysql_result($innerresult,$loop,"victims");
$players = "$players<br>$newPlayer";
$scores = "$scores<br>$newScore";
$distances = "$distances<br>$newDistance";
$victims = "$victims<br>$newVictim";
}
printf("&players=%s", $players);
printf("&scores=%s", $scores);
printf("&distances=%s", $distances);
printf("&victims=%s", $victims);

mysql_close($link);


}


if ($command=="update"){
$link = @mysql_connect("localhost", "username", "password");

if (!$link){
print "&message=Error connecting to database";
exit;
}

if (!@mysql_select_db("game")){
print "&message=Couldn't select database";
exit;
}

$players = "";
$scores = "";
$query = "SELECT scores FROM game where players = '$name'";
$result = @mysql_query($query);
if(@mysql_num_rows($result)>0){
$oldScore = mysql_result($result,"scores");
if($score>$oldScore){
$query = "UPDATE game SET scores = '$score' where players = '$name'";
$result = @mysql_query($query);
}
}

else {
$query ="INSERT INTO game (players, scores, distances, victims) VALUES ('$name', '$score', '$distance', '$victim')";
$result = @mysql_query($query);
}

$innerquery = "SELECT * FROM game ORDER BY scores DESC";
$innerresult = @mysql_query($innerquery);
$numPlayers=mysql_num_rows($innerresult);
for($loop=0;$loop<$numPlayers; $loop++) {
$newPlayer = mysql_result($innerresult,$loop,"players");
$newScore = mysql_result($innerresult,$loop,"scores");
$newDistance = mysql_result($innerresult,$loop,"distances");
$newVictim = mysql_result($innerresult,$loop,"victims");
$players = "$players<br>$newPlayer";
$scores = "$scores<br>$newScore";
$distances = "$distances<br>$newDistance";
$victims = "$victims<br>$newVictim";
}
printf("&players=%s", $players);
printf("&scores=%s", $scores);
printf("&distances=%s", $distances);
printf("&victims=%s", $victims);

mysql_close($link);
}
?>[/PHP]
Reputation Points: 11
Solved Threads: 0
Light Poster
kevin_smithers is offline Offline
44 posts
since Feb 2005
Feb 27th, 2005
0

Re: Connection problem

So... you realize you are trying to use 2 databases??

for command == "init" you have: mysql_select_db("kevinsmi_game")

for command == "update" you have mysql_select_db("game")

As far as the table:
db name: kevinsmi_game
table: game
field1: players
field2: scores
field3: distances
field4: victims
Reputation Points: 17
Solved Threads: 14
Posting Whiz
DanceInstructor is offline Offline
355 posts
since Feb 2005
Feb 27th, 2005
0

Re: Connection problem

Cheers for that didn't notice I hadn't changed the second connection values :-)

I still can't get the thing to work though!! It is bugging me, I have the database set up as you have layed out above and that is how I have had it done from the start, but I just can't get it to read or write ot the database I have set up a simple table on a blank page and connected to the database through a simple table connection in dreamweaver and that works OK!!!!!!
Reputation Points: 11
Solved Threads: 0
Light Poster
kevin_smithers is offline Offline
44 posts
since Feb 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: what to do with this .SQL script?
Next Thread in MySQL Forum Timeline: MySQL Functions W/ Offline Languages





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC