Popgun

Will you be Inserting the records also? If No then: You need to: 1 Create a recordset that pulls artist info by a unique ID 2. Create a page with identifiable fields, make it a repeating region, add a navigation (e.g. <<Last Record|<Next Record|Next Record>|Last Record>>) 3. Create a link next to each record that something like: "View Detail" that holds the unique ID (passed via URL) to an artist detail page. If YES (meaning you need to create a content management mechanism) then: You should have 1 Insert Page 1 View Page (repeat region with links to the Edit/Delete page) 1 Edit Page (aka Update) 1 Delete page 1 End User View page (see above) The good news is you can recycle the view page and turn it into the End User view page quite easily, and you can use the Insert page as the Edit page by removing the Insert SQL and replacing it with Update SQL. These are the basics hope it helps.

Yeah I was wanting to put a hard cap of records (containing users) of 100 by account type. I guess its best done programmatically

Cant seem to find any information on how to Limit ( e.g or put a hard cap) the number of records that can be inserted into a table. Any ideas or reference for this?

Neil, Thanks that will definitely get me started! This forum and community so kicks ass still. One of the best out there.

Neil, First I would like to say THANK YOU. I think this is exactly how I need to implement this. Great insight! A few questions: 1. Can you give me an simple example of what (PHP calls/commands) this would look like, I can probably figure it out from there: a) boolean value from the session statement b) boolean test on the script file name/url to restrict access c) DB query function I'd use in conjunction with a SESSION variable to pull module status rather than use an array? Also do you think this could all be kept in 1 include file?

Hi All!, Its been awhile since I've lurked here but this forum has always been very helpful and I am kind of stuck. Background: I have been working on a health care related project for about a year, and I am nearing completion, but I need some ideas on how to implement access/restriction based on the following parameters: 1 User Auth/Access is already in place via session handling, and role based access restricting users to pages based on their role. 2. The site functionality is built modular (9 total) 3. Clients consist of the following: Parent Company (parent_ID) Subsidiary Company (sub_ID) 4. Subsidiary Company will be subscribing to a mod. based on need for that particular functionality. 5. Role based users will belong to a Subsidiary Company (user_ID) So the parameters are: Parent: N/A in this scenario Subsidiary: will have subscribed to access 1-9 mods. Users: will have access to 1-9 mods based on belonging to a particular subsidiary Module: will either be "on" or "off" My Mysql Table structure has the; 1. Parent Co. Table (associates parent to subsidiary) 2. Subsidiary Table (associates subsidiary to user) 3. User Table (associates user to various other tables related to modules) 4. Module Table (used to apply granular "on"/"off" control to modules based on Sub_ID) So Ive thought of a few options as follows: 1. Implement a solution based on Sessions/Roles that determines if the module is "on"/"off" for that subsidiary (and therefore the end user), this seems a little less secure and Im trying to get my head around how to do it. 2. Restrict access to each module based in an Include file on page load. 3. Restrict access on the server side?? (this would be my least favorite alternative). As if this wasn't enough I need to make sure whatever solution I use allows me to either a) control the individual subsidiary mod. access via a web interface or b) via a file I can edit on the fly. as I might have to deploy multiple instances of subsidiary companies rapidly. Well I hope this was clear enough and gave you enough to chew on, I am TOTALLY open to suggestions, or ideas on how to go about this. Thanks for reading my puzzle PS: My friend told me 6 months ago to build this in Drupal, he may may have been right

Artacus! You are right I just reviewed my database, my users table has circular references (lots of them)! I'm going to have to review and drop them I believe.

Hi all, I'm having an issue with a parent table not setting the foreign key column after an inset to the child table (which is setting the PK and FK correctly) I'm not sure if the issue is in my record set or the INSERT and am wondering if someone could take a peek. I'm not sure why the FK on the parent table would not set on an insert. Code below, table structure is as follows: Tables are both InnoDB USER TABLE (parent) user_ID medint( Not Null/Auto Increment/unsigned (PK) disclaimer_ID medint( Null (FK) (default setting for update/delete) DISCLAIMER TABLE (child) disclaimer_ID medint( Not Null/Auto Increment/unsigned (PK) user_ID medint( Null (FK) (Set to On Update = Cascade) Ive tried: Setting the USER table Fk to (disclaimer_ID) Not Null but that creates an error on registration of users. Not sure what the issue is, I have a feeling it might be that I somehow need to specify the disclaimer_ID on the USERS table during INSERT, but that means inserting to more than 1 table I think As always thanks in advance

Hi all, I am developing a website that has the user run through multiple pages with forms that need to be submitted by the user, that results in a personalized end product. I cant seem to get the forms to Update the database. Is there a tutorial for updating records using DW CS3 using sessions, where the runtime variable is set to the session variable (as the filter) to identify the unique record (which is the process I'm using but it's not working) to execute the update. The only stuff I can find in the books I have uses a unique value passed through a URL to the page with the form, then uses that value in a hidden field on the form to identify the correct record. Any input is appriciated, even non DW CS3 tutorials that use sessions for the form update. Thanks

I'm probably being ignorant here but if they are all on one form, and I need to assign a foreign key dont i need a multi-table recordset query using a join?

I guess the simpilest explaination is I'm trying to assign a location ID from the location table to a user_ID from the user table. I need to be able to identify the users location so I can match them to a nearby service provider. The table structure is such: LOCATION location_ID zip city stateabbreviation latitude longitude USERS user_ID location_ID state (1 of 15 specific states, also abbreviated, as I only have service providers in 15 states at the moment) So I'm using CONCAT to form an alias on state, so I can pull ONLY the ZIP codes and Cities from those 15 states rather than the entire LOCATION table I'm not sure if there is a better way to do this, I made some headway last night using applying DISTINCT and a LEFT JOIN, but it needs to be refined a bit.

fenway, Thanks man I had the order wrong I guess you learn something new everyday right? (hopefully!!) Now I have to figure out how to limit the results based on the alias state to pull the zip code and cities associated with that state for population in the form O.o

sorry if I was unclear, what Im trying to do is combine the state col from one table (users) with the state col from another table (location) into an alias named state

Hi All Im trying to construct a recordset that combines the State col from a users table with the state col from a location table, as an alias so that I can dynamically pull the users Zip code and City from the location table for location_ID (assignment) and update in a form. I cant seem to get the CONCAT part of the SQL to work: This works: SELECT * FROM USERS, LOCATION WHERE user_ID = colname AND USERS.`state` = LOCATION.stateabbreviation This does not: SELECT * FROM USERS, LOCATION WHERE user_ID = colname AND USERS.`state` = LOCATION.stateabbreviation CONCAT(USERS.`state`, LOCATION.stateabbreviation) AS state Neither does this: SELECT * FROM USERS, LOCATION WHERE user_ID = colname AND USERS.`state` = LOCATION.stateabbreviation SELECT CONCAT('state', 'stateabbreviation') AS state Getting a syntax error near CONCAT Any help is greatly appriciated, new to MySQL

Hey all I have a design/solution dilemma I'm hoping someone may have encountered this before and or might point me in the right direction or give me advice on how to set this up. THE SET UP My global structure is: Members Table Location Table Service Table Appointments Table InnoDB Engine I am using MySql 5.0.45 PhP 5 Issue: The design of the site allows users to input their information, (members table) then search for a service provider near them, and set up an the next available appointment (appointment table) with a service provider (who also is a member of site via the services table). Obviously all of these have the appropriate primary and foreign key relationships mapped but for purposes of clarity, structure is like this: MEMBERS member_ID (Primary Key) location_id (F Key) LOCATION location_ID (Primary Key) SERVICE service_ID (Primary Key) location_id (F Key) APPOINTMENT appointment_ID (Primary Key) member_id (F Key) service_id (F Key) There are other tables keyed but this is the basic structure. Location table includes these columns: City, State, Zip, Lat, Long. Members Table also includes a column for: State (this isn't a normalization flaw its for design reasons) ISSUE: Functionality: User must be able to conduct a search in a radius of 5, 10, 20, 50 miles of their location Result should be displayed using a map (Is Google Maps API best for this?) Query should also result in a list of Service providers with next available appointment that the member can then select. (this forwards them to the appointment setting function/form) So far I mapped this using pseudo code: SELECT MEMBERS WHERE member_ID AND location_id AND state = user AND THEN SELECT SERVICE WHERE service_ID AND location_id = service providers (multiple) IF within specified radius display Else Exclude AND display next available service provider appointment AND allow user to select appointment So I could use some advice, on how to get this done with SQL and PHP. This is a major feature of my site so I want to make sure I get it right. Any advice would be appreciated