PHP script to sort data/create pages according to fields?

[jaytee1232003@yahoo.com]

eg.

Someone fills out 3 fields. (There will be more but this is just to
give you an idea)

1. Country
2. State
3. City

I want this script to generate a web page and list the people by
information submitted.

eg. Everyone that put in USA will be listed on a page.

or

Choose California and everyone that typed in California will be listed
on a page.

I can also create links with criteria at the end. eg.
mysite/search.php?=mon tana

This script will also accept data from people. So people will visit,
type of the form and if the information is valid (not spam) then
they'll be in a database and able to be sorted.

Does that make sense?

[Alan Little]

Re: PHP script to sort data/create pages according to fields?

Carved in mystic runes upon the very living rock, the last words of of
comp.lang.php make plain:
[color=blue]
> Choose California and everyone that typed in California will be listed
> on a page.
>
> Does that make sense?[/color]

Yes. Are you at all familiar with MySQL?

--
Alan Little
Phorm PHP Form Processor

http://www.phorm.com/

[tayjee]

Re: PHP script to sort data/create pages according to fields?

I'm not familar with MySQL. I know it's on my server. I'm still a
newbie at this.

[Gary L. Burnore]

Re: PHP script to sort data/create pages according to fields?

On 18 Dec 2004 18:32:12 -0800, "tayjee" <jaytee1232003@ yahoo.com>
wrote:
[color=blue]
>I'm not familar with MySQL. I know it's on my server. I'm still a
>newbie at this.[/color]

You're obviously a newbie at USENet as well. Next time, try leaving
in just enough of what you're replying to so people know what you're
talking about. Leave in the attribute (who you're talking to) as
well.

[dawnunder@gmail.com]

Re: PHP script to sort data/create pages according to fields?

Gary L. Burnore
"You're obviously a newbie at USENet as well."
---------
No reason to be rude.

One question was asked by Allan Little. "Are you at all familiar with
MySQL?"

It's not like there were ten responses or posts to choose from . If
people want to know who I'm responding to in this message then perhaps
they can read the ONE message and the ONE question that's not mine.

[tayjee]

Re: PHP script to sort data/create pages according to fields?

Gary L. Burnore
"You're obviously a newbie at USENet as well."
---------
There's little reason to be rude or condescending.

One question was asked by Allan Little. "Are you at all familiar with
MySQL?" I replied: "I'm not familiar with MySQL."

It's not like there were ten responses or posts to choose from. If
you want to know who I'm responding to in this message then perhaps
they can read the ONE message with ONE question that's not mine and is
between my original post and my response.

[Tim Van Wassenhove]

Re: PHP script to sort data/create pages according to fields?

In article <1103425366.888 924.303010@z14g 2000cwz.googleg roups.com>, dawnunder@gmail .com wrote:
[color=blue]
> It's not like there were ten responses or posts to choose from . If
> people want to know who I'm responding to in this message then perhaps
> they can read the ONE message and the ONE question that's not mine.[/color]

Do you really think we (this group) want to spend time on that?
Anyway, the answer to everything you are asking yourself right now can
be found at: http://www.catb.org/%7Eesr/faqs/smart-questions.html


--
Met vriendelijke groeten,
Tim Van Wassenhove <http://www.timvw.info>

[Alan Little]

Re: PHP script to sort data/create pages according to fields?

Carved in mystic runes upon the very living rock, the last words of tayjee
of comp.lang.php make plain:
[color=blue]
> I'm not familar with MySQL. I know it's on my server. I'm still a
> newbie at this.[/color]

That's fine. So, there's a place to start looking. Unless you're looking
for someone to write the program for you, you should start with some
tutorials.

--
Alan Little
Phorm PHP Form Processor

http://www.phorm.com/

[Geoff Berrow]

Re: PHP script to sort data/create pages according to fields?

I noticed that Message-ID:
<1103425828.441 573.7230@z14g20 00cwz.googlegro ups.com> from tayjee
contained the following:
[color=blue]
>Gary L. Burnore
>"You're obviously a newbie at USENet as well."
>---------
>There's little reason to be rude or condescending.
>
>One question was asked by Allan Little. "Are you at all familiar with
>MySQL?" I replied: "I'm not familiar with MySQL."
>
>It's not like there were ten responses or posts to choose from. If
>you want to know who I'm responding to in this message then perhaps
>they can read the ONE message with ONE question that's not mine and is
>between my original post and my response.[/color]

'Between' makes the assumption that
1, one is using a threading newsreader
2, messages arrive in order

Garry said
"You're obviously a newbie at USENet as well." which is simply an
observation of fact.

It's blunt, but it's not rude.

In answer to your question, you must investigate ways of storing your
data (ie in a database such as MySql) and then retrieve it based on the
value of the field in question. This involves learning PHP to connect
to the database, and some SQL to query it. Unfortunately, though many
people here will be able to write such a script, this is beyond the
scope of this group and you need to look for a PHP/MySQL tutorial.

Best advice is to have a go and then come back with a specific problem.

Good luck.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[iMedia]

Re: PHP script to sort data/create pages according to fields?

You have much to learn. Start small and break each step down into
little pieces.

Your best bet is to find all your resources and get familiar with them,
such as:
PHP: http://us2.php.net/manual/en/
MySQL: http://dev.mysql.com/doc/mysql/en/index.html

You will also find great help and advice at
http://SitePoint.com/forums/. They helped me greatly when I first
began. (No, I am not affiliated with them, just a fan).

Good Luck.