craigtolputt Posted July 24, 2008 Share Posted July 24, 2008 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 More sharing options...
DarkWater Posted July 24, 2008 Share Posted July 24, 2008 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. Link to comment https://forums.phpfreaks.com/topic/116415-displaying-data-in-flash/#findComment-598638 Share on other sites More sharing options...
craigtolputt Posted July 24, 2008 Author Share Posted July 24, 2008 ??? 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 Link to comment https://forums.phpfreaks.com/topic/116415-displaying-data-in-flash/#findComment-598653 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.