jamesbezza

hi if anyone can help me with a solution to this i would be gratefull i have a paginator function which at the moment while testing is set to display 2 products per page so if i have 10 products ill obviously have 5 page-tabs in my navigation i have filters on the page in order to drill the data set down ie, product type, price range ...etc i seem to having an issue in saving the state of my filters to work with the paginator properley ive supplied the main paginator function pagination.php the function is called in categories.php ive attached both files categories.php (this page gets the category id thats passed from the navigation menu which you will see if you visit http://inspiredskills.com/categories.php?id=1 and displays all products related to that category so we have the category/product listing and a filters menu/form and the left hand side which does indeed drill the products down now the filters work fine with the dataset no problem but i cannot get it to work with the paginator properley basically ive had limited success . but not the complete stable solution i need i cannot pass the saved state of the filter to work in conjuction with my paginator properley if anyone can point me in the right direction of achieving this id be gratefull to look at the product listing page go here http://inspiredskills.com/categories.php?id=1 and you will see what im trying to achieve cheers James pagination.php categories.php

Hi there I am having to implement a relational database structure as part of my DB assignment for my Software development degree, with the front end being a realistic customer interface which asks potential applicants to submit their details and course selections ( a web form for potential applicants to submit details and chosen courses which is in a list of check boxes[array] ) url of webform http://cd.bromley.ac.uk/jamesb/kipm.php so when submitted the form is processed by a PHP script and then the form data input is stored in a MYSQL database, i am using 3 tables delegate, booking, course which in theory is a one to many relationship a delegate may make many bookings but a booking must be associated with a least one delegate and a booking may have many courses but a course must be associated with at least one booking etc.. I have an issue with being able to store each checked course option as a new row in MYSQL under the same DB field CourseRef my query is sending the form data to their relevant tables as listed above but i am serializing the courseRef which is being stored in the courseRef field like so a:3:{i:0;s:3:"OD1";i:1;s:3:"JA1";i:2;s:3:"C+1";} i would like each course selection to populate a new row with each selection ie booking table (primary key) bookingnum courseRef field 1 od1 1 ja1 1 c+1 Any help with this would be greatly appreciated James Berry i have attached my php script submit_entry.php

Hi there I am having to implement a relational database structure as part of my DB assignment for my Software development degree, with the front end being a realistic customer interface which asks potential applicants to submit their details and course selections ( a web form for potential applicants to submit details and chosen courses which is in a list of check boxes[array] ) url of webform http://cd.bromley.ac.uk/jamesb/kipm.php so when submitted the form is processed by a PHP script and then the form data input is stored in a MYSQL database, i am using 3 tables delegate, booking, course which in theory is a one to many relationship a delegate may make many bookings but a booking must be associated with a least one delegate and a booking may have many courses but a booking must be associated with at least one course etc.. I have an issue with being able to store each checked course option as a new row in MYSQL under the same DB field CourseRef my query is sending the form data to their relevant tables as listed above but i am serializing the courseRef which is being stored in the courseRef field like so a:3:{i:0;s:3:"OD1";i:1;s:3:"JA1";i:2;s:3:"C+1";} i would like each course selection to populate a new row with each selection ie booking table (primary key) bookingnum courseRef field 1 od1 1 ja1 1 c+1 Any help with this would be greatly appreciated James Berry i have attached my php script submit_entry.php [attachment deleted by admin]