PHP - MySQL - Search date, count rows that have that date

Question

I have a query which pulls a count from a DB by searching by date and it's not returning what it should. There's 3 records in the database, type Date, with the date 2012-04-06.

$day is echoing out on the page as that date, so I know it's passing into the function right.

$countrows = "SELECT COUNT(*) FROM test_table WHERE startDate LIKE '" . $day. "'";
$countresult = mysql_query($countrows);
$count = mysql_fetch_row($countresult);
$finalcount = $count[0];

Just stuck, need a second, third, fourth set of eyes. I'm obviously missing something.

ALSO: I'd like the count to come out as an integer so I can do math with it.

Armatus · Accepted Answer · 2012-04-07 09:46:14Z

1

You're missing the step of $values = mysql_fetch_row($countresult). Your $countresult is a variable of type MYSQL_QUERYRESULT (or somesuch) rather than an array.

http://php.net/manual/en/function.mysql-fetch-row.php

Apart from that, DB queried values will always be strings first in PHP. just do a $var = (int)$var; if you want to make sure it's a number.

edited Apr 7, 2012 at 9:46

answered Apr 7, 2012 at 9:40

Armatus

2,20117 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Brenden Clerget Over a year ago

Updating original to show the real field name of startDate instead.

Brenden Clerget Over a year ago

It just echoes out 'array' now

Brenden Clerget Over a year ago

Updated question to have the fetch row as well.

Armatus Over a year ago

$finalcount echoes 'array'? That would be strange since DB values are never arrays.

Brenden Clerget Over a year ago

Yeah I know. I'm really confused.

|

Waynn Lue · Accepted Answer · 2012-04-07 09:45:10Z

1

You shouldn't use LIKE for date comparisons. You can just do

"SELECT COUNT(*) FROM test_table WHERE startDate = '" . $day. "'";

And as Armatus points out, you need to call mysql_fetch_row as well.

edited Apr 7, 2012 at 9:45

answered Apr 7, 2012 at 9:38

Waynn Lue

11.4k8 gold badges53 silver badges77 bronze badges

Collectives™ on Stack Overflow

PHP - MySQL - Search date, count rows that have that date

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related