If you have the ability to say '1234 is your leaser code', why not just
insert 1234 into the database?
Have a page where the leaser enters their name (and password, perhaps?). The
next page will learn the leaser ID, and has the form with all the other info
you need. it will have a
...
Siggy
- Original Message -
From: "olinux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 4:14 PM
Subject: [PHP-DB] autoincrementing ? and a little database structure
>
> OK,
> i have a mySQL database with 3 tables that work together.
> Leasers | Apartments | ApartmentFeatures
>
> Leasers - contains contact info for the property owners, and LeaserID as
> primary key [auto-incrementing]
>
> Apartments - contains apartment address, the corresponding LeaserID, and
> aptID [the apartment ID to match to the features], Leasers will be listing
> multiple apartments.
>
> ApartmentFeatures - contains apartment details, price, bedrooms, amenity
> info and image paths. also contains aptID.
>
> I have a couple questions concerning inserting data from the three tables.
> -What would be the best way to insert data, thru a series of forms [i.e.
> NEXT button submits data to be inserted and brings up the next form for
the
> next table NEXT button again indserts and brings a final form that calls
> final insertion script, or just on big ol form?
> -i would like the LeaserID to be an auto incrementing number. How should I
> assign this to the apartments table. For example, X Realtor enters his
> contact info and is assigned to be LeaserID 1234, what is the best method
of
> assigning LeaserID 1234 to the apartments that he enters into the
database,
> should I say "1234 is your LeaserID" and expect them to use this number to
> insert apartments?
>
> I am really confused right now, I know that there are some problems in my
> thinking so letme know if you spot these areas.
> Thanks much,
> olinux
>
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
