[SOLVED] Is it possible to create an extra field during a select query

[derrick24]

Hi, is it possible to create an extra field during a select query and set the values of that field. ie: fakeField does not exist in the database, but I need it to be part of the returned array for manipulation in php

 

SELECT table.*, table.fakeField=10 FROM table

 

thanks

[derrick24]

IF I could do the as posted above, I would not have to write something like below.

 

if(count($newArray) > 0)

{

// Combine products with number or orders

foreach($newArray as $key => $value)

{

foreach($array as $subKey => $subValue)

{

if ($newArray[$key]['id'] == $subKey)

{

$newArray[$key]['amount'] = $subValue;

}

}

}

return $newArray;

}

[fenway]

Hi, is it possible to create an extra field during a select query and set the values of that field. ie: fakeField does not exist in the database, but I need it to be part of the returned array for manipulation in php

 

SELECT table.*, table.fakeField=10 FROM table

 

thanks

 

Sure... use this:

 

SELECT table.*, '10' as fakeField FROM table

 

[derrick24]

Awesome, thanks