Taylor,
You seem to be confusing your user interface with your database. You can
use a variety of techniques to get data from a user via a web page. The
exact methods available to you are dependent on your platform (the web
server and its operating system) and your processing language( ASP, PHP,
Perl, Python, CGI script, etc.). It has nothing to do with forming a proper
SQL statement to get your data into or out of the database.
To add records to the database use the INSERT statement. To change records
use the UPDATE statement. And to get data from the database you use the
SELECT statement. It's a left hand/right hand issue: the website/user
interface is on one side, the database on the other with your code in the
middle communicating between the two.
I highly recommend you look for online tutorials for your particular web
scripting language as they are sure to provide examples of retrieving data
from your sites visitors.
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Taylor Lewick"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
m> cc: <[EMAIL PROTECTED]>
Fax to:
05/18/2004 08:51 Subject: lookup tables, populating
automatically
PM
I asked a question earlier about how to handle lookup tables, I think this
is a little more clear as to what I was trying to ask.
if I want to relate a contact to an organization, I know I can create a
table that contains contact_ids and org_ids.
But, how do I enter that information gracefully, i.e. from a webpage?
Assuming someone has already entered a persons contact info, and I have
info
for several organizations
how would I go about assigning a contact to that organization? It isn't
feasible for someone to remember all of the ids for
each business and each contact.
I could create a webpage that is used to assign contacts. Would I want to
query each table and present two pull down boxes one with contact names and
one with organization names, and they would make thier selection and hit
enter...
In the background i.e. perl or php, once they hit submit I would then enter
the org_id and contact_id for each selection into the relation table?
IF this is correct, can someone share some code examples (perl preferably)
on how this could be accomplished?
Thanks,
Taylor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
