Thanks Pablo, that worked.
"Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello Harry,
> you can use left join:
> http://dev.mysql.com/doc/mysql/en/JOIN.html
>
> $query = "
> SELECT members.id, firstname, familyname, middlename, fathername,
> re
Hello Harry,
you can use left join:
http://dev.mysql.com/doc/mysql/en/JOIN.html
$query = "
SELECT members.id, firstname, familyname, middlename, fathername,
region3.region3, region4, members.country, country.countryname,
MATCH(firstname, middlename, familyname, father
Hi,
I want to run a query on a table while joining it with other tables.
Table 1- members
id - firstname - middlename - - country - region3
Fields country and region3 hold the integer codes for country and region3 is state
Table 2- country
id - countryname
Countryname is where the actual Co
