Hi
Here's the senario...
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 Country name is stored and id is the country code
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
il program are you using? I'm getting mail parsing errors.
>
> In addition, you have your From set as:
>
> "Harry G"
>
> Likely, ( and ) aren't supposed to be in there (invalid chars) and it
> also makes it impossible to reply to you. There is no other &qu
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
Thank you everybody.
"Harry G" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I have a database with members details and PK is id.
>
> $thing = "[EMAIL PROTECTED]";
>
> $query = "SELECT id, email, familyname FROM members
Hi,
I have a database with members details and PK is id.
$thing = "[EMAIL PROTECTED]";
$query = "SELECT id, email, familyname FROM members WHERE email=$thing";
$result = mysql_query($query);
If i do a query where id=$thing.
and $thing="20";
this works fine and I get the desired result. But what
