Subject: troubleshooting a PHP application
From: Mike Barsalou (mbarsalou@aidea.org)
Date: Thu Oct 10 2002 - 11:13:51 AKDT
I am testing a PHP application that was created by the open source community
called IRM. In one of the pages it has a dropdown box of information..it is
numbers 1 through 300.
I loaded the entire database using the PHPmyAdmin import tool.
When I display the form that contains this dropdown box...it only shows the
topmost entry (number 1) even though the data in the database has a
different number.
My question is: How do I go about trying to figure out why it is doing
that?
Here is what I already know:
The table that stores the dropdown box info is one field long and it is a
varchar(200). Let's call this table1
The field in the table that uses this dropdown box to fill in the data is
char(200). Let's call this table2
If I use the dropdown box in the form to change the data to the correct
number, then everything is A OK after that.
Any record from table2 that hasn't been directly selected from the dropdown
box shows the number 1, even though the actual table has the correct number
in it.
We are using MySQL 3.23.41
Anyone have ideas on how I can figure this out? Need more info?
Mike
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Thu Oct 10 2002 - 11:15:39 AKDT