两个简单的问题......使用reagrd到PHP和MySQL [英] Two simple questions... with reagrd to PHP and MySQL

问题描述

TIA ...


1）需要从名为fixtures的表中选择所有行，其中home_team和

away_team等于team_code。什么SQL select语句会这样做？


2）我有一个名为fixture_date的变量，格式为dd-MMM-yy（即

02-Mar- 05）如何使用

PHP选择日/月/年？


谢谢

Andy Mak

Hi,

TIA...

1) Need to select all rows from table called fixtures where home_team and
away_team is equal to team_code. What SQL select statement would do this?

2) I have a variable called fixture_date in the format dd-MMM-yy (i.e.
02-Mar-05) how do I select the day/month/year into thier own variables using
PHP?

Thanks
Andy Mak

推荐答案

Domestos写道：

Domestos wrote:

TIA ......

1）需要从名为fixtures的表中选择所有行，其中home_team和
away_team等于team_code。什么SQL select语句会这样做？



阅读SQL基础知识怎么样？


SELECT * FROM fixture WHERE away_team = team_code或home_team = team_code

2）我有一个名为fixture_date的变量，格式为dd-MMM-yy（即
02-Mar-05）如何使用
PHP？


在php手册中查看strtotime（）。


问候

Stefan

谢谢
Andy Mak

Hi,

TIA...

1) Need to select all rows from table called fixtures where home_team and
away_team is equal to team_code. What SQL select statement would do this?

What about reading SQL basics?

SELECT * FROM fixture WHERE away_team=team_code OR home_team=team_code

2) I have a variable called fixture_date in the format dd-MMM-yy (i.e.
02-Mar-05) how do I select the day/month/year into thier own variables using
PHP?
Have a look at strtotime() in the php manual.

Regards
Stefan

Thanks
Andy Mak

>那么阅读SQL基础知识呢？


我更喜欢在这里询问的原因...


1）我得到了一个问题的答案在几分钟内，你们都很棒。

2）我不必在互联网上搜索花时间阅读页面

在页面上对我来说没有任何意义细节支出的每一分钟

30分钟

3）在网页上尝试这些例子后，他们要么不工作要么没有

其中缺少/不可理解的代码

4）这让我回到这里问问题但是30分钟下来

这条线

5 ）''你喜欢帮助别人你不会回答我的问题:)


谢谢


Andy Mak

> What about reading SQL basics?

Reasons why i prefer to ask in here...

1) I get an answer to my question in minutes, you guys are great.
2) I don;t have to search around the internet spending time reading pages
upon pages that mean nothing to me to find a minute bit of detail spending
30 minutes
3) After trying the example on the web page they either don''t work or have
missing/non understandable code in them
4) Which takes me back to asking the question in here but 30 minutes down
the line
5) ''cos you love helping people else you wouldn''t answer my questions :)

Thanks

Andy Mak

|我想在这里问的原因...

|

| 1）我会在几分钟内得到答案，你们很棒。

| 2）我不必在网上搜索花时间阅读页面

|在页面上，对我来说没有任何意义，可以找到一点点细节支出

| 30分钟

| 3）在网页上尝试这个例子后，他们要么不工作要么没有b $ b |其中缺少/不可理解的代码

| 4）这让我回到这里问问题但是30分钟下来

|这条线

| 5）''因为你喜欢帮助其他人，你不会回答我的问题:)


理由为什么你不会得到答复或者会被嘲笑...


1.提问一个人显然懒得rtfm来回答。

2.当答案是* IN时，浪费每个人的时间询问noob问题*首先是

gdfm而不是rtfm。

3.参考示例如果没有参考它就不能工作

或者发布一个自己的OWN非功能代码，这样我们就可以清除一个人的无力

到明白它。 （我怀疑是你的错，而不是你提到的其他代码！）。

4.坚持要求noob问题没有先试图解决问题

一个人的自我是获得问题答案或解决方案的最佳方式。

5.''cos）认为对所述问题的回答（s）的目的是帮助我们摆脱一个人的两难困境，就像我们其他人一样 - 这是对公众的侮辱在解决方案'显而易见的简单性！


您的假设是非常不准确和不合逻辑的...这完全是什么软件开发人员啰嗦!!! br />

RTFM !!!

| Reasons why i prefer to ask in here...
|
| 1) I get an answer to my question in minutes, you guys are great.
| 2) I don;t have to search around the internet spending time reading pages
| upon pages that mean nothing to me to find a minute bit of detail spending
| 30 minutes
| 3) After trying the example on the web page they either don''t work or have
| missing/non understandable code in them
| 4) Which takes me back to asking the question in here but 30 minutes down
| the line
| 5) ''cos you love helping people else you wouldn''t answer my questions :)

reasons why you won''t get a response or will be plonked...

1. asking questions one is obviously too lazy to rtfm to answer.
2. wasting everyone''s time asking noob questions when the answer is *IN* the
gdfm instead of rtfm in the first place.
3. referring to "examples" that don''t work without a reference either to it
or posting one''s OWN non-functional code so we can clear up ONE''s inability
to understand it. (my suspicion being that the fault is yours and NOT any
other code to which you refer!).
4. insisting that asking noob questions w/o first trying to resolve an issue
one''s self is the BEST way to get an answer or solution to a problem.
5. ''cos one believes a response to said question(s) was aimed at HELPING one
out of one''s dilemma RATHER THAN taking it - as the rest of us do - as a
blatant insult to the POSTER in the solution''s OBVIOUS simplicity!

your assumptions are grossly inaccurate and illogical...which are wholly
what software developers LOATH !!!

RTFM !!!

这篇关于两个简单的问题......使用reagrd到PHP和MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！