Adding new column to a dynamically created table in PHP which has specific query

Question

I am new to PHP and MySQL.

This a project for a travel agency. there is form to insert details of a vehicle into database including current date and time. And details can be inserted multiple times for a vehicle in a day.

Now I am dynamically creating a table in HTML to display details of vehicle from database.

Now I have to add a new column to above html table to show the count of particular vehicle inserted for current day. How to query it in sql;

what exactly is your question? and add here what you have tried so far. — Sidstar
– Sidstar, Commented Mar 17, 2014 at 7:13
Please be clear in your Question. stackoverflow.com/questions/how-to-ask — Sulthan Allaudeen
– Sulthan Allaudeen, Commented Mar 17, 2014 at 7:14
tech-recipes.com/rx/378/add-a-column-to-an-existing-mysql-table this might be what you're looking for. Try google next time :) — Bryan
– Bryan, Commented Mar 17, 2014 at 7:22
what is that table you are talking about? HTML table or DB table? — Your Common Sense
– Your Common Sense, Commented Mar 17, 2014 at 8:09
I am sorry for incomplete question. I have edited the question now — Shrinidhi Kulkarni
– Shrinidhi Kulkarni, Commented Aug 13, 2014 at 6:25

Vivek Pratap Singh · Accepted Answer · 2014-08-13 06:44:19Z

1

You could try something like this in your HTML:

<tr>
  <td>Count</td>
  <td><?php echo $count; ?></td>
</tr>

In MySql,

SELECT COUNT(vehicle_name) FROM myTable WHERE DATE(myDate) = DATE(NOW());

edited Aug 13, 2014 at 6:44

answered Aug 13, 2014 at 5:44

Vivek Pratap Singh

10.1k5 gold badges24 silver badges35 bronze badges

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

3 Comments

Adam Smith Over a year ago

Please consider adding more detail to your answer. Why does this work, what are some potential drawbacks of this approach, etc.

Shrinidhi Kulkarni Over a year ago

I am sorry for incomplete question. I have edited the question now

Shrinidhi Kulkarni Over a year ago

@Vivek Its kind of correct vivek. Your answer was helpful. Thank you.

Collectives™ on Stack Overflow

Adding new column to a dynamically created table in PHP which has specific query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related