subject:"\[PHP\] Mysql Query Help needed"

RE: [PHP] Mysql Query Help needed

2002-05-16 Thread Jay Blanchard

[snip] "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" [/snip] try this (note syntactical differences); "select cust_fnn, cust_name, agroup

[PHP] Mysql Query Help needed

2002-05-16 Thread Chris Kay

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