Php report from mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Locked
nackgr
Forum Newbie
Posts: 11
Joined: Mon Feb 21, 2011 3:22 am

Php report from mysql

Post 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
crazycoders
Forum Contributor
Posts: 260
Joined: Tue Oct 28, 2008 7:48 am
Location: Montreal, Qc, Canada

Re: Php report from mysql

Post 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?
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: Php report from mysql

Post 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 :)
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
nackgr
Forum Newbie
Posts: 11
Joined: Mon Feb 21, 2011 3:22 am

Re: Php report from mysql

Post 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
Attachments
3.zip
(16.02 KiB) Downloaded 16 times
crazycoders
Forum Contributor
Posts: 260
Joined: Tue Oct 28, 2008 7:48 am
Location: Montreal, Qc, Canada

Re: Php report from mysql

Post 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.
nackgr
Forum Newbie
Posts: 11
Joined: Mon Feb 21, 2011 3:22 am

Re: Php report from mysql

Post by nackgr »

then point me a direction to start reading
User avatar
social_experiment
DevNet Master
Posts: 2793
Joined: Sun Feb 15, 2009 11:08 am
Location: .za

Re: Php report from mysql

Post 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.
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Locked