Query and Result help

[patrickipsen]

Hi there,

I have a table "cubecart_customer" and in that table I have field named user_group_id and in table "cubecart_adg_groups_mod" I have a field named group_id - user_group_id and group_id is the same.

I want to display on my site a field named group_limit also in table "cubecart_adg_groups_mod"

Can somebody plese help me with the query and the php code.


Thanks for help.

Patrick

[resullivan]

the query would be

SELECT GROUP_LIMIT FROM CUBECART_ADG_GROUPS_MOD

As far as the php refer to

connecting to mysql (http://us2.php.net/manual/en/ref.mysql.php)

Run query and get data (http://us2.php.net/manual/en/function.mysql-fetch-assoc.php)

[patrickipsen]

Hi thanks for your reply,

But the user_group_id and group_id have to match to get the right group_limit

user_group_id table "cubecart_customer"
group_id table"cubecart_adg_groups_mod"

Could you try to make query with that?

Thanks
Patrick

[resullivan]

Hi thanks for your reply,

But the user_group_id and group_id have to match to get the right group_limit

user_group_id table "cubecart_customer"
group_id table"cubecart_adg_groups_mod"

Could you try to make query with that?

Thanks
Patrick

SELECT GROUP_LIMIT_GROUP_ID FROM CUBECART_CUSTOMER, CUBECART_ADG_GROUPS_MOD WHERE USER_GROUP_ID = GROUP_ID

[patrickipsen]

Great Thanks,

How can I then show the result of the query?

Thanks again,

Patrick

[patrickipsen]

Somebody that can help me to show the result of the query

SELECT GROUP_LIMIT_GROUP_ID FROM CUBECART_CUSTOMER, CUBECART_ADG_GROUPS_MOD WHERE USER_GROUP_ID = GROUP_ID

Thanks

Patrick