Jump to content

displaying data in flash


craigtolputt

Recommended Posts

Hi Guys,

 

I am struggling my way through a flash website where i have a registration form so that users can register to access a secure area....

 

then once in there they can register a product by id number on the can.

 

So i have a table in my Database called users which stores all the users details and i have these fields in that table....

 

id(auto_increment)

username

password

firstname

lastname

email

phone

address

city

county

postcode

 

then i have a table called prodreg which stores each product id code they register.  In flash i have forced their username to be added to this table also so in this table i have the following fields....

 

id (auto_increment)

username

prodid

company

firstname

lastname

email

phone

address

city

county

postcode

product

location

 

So my question is can i load into and display in flash all of the details out of the prodreg table but i need it to only display the details for the user that is logged in at the time....

 

is this possible?

 

cheers

 

Craig

Link to comment
https://forums.phpfreaks.com/topic/116415-displaying-data-in-flash/
Share on other sites

You did that horribly wrong.  You want one table with:

id(auto_increment)

username

password

firstname

lastname

email

phone

address

city

county

postcode

 

And another with:

user_id

product_id

 

Then maybe another table that contains product information based on ID.  Then it's just a simple join to get the information.

???

I know its just that im new to all this and i bought the flash/php registration form from flashden.net for my site and im trying to mix and match that code to get what i need....

 

So basically when they login they then get a form to register the product and all i want to do is link the details to that user....

 

the details i need them to add are basically for installation location so for example

 

they will enter the

canister number of the product they have installed

company name where they installed it

first name of the contact at that company

last name of the contact at that company

email address of the contact at that company

telephone number of the contact at that company

address of that company

city of that company

county of that company

postcode of that company

the product type that they installed

and the location within the building where they installed it

 

Now each user will add more than one product as they install them and i need to be able to only display the ones added by them when their logged in.

 

do you reckon you could help me out?

 

cheers

 

Craig

;D

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.