Page 1 of 1

Php report from mysql

Posted: Mon Feb 21, 2011 3:24 am
by nackgr
Hallo all

I have 4 csv i will go crazy i cant do it manualy any more

each csv have 4 colums

prefix| country | price 1 | price 2

The idea is to have 4 mysql tables for the 4 csv that i will have import them

and have a php script that when i will search for a prefix or country give me the results from the 4 tables


something like


table 1
prefix| country | price 1 | price 2

table 2
prefix| country | price 1 | price 2

table 3
prefix| country | price 1 | price 2

table 4
prefix| country | price 1 | price 2

Can anyone help me , i am desperate

Re: Php report from mysql

Posted: Mon Feb 21, 2011 3:43 pm
by crazycoders
And what is your problem?
You want us to do the work or do you have any specific question that we could answer?

Re: Php report from mysql

Posted: Mon Feb 21, 2011 4:00 pm
by social_experiment
@nackgr : Do you have any code that you created? It's easier to help you if we have a jump off point :)

Re: Php report from mysql

Posted: Tue Feb 22, 2011 1:26 am
by nackgr
I attach a php script that created with a php wizard id nack pass nack

its very good i see 1 table i can search it .. maybe for u it is easy to add all tables and be able to search them if someone have the time and the mood to help me i will appreciate it

Re: Php report from mysql

Posted: Tue Feb 22, 2011 6:57 am
by crazycoders
Thats not a scripts, thats a whole application. The point is not for us to get the work done for you. You need to understand the basics and you need to learn how to ask questions. Get a good tutorial done first of all, then ask away questions when trying to alter the application.

If you want and application done, post a requirement on a job requirement app, there are tons and many developpers will do that for you easily at a very small rate.

Re: Php report from mysql

Posted: Tue Feb 22, 2011 7:04 am
by nackgr
then point me a direction to start reading

Re: Php report from mysql

Posted: Tue Feb 22, 2011 11:16 am
by social_experiment
Are all the data in these 4 csv files the same? Not similar records but similar in nature, it looks that way from the intended tables you want.