Plazman65 Posted February 25, 2006 Share Posted February 25, 2006 Hi all, Its me again, stuck again... sort of so here is what I have done and what I want to doI used the master/detail page to create listings job/job detail.Now I want to have a member be able to add one of the details(recordset) on the detail page to their own page to watch the status (hiring versus not hiring). I created another table that has the username,idcodeThe details are being passed with the idcode of the job but I am unsure of where to go now? any suggestions? Thanks, Michelle Link to comment https://forums.phpfreaks.com/topic/3583-insert-record-into-database/ Share on other sites More sharing options...
kraftycuts Posted February 27, 2006 Share Posted February 27, 2006 [!--quoteo(post=349251:date=Feb 25 2006, 06:56 AM:name=plazman65)--][div class=\'quotetop\']QUOTE(plazman65 @ Feb 25 2006, 06:56 AM) [snapback]349251[/snapback][/div][div class=\'quotemain\'][!--quotec--]Hi all, Its me again, stuck again... sort of so here is what I have done and what I want to doI used the master/detail page to create listings job/job detail.Now I want to have a member be able to add one of the details(recordset) on the detail page to their own page to watch the status (hiring versus not hiring). I created another table that has the username,idcodeThe details are being passed with the idcode of the job but I am unsure of where to go now? any suggestions? Thanks, Michelle[/quote]I'm having a similar problem if any one can help?! :-) Thanks Link to comment https://forums.phpfreaks.com/topic/3583-insert-record-into-database/#findComment-12856 Share on other sites More sharing options...
Plazman65 Posted March 1, 2006 Author Share Posted March 1, 2006 [!--quoteo(post=350007:date=Feb 27 2006, 02:11 PM:name=kraftycuts)--][div class=\'quotetop\']QUOTE(kraftycuts @ Feb 27 2006, 02:11 PM) [snapback]350007[/snapback][/div][div class=\'quotemain\'][!--quotec--]I'm having a similar problem if any one can help?! :-) Thanks[/quote]OK let me see if I can explain what I have done to make it work still need help with one part though-Hi all, I have run into a couple of problems and I think that its because Im trying to filter a record set by saying username= session variable, MM_username. The first problem-I have two tables now-jobs-jobid,city, etcMyjobs-jobid,idcode,username, with jobid being the common columns.I wrote the query as follows here's what I did;SELECT jobs.CityName, jobs.idcode, jobs.nowhiring, mydepartments.depid, mydepartments.usernameFROM jobs, mydepartmentsWHERE jobs.idcode = mydepartments.depid and mydepartments.username = 'colname' (which is MM_username)I get nothing but when I do this just sort by the job I get all the jobs!SELECT mydepartments.depid, jobs.idcode, jobs.CityNameFROM mydepartments, jobswhere mydepartments.depid = jobs.idcode however I do need it to come up by the current username only.The second problem is the update record page I did the record set to update the record to filter username=MM_username since I only want logged in users to update their own info.If ANYONE can help I greatly appreciate it. Thanks, MichelleAnyone see what I miss? I appreciate your time. Thanks, Michelle Link to comment https://forums.phpfreaks.com/topic/3583-insert-record-into-database/#findComment-13210 Share on other sites More sharing options...
Plazman65 Posted March 2, 2006 Author Share Posted March 2, 2006 woohooo ok I got that part workingmy mistake? MM_username was what I was using should have been MM_Username, another duh'. So now what I need to do is to be able to limit the # of entry that a person puts in. Any ideas? Link to comment https://forums.phpfreaks.com/topic/3583-insert-record-into-database/#findComment-13481 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.