不同论坛php的一般价格

发布于 2024-11-18 04:45:37 字数 523 浏览 3 评论 0原文

我有 3 个表 = "forums" | “主题”| “用户” 在“论坛”表中，我有一个名为“价格”的字段在“主题”表中，我有一个名为“poster_id”的字段在“用户”表中，我有一个名为“group_id”的字段三个表中都有字段user_id

每个论坛都有不同的价格，例如forum_id 1，价格0.50 仅当主题中的 poster_id 与用户中的 group_id 兼容时，我才想查询所有主题例如，只有当用户写的消息是已注册的

查询后，我想向所有已注册的用户呈现他在每个论坛上写的主题数并按照各论坛的价格执行所有科目的总价。

示例：

forum_id 1 = 0.50 $
forum_id 2 = 0.60 $
forum_id 3 = 0.10 $

结果：

username | earn $ 1.20

抱歉我的英语不好，我不是来自美国；）

谢谢！

原文

I have 3 tables = "forums" | "topics" | "users"
In the table "forums" I have a field called "price"
In the table "topics" I have a field called "poster_id"
In the table "users" I have a field called "group_id"
In the three tables have the field user_id

Every forum has a different price, for example forum_id 1, price 0.50
I want to query all of the topics only if the poster_id from topics compatible with group_id in users
For example, only if the user wrote the message is a Registered

After the query, I want to present to all Registered the number of topics that he wrote each forum
And perform general price of all subjects according to the price of every forum.

Example:

Registered, written 3 topics in 3 different forums

forum_id 1 = 0.50 $
forum_id 2 = 0.60 $
forum_id 3 = 0.10 $

Result:

username | earn $ 1.20

sorry about my english, im not from usa ;)

thank you!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

清风不识月 2024-11-25 04:45:37

像这样的东西：

SELECT `users`.`username`, SUM(`forums`.`price`)
FROM `topics` 
LEFT JOIN `users` ON `topics`.`user_id`=`users`.`user_id` AND `users`.`group_id`=100
LEFT JOIN `forums` ON `topics`.`user_id`=`forums`.`user_id`
GROUP BY 2
ORDER BY 1

Something like this:

SELECT `users`.`username`, SUM(`forums`.`price`)
FROM `topics` 
LEFT JOIN `users` ON `topics`.`user_id`=`users`.`user_id` AND `users`.`group_id`=100
LEFT JOIN `forums` ON `topics`.`user_id`=`forums`.`user_id`
GROUP BY 2
ORDER BY 1

回复收藏 0 原文

~没有更多了~