On Sun, 29 Oct 2006 23:04:27 -0600, Richard Lynch wrote:
On Sun, October 29, 2006 2:06 am, Beauford wrote:
LOL, I don't know either. The format is - 01/01/2006. When I first did
it I
used 7, which should be right, but I ended up getting /2002 /2003,
etc. So I
went to 8 and all was well.
: PHP
Subject: Re: [PHP] Query question
Look into the MySQL YEAR() function to extract the year from a specific
date.
Start here:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
On 10/28/06, Beauford [EMAIL PROTECTED] wrote:
I posted this here as I figured I would need
On Sun, 2006-10-29 at 01:05 -0500, Beauford wrote:
This is what I finally figured out, which works just perfectly.
select count(date) as count, substring(date,8) as year from stats group by
year;
Thanks to all for the input.
So what you're saying is that you're not using a date field,
@lists.php.net
Sent: Sunday, October 29, 2006 7:05 AM
Subject: RE: [PHP] Query question
This is what I finally figured out, which works just perfectly.
select count(date) as count, substring(date,8) as year from stats group by
year;
Thanks to all for the input.
-Original Message-
From
and all was well. Beats me.
B
-Original Message-
From: Satyam [mailto:[EMAIL PROTECTED]
Sent: October 29, 2006 2:14 AM
To: Beauford; 'PHP'
Subject: Re: [PHP] Query question
If that works then you have a problem: you are storing dates as a plain
string ( varchar or whatever
went to 8 and all was well. Beats me.
B
-Original Message-
From: Satyam [mailto:[EMAIL PROTECTED]
Sent: October 29, 2006 2:14 AM
To: Beauford; 'PHP'
Subject: Re: [PHP] Query question
If that works then you have a problem: you are storing dates as a plain
string ( varchar or whatever
] Query question
I said that you have a problem,not that you caused it, and my observation
might (hopefully) help newbies in the list.
Satyam
- Original Message -
From: Beauford [EMAIL PROTECTED]
To: 'PHP' php-general@lists.php.net
Sent: Sunday, October 29, 2006 9:06 AM
Subject: RE: [PHP
29, 2006 4:30 AM
To: Beauford; 'PHP'
Subject: Re: [PHP] Query question
I said that you have a problem,not that you caused it, and my
observation
might (hopefully) help newbies in the list.
Satyam
- Original Message -
From: Beauford [EMAIL PROTECTED]
To: 'PHP' php-general@lists.php.net
On Sun, October 29, 2006 2:06 am, Beauford wrote:
This is how I get the data and I have no control over the actual
layout of
the database. So I have to work with what I have.
When you say it's how you get the data are they handing you a MySQL
database that is this badly-constructed?
Or are
Use the mysql list :)
On Oct 28, 2006, at 3:01 PM, Beauford wrote:
Hi,
I have a MySQL database with a date field and a bunch of other
fields. The
date field is in the format - 01/01/2006. What I want to do is
query the
database and create a table that shows just the year and how many
Agreed, this should go to a MySQL list. But in the spirit of helping I think
the following should give you a good starting point.
SELECT `year`, COUNT(`year`) AS `count` FROM `tbl` GROUP BY `year` ASC
On 10/28/06, Ed Lazor [EMAIL PROTECTED] wrote:
Use the mysql list :)
On Oct 28, 2006, at
I'd need to use PHP to maybe put it in an array first or something.
Thanks
-Original Message-
From: Joe Wollard [mailto:[EMAIL PROTECTED]
Sent: October 28, 2006 10:30 PM
To: Ed Lazor
Cc: Beauford; PHP
Subject: Re: [PHP] Query question
Agreed, this should go to a MySQL list
-Original Message-
From: Joe Wollard [mailto:[EMAIL PROTECTED]
Sent: October 28, 2006 10:30 PM
To: Ed Lazor
Cc: Beauford; PHP
Subject: Re: [PHP] Query question
Agreed, this should go to a MySQL list. But in the spirit of helping I
think
the following should give you a good starting point.
SELECT
whats the error, are there any matching fields for the columns
eventetail.event and event.id?
Jason
Karl-Heinz Schulz [EMAIL PROTECTED] wrote:
Why does this query not work?
It should only show the eventdetails for the shown event.
Davidson'
Subject: RE: [PHP] Query Question
Oops - it shows all the eventdetails for all the events
-Original Message-
From: Jason Davidson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 10:10 PM
To: Karl-Heinz Schulz; [EMAIL PROTECTED]
Subject: Re: [PHP] Query Question
whats
On Wednesday 15 January 2003 01:47, Kelly Meeks wrote:
I've got an array of values, that I need to query against a database to see
if any records have any of the values in the array - the array is a list of
zip codes, and the database contains a list of stores. Basically i need to
find what
Untested, but should work
Steve Buehler wrote:
function getstart_end(){
$result=mysql_query(SELECT * FROM aplayabletimes ORDER BY min);
while(($row=mysql_fetch_object($result))){
if(!$i){
echo $row-min . - ;
$i=$row-min;
}else{
$tmp =
One mistake
Marek Kilimajer wrote:
Untested, but should work
Steve Buehler wrote:
function getstart_end(){
$result=mysql_query(SELECT * FROM aplayabletimes ORDER BY min);
while(($row=mysql_fetch_object($result))){
if(!$i){
echo $row-min . - ;
Thanks for the help, but that is not actually producing the desired results
either. This returns the following results:
00:00:05 - 00:00:05
00:00:05 - 5
00:00:05 - 10
00:00:05 - 15
00:00:10 - 20
00:00:10 - 25
00:00:10 - 30
00:00:10 - 35
00:00:15 - 40
00:00:15 - 45
00:00:15 - 50
00:00:15 - 55
Ok. That output was my fault. I had an error in one of my other
functions. I needed to set $hours to 00 to start with in my
populatetemptable() function. Now my output is:
00:05:00 - 00:05:00
00:05:00 - 00:10:00
00:10:00 - 00:15:00
00:10:00 - 00:20:00
00:15:00 - 00:25:00
00:15:00 - 00:30:00
This is checked:
function getstart_end(){
$result=mysql_query(SELECT * FROM aplayabletimes ORDER BY min);
while(($row=mysql_fetch_object($result))){
if(!$i){
echo $row-min . - ;
$i=$row-min;
} else {
Not sure if I wrote and thanked you or not, but this did the trick. THANK
YOU THANK YOU THANK YOU!!!
Steve
At 08:41 PM 11/14/2002 +0100, Marek Kilimajer wrote:
This is checked:
function getstart_end(){
$result=mysql_query(SELECT * FROM aplayabletimes ORDER BY min);
On Mon, May 21, 2001 at 10:36:42AM -0500, Jacky wrote :
What do I do if i want to move all values stored in one field
to another field in the same table, from field A to field B?
Has anyone ever done that?
As simple as you think it should be
UPDATE table SET column_a = column_b
-
several times:
UPDATE table SET B=A;
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-Original Message-
From: Jacky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 12:37 AM
To: [EMAIL
24 matches
Mail list logo