[SOLVED] Adding hack to PHP to mimick database row?

[ecopetition]

Hi all,

 

I have the following sample code for selecting a row:

$sql = "SELECT *
FROM names
WHERE surname = $input_surname
AND gender = $input_gender
ORDER BY surname ASC";
$result = $db->query($sql);
while($row = $db->fetch_assoc($result))
{
$names[] = $row;
}

 

Is it at all possible to add entries into the the $names[] array which are not in the names table but in a different table with different column titles?

 

For example, I have my $names array, with a first_name column, surname column and gender column, but have another table called more_names, with a surname_column, location column, and height column. I don't care too much about the location and height column, but of the surname column, is it possible to merge these rows into the $names array (whilst assigning default values for the first_name column and gender column?)?

 

I hope this is understandable enough.

 

Thanks a lot

Eco

[taquitosensei]

more of a mysql question. But you'll want to use a UNION

$sql = "SELECT first_name,surname,gender 
FROM names
where surname=$input_surname 
and gender=$input_gender
UNION 
select 
'default_firstname' as first_name, 
surname, 
'default_gender' as gender 
from more_names
WHERE surname = $input_surname
ORDER BY surname ASC";

you may have to tweak it some and it hasn't been test yet. But that should point you in the right direction.

[ecopetition]

Thank you Sir, much appreciated.