array

[dreamwest]

Ive drawn some database info but i need to change one key value

while ($new = mysql_fetch_assoc($res)){
    $latest[] = $new;
}
print_r($latest);

 

 

which prints:

Array ( 

[0] => Array ( 
[id] => 1063636 
[vid] => 41321 
[es_title] => another title
)

[1] => Array ( 
[id] => 1063635 
[vid] => 02003 
[es_title] => another title
)

[2] => Array ( 
[id] => 1063634 
[vid] => 51605 
[es_title] => another title
)
) 

 

How can i replace [es_title] with just [title] so it looks like this

Array ( 

[0] => Array ( 
[id] => 1063636 
[vid] => 41321 
[title] => another title
)

[1] => Array ( 
[id] => 1063635 
[vid] => 02003 
[title] => another title
)

[2] => Array ( 
[id] => 1063634 
[vid] => 51605 
[title] => another title
)
) 

 

 

[PFMaBiSmAd]

In your query, use title as an alias name for es_title

[dreamwest]

Something like this?

 

$res = mysql_query("SELECT *,`es_title` as `title` FROM `table` LIMIT 3 ");