I have a query
"select cust_fnn, cust_name, agroup_access.group_access_cust from cust,
agroup_access where
agroup_access.group_access_group='$id' &&
cust.cust_fnn!=agroup_access.group_access_cust order by cust.cust_name"
The 2 tables are as follows
agroup_access
agroup_access_id agroup_access_group
agroup_access_cust
1 9
1610005847
2 9
0265478986
3 9
1610010254
Cust
cst_id cust_name cust_fnn (ect....)
1 xxx 1610005847
2 xxxxx 0265478986
And so on.... 200+ records
What I am trying to do is pull all records from cust where cust_fnn !=
agroup_access_cust && agroup_access_group=9..
What I am getting is all cust_fnn records but 3 of each and only 2 in
the case of it matching the
agroup_access_cust..
Can anyone see what I may have dome wrong..
I am trying to display them in a drop down box, below is the function
for the drop down box and the line to call the function..
combo5("fnn","select cust_fnn, cust_name,
agroup_access.group_access_cust from cust, agroup_access where
agroup_access.group_access_group='$id' &&
cust.cust_fnn!=agroup_access.group_access_cust order by
cust.cust_name","");
function combo5($name, $query, $sel) {
$dbq=mysql_query($query);
$html="<select name=\"$name\" class=\"longdd\">\n";
while( $data = mysql_fetch_array($dbq) ) {
if($data[cust_fnn]==$sel)
$html.="<option value=$data[cust_fnn]
selected>$data[cust_name] : $data[cust_fnn]</option>\n";
else
$html.="<option
value=$data[cust_fnn]>$data[cust_name]: $data[cust_fnn]</option>\n";
}
$html.="</select>\n";
return $html;
}
Hope someone can help...
-------
Chris Kay, Eleet Internet Services
[EMAIL PROTECTED]
-------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
