Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: OT - Test Database

by dga (Hermit)
on Aug 05, 2003 at 22:06 UTC ( #281195=note: print w/replies, xml ) Need Help??

in reply to OT - Test Database

You should be able to coerce any multi column text file, say one having zip codes and city state information etc. into a simple table in MySQL via the text importing function. Then you could have a simple webpage template with a TMPL_LOOP which read in the zip code or (leading) part of a zipcode and tabled out the city state pair(s) as requested.

This would excersize all the basic functions of both tools for a web retrieval driven by a database.

You would of course need to create a 3 or 4 column table to read the text into...

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://281195]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2021-06-23 17:14 GMT
Find Nodes?
    Voting Booth?
    What does the "s" stand for in "perls"? (Whence perls)

    Results (121 votes). Check out past polls.