This is my problem.. I've wrote a script which searches for prices in each city for a drug. It's for a game.. I need to somehow work in the city array so that it will echo back all prices in every city when displayed,.. instead of just one.. the array is in the script below.
<?
$drugsearchprice = 400000;
//pulls user city and cash amount
$user ="SELECT * FROM user_characters WHERE nickname='$stats_array[nickname]'";
$user = mysql_query($user);
$user = mysql_fetch_array($user);
$usercity = $user[city];
$usercash = $user[cash];
If ($usercash < $drugsearchprice)
{
echo '<center>You do not have enough money to pay your informant!</center> ';
echo "<a href='driver.php?x=bank'><center><b><font color=red>[Bank]</b></font></a><br>(Make a Withdrawl)</center><br>";
}
else
{
//selects city and drug prices that match user city
$citydrugs = "SELECT * FROM prices_drugs WHERE city='$usercity'";
$citydrugs = mysql_query($citydrugs);
$citydrugs = mysql_fetch_array($citydrugs);
$cities_array = array (
1 => "Beijing",
2 => "Bogota",
10 => "Boston",
3 => "Las Vegas",
4 => "Montreal",
5 => "Moscow",
6 => "Nottingham",
7 => "Paris",
8 => "Sicily",
9 => "Sydney",
11 => "Tokyo"
);
$coke = $citydrugs[cocaine];
$heroin = $citydrugs[heroin];
$ecstasy = $citydrugs[ecstasy];
$shrooms = $citydrugs[shrooms];
$marijuana = $citydrugs[marijuana];
$pills = $citydrugs[pills];
echo '<b>';
echo $usercity;
echo '</b>';
echo '<br>';
echo "$".number_format($heroin)." (1) bag of heroin.";
echo '<br>';
echo "$".number_format($coke)." (1) bag of coke.";
echo '<br>';
echo "$".number_format($ecstasy)." (1) bag of ecstasy.";
echo '<br>';
echo "$".number_format($shrooms)." (1) bag of shrooms.";
echo '<br>';
echo "$".number_format($marijuana)." (1) bag of marijuana.";
echo '<br>';
echo "$".number_format($pills)." (1) bag of pills.";
$query="UPDATE $prefix.user_characters SET cash=cash-$drugsearchprice WHERE nickname='$stats_array[nickname]'";
$result=mysql_query($query);
echo "<a href='driver.php?x=drugmarket'><center><b><font color=red>[Back to Drug Market!]</b></font></a></center><br>";
}
?>
