Hi
i am retrieving records from database and putting each row in a array
here is the code
@ $db = mysql_connect ($server, $user, $pass);
mysql_select_db($database);
$query = "SELECT Game_ID FROM games WHERE Game_Category='$Game_Category'";
$result= mysql_query($query);
$total_numbers = mysql_num_rows($result);
$startingID=$_GET['startingID'];
$startingID = ($startingID) ? $startingID : 0; //if rec is passed in, use it,
$row = array();
$test_tr = mysql_query("select * from games WHERE
Game_Category='$Game_Category' order by Game_ID desc LIMIT
$startingID,
$items_numbers_list");
$num = mysql_num_rows($test_tr);
while ($record=mysql_fetch_array($test_tr)){
$record[Game_ID] = stripslashes($record[Game_ID]);
$record[Game_Picture_Small] = stripslashes($record[Game_Picture_Small]);
$record[Game_Name] = stripslashes($record[Game_Name]);
$record[Game_Title] = stripslashes($record[Game_Title]);
$record[Game_Description] = stripslashes($record[Game_Description]);
$record[Game_Full_Story] = stripslashes($record[Game_Full_Story]);
$record[Game_Screen_Shot_1] = stripslashes($record[Game_Screen_Shot_1]);
$record[Game_Screen_Shot_2] = stripslashes($record[Game_Screen_Shot_2]);
$record[Game_Screen_Shot_3] = stripslashes($record[Game_Screen_Shot_3]);
$record[Game_Status] = stripslashes($record[Game_Status]);
$record[Game_Play_Score] = stripslashes($record[Game_Play_Score]);
$record[Game_Category] = stripslashes($record[Game_Category]);
$Game_Esrb_Rating = intval($record[Game_Esrb_Rating]);
echo $record[Game_Esrb_Rating];
if($Game_Esrb_Rating < 1){
$Esrb_Rate_Pic = "bar_rating_star_0.gif";
}elseif ($Game_Esrb_Rating < 2){
$Esrb_Rate_Pic = "bar_rating_star_1.gif";
}elseif ($Game_Esrb_Rating < 3){
$Esrb_Rate_Pic = "bar_rating_star_2.gif";
}elseif ($Game_Esrb_Rating < 4){
$Esrb_Rate_Pic = "bar_rating_star_3.gif";
}elseif ($Game_Esrb_Rating < 5){
$Esrb_Rate_Pic = "bar_rating_star_4.gif";
}elseif ($Game_Esrb_Rating = 5){
$Esrb_Rate_Pic = "bar_rating_star_5.gif";
}
$row[] = $record;
$row[Esrb_Rate_Pic] = $Esrb_Rate_Pic;
}
my problem is with $Esrb_Rate_Pic, i can't put its value to the array
, i used $row[Esrb_Rate_Pic] = $Esrb_Rate_Pic; but it didn't work
can anyone help?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
