Make PHP Script count MySQL results?

Question

I have a webpage that is listing the results of each given day of a month using the following code.

  $day_events = "SELECT * FROM tbl_events WHERE day='".$day_id."'";
  $events_result = mysql_query($day_events);
  while($event_row=mysql_fetch_array($events_result)) {
  $calendar.= "<span>".$event_row['event']."</span>";
  }

How can I edit this to list the number of events that are found in the...

SELECT * FROM tbl_events WHERE day='".$day_id."'

...query?

"How can I edit this to list the number of events" - instead of the current output or in addition to? — VolkerK
– VolkerK, Commented Aug 21, 2011 at 16:48

RiaD · Accepted Answer · 2011-08-21 16:46:52Z

2

$day_events = "SELECT COUNT(*) FROM tbl_events WHERE day='".$day_id."'";
print mysql_result(mysql_query($day_events),0)

answered Aug 21, 2011 at 16:46

RiaD

47.8k12 gold badges85 silver badges128 bronze badges

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

Comments

Nicola Cossu · Accepted Answer · 2011-08-21 16:46:49Z

2

SELECT count(*) FROM tbl_events WHERE day ...

BTW you could simply use mysql_num_rows() from your previous query.

answered Aug 21, 2011 at 16:46

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

Comments

genesis · Accepted Answer · 2011-08-21 16:47:10Z

1

echo mysql_num_rows($evenets_result);

Looking for this?

answered Aug 21, 2011 at 16:47

genesis

51.1k20 gold badges99 silver badges127 bronze badges

Comments

yoda · Accepted Answer · 2011-08-21 16:48:22Z

0

$events_count = mysql_num_rows(mysql_query($day_events));

answered Aug 21, 2011 at 16:48

yoda

11k19 gold badges68 silver badges94 bronze badges

Collectives™ on Stack Overflow

Make PHP Script count MySQL results?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related