Cross Checking Tables...

[adamjblakey]

What i am trying to do is the following which i cannot work out how to do.

 

Basically with the below i want to loop through the results checking against another table to see if any of the "country" fields match.

 

So when i have the results from $cresults i need to check them against table2 to see if the country fields matches on any of the entries?

 

function selects($select) {
$this->result = mysql_query($select,$this->connection);
$this->row = mysql_fetch_assoc($select);
}

function getRes() {
while ($res = mysql_fetch_array($this->result)) {
$this->reser[] = $res;
		}
return $this->reser;
	}

$current = new database;
$current->selects("SELECT * FROM table");
$cresults = $current->getRes();

[roopurt18]

Why don't you just use an INNER JOIN?

http://dev.mysql.com/doc/refman/5.0/en/join.html

[adamjblakey]

I have never used this before and would not know how to go about it.

 

Can you please show me how i would do this.

[roopurt18]

If you look at the link I gave you, there are MySQL examples of joining data on multiple tables.