473,230 Members | 1,458 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

Two simple questions... with reagrd to PHP and MySQL

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
Jul 17 '05 #1
14 1791
Domestos wrote:
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

Jul 17 '05 #2
> 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

Jul 17 '05 #3
| 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 !!!
Jul 17 '05 #4

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 !!!


Steve,

when one is a novice and is trying to get the job done in the least amount
of time without having to wade through pages and pages of crap and unrelated
muck that google chucks up is that not a better use of ones time?

Thanks
Andy Mak
Jul 17 '05 #5
I found the tutorial on the mysql site a very worthwhile half an hour

http://dev.mysql.com/doc/mysql/en/tutorial.html

Jul 17 '05 #6

<pe**********@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
I found the tutorial on the mysql site a very worthwhile half an hour

http://dev.mysql.com/doc/mysql/en/tutorial.html


Now you see - that is what I am after - but i'm just to lazy and crap at
searching to find somthing like that...

Andy Mak
Jul 17 '05 #7
hmmmm...php.net; mysql.com.

hardly a vision quest, now is it!

if they hired you to do this quick/dirty program, they've obviously failed
before you began to work on it.

but that discussion is for another day.
"Domestos" <ne*******@mind.net> wrote in message
news:N2******************@newsfe4-gui.ntli.net...
|
| >
| > 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 !!!
| >
| >
|
| Steve,
|
| when one is a novice and is trying to get the job done in the least amount
| of time without having to wade through pages and pages of crap and
unrelated
| muck that google chucks up is that not a better use of ones time?
|
| Thanks
| Andy Mak
|
|
Jul 17 '05 #8
| Now you see - that is what I am after - but i'm just to lazy and crap at
| searching to find somthing like that...

BINGO !!!

the truth exposed..."i'm just to[o] lazy and crap[y] at searching to find
something like that".
Jul 17 '05 #9
Domestos wrote:


Steve,

when one is a novice and is trying to get the job done in the least
amount of time without having to wade through pages and pages of crap
and unrelated muck that google chucks up is that not a better use of
ones time?


First of all, there is the MySQL manual. Second, there are dozens of books
covering the subject.

If you were to take 30 minutes reading the first couple chapters of one, you
wouldn't even have to spend the time waiting for a response here.

So, in the interest of saving time (the time saved reading the manual or a
basic primer on MySQL - maybe a couple hours or so), you end up wasting even
more time (the time spent waiting for a response here, EVERY time you have a
question - eventually adding up to many hours).

Yep, sounds really efficient to me...

--
Tony Garcia
Web Right! Development
Jul 17 '05 #10
Domestos wrote:


Steve,

when one is a novice and is trying to get the job done in the least amount
of time without having to wade through pages and pages of crap and unrelated
muck that google chucks up is that not a better use of ones time?

Thanks
Andy Mak


And why should I care about how much time it takes you to get a job done
if you won't RTFM?

I enjoy helping others out. However, you'll learn a lot more by
spending a little time looking for the answer and trying to figure it
out for yourself.

Asking a question here may be a better use of YOUR time - but when it's
ITFM it's a waste of everyone else who reads this newsgroup's time. And
pretty soon you won't be able to get ANY answer - even if it isn't ITFM.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 17 '05 #11
I posted the link to help you but also to show that a great tutorial is
right on the site where you actually get mysql. This is often the case.
And when that is a problem try searches like this in google

mysql tutorial
php tutorial
xhtml tutorial

I try to ask questions in a forum when I have tried with reasonable
effort but failed on my own.

Jul 17 '05 #12
On Tue, 28 Jun 2005 20:22:18 GMT, "Domestos" <ne*******@mind.net> wrote:

<pe**********@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googleg roups.com...
I found the tutorial on the mysql site a very worthwhile half an hour

http://dev.mysql.com/doc/mysql/en/tutorial.html


Now you see - that is what I am after - but i'm just to lazy and crap at
searching to find somthing like that...

Andy Mak

No, that's not it. The word that most applies is "arrogant".
Jul 17 '05 #13
pe**********@yahoo.com wrote:
I found the tutorial on the mysql site a very worthwhile half an hour

http://dev.mysql.com/doc/mysql/en/tutorial.html

I downloaded the help file which includes that & is searchable, etc.
Very helpful.
Jul 17 '05 #14

"Domestos" <ne*******@mind.net> wrote in message
news:_j*****************@newsfe5-gui.ntli.net...

<pe**********@yahoo.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
I found the tutorial on the mysql site a very worthwhile half an hour

http://dev.mysql.com/doc/mysql/en/tutorial.html


Now you see - that is what I am after - but i'm just to lazy and crap at
searching to find somthing like that...


Well, there's your first mistake. We sit in our seats hour upon hour
searching and learning. If you are unable to do the same, then this isn't
something that *you* can learn.
Jul 17 '05 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

30
by: Dimitris | last post by:
Hi folks... As part of an assignment, I have to design and implement a fairly small MYSQL 4.0.17 database for a fictitious travel agency. This database will store data from customers submitting...
2
by: David List | last post by:
I posed a MySQL C API question a few days back here, and got zero answers. I assume it is because this is not the right place to ask such questions. Does anyone here know where I could ask C API...
1
by: yiyun | last post by:
Hi, I am new to mysql and I want to ask a simple questions. I would like to initialize my InnoDB table space and I configure like below: ...
27
by: one man army | last post by:
Hi All- I am new to PHP. I found FAQTS and the php manual. I am trying this sequence, but getting 'no zip string found:'... PHP Version 4.4.0 $doc = new DomDocument; $res =...
1
by: E.T. Grey | last post by:
Hi All, Despite spending the past six to seven hours perusing the docs on the mySQl site, I still have questions unanswered, and have been unable to get any help. I am familiar with Sybase, some...
1
by: E.T. Grey | last post by:
I have been busting my nut over this for pretty much most of the day and it is driving me nuts. I posted this to an mySQL ng yesterday and I have not had any response (I'm pulling my hair out...
7
by: Ivan Marsh | last post by:
Hey Folks, I'm having a heck of a time wrapping mind around AJAX. Anyone know of a simple, straight-forward example for pulling a simple query from mysql with PHP using AJAX? As I...
4
by: yogesh | last post by:
mysql in c++ initialize error occurs a simple program is executed in redhat9.0 , using gcc 3.2.2 compiler version ... #include <stdio.h> #include <mysql.h> #include <string.h> int main() {
4
by: Andrey | last post by:
Hi, I will be hiring a php guru to help us architect a highly scalable web site/web application; the problem is I am coming from Microsoft .NET world and not too much familiar with the platform....
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.