Mysql select query

[udaybabu]

Hi,

I need a query using tables.

Here i have some tables in my database table names like

test_20140405
test_20140406
test_20140407
test_20140408

in these tables same fields like feeprefix, feetime etc...

now here i am using php code..

from date: textbox with name of fromval
to date: textbox with name of toval
submit button

here my question is i slected to dates fromval is 20140405 and toval is 20140407, based on these values i need to get feeprefix, feetime from the test_values between fromval and toval?

help me out..

[traq]

here my question is i slected to dates fromval is 20140405 and toval is 20140407, based on these values i need to get feeprefix, feetime from the test_values between fromval and toval?

That's not exactly a question…?

What code have you tried? What problem did you encounter — what happened, compared to what you expected to happen?

It will likely be necessary to share your database schema as well (e.g., the result from show create table `your-table-name-goes-here`). If you question has anything to do with your PHP and/or HTML, you will need to share that code also.

Your question is unclear.
Please provide more information, and be as specific as possible.

• What do you want to accomplish?
• What have you already tried?
• What problems did you encounter?

Please be sure that you have included all relevant code and/or a link to the page in question.

[udaybabu]

Hi,

Thanks for your reply..

I am not that much experienced person to explain but i will exp my point clearly.

I have a mysql db tables like

test_20140405(Date)
test_20140406(Date)
test_20140407(Date)
test_20140408(Date)

In these tables we have a common fields like feeprefix, feetime.

db part is over.. now from UI part.. i have a form with 2 fields like from date and to date and submit button.

now i selected from date and to date like 2014-04-05 and 2014-04-07 respectively and enter the submit button..

now my prob is take these input fileds and prepare a query to get feeprefix, feetime from the db tables.

here the date range is 2014-04-05 to 2014-04-07 so now we have db tables with dates..test_20140405 to test__20140408

according to give dates we have 3 db tables so we get feeprefix, feetime from these 3 tables..


I hope u got my point..

[traq]

You must provide relevant code if you expect to get help. Making us guess will not help solve your problem.

In general terms, the date needs to be a field in the table, not its own table. It should also be a DATETIME field, and contain only the date (other info, like "test__" (if that is even needed), should be stored in other fields). This will allow you to search for records between given dates by using the BETWEEN operator.

I am not that much experienced person to explain but i will exp my point clearly.

That's just fine- that's not a problem. I explained (above) how to find the info we need.

Again, if you want a more specific answer, show your database schema and the code you are using. You should, of course, obfuscate any private/sensitive information.