Search the Community
Showing results for tags 'php mysql array'.
Found 1 result
-
Ok. Basically this is what I'm doing. From MySQL I am generating a series of events through an array. My client wants to be able to change the order of events. Currently I am using a variable of $pid (it's the auto incrementing ID from mysql). So I created a row I called displayorder. Then in my array display on the page to reorder I am simply giving them the title of the event then the displayorder in a text box in a form. My thinking was just change the number of the display order and hit submit. My problem though is since this is coming from an array, my variable $pid I can't use to update mysql. So I need some logic thinking here. My thinking is to create a new variable for each item in the array that uses both the ID ($pid) and the display order variables together. Creating a unique ID for each. Or I could simply update the entire database row of displayorder though as this grows it seems like a bad idea. If seeing the code would help I'll post it but I figure you guys know about arrays and how to display from num counts etc. My problem is the variable $pid is not unique once I update. And since they will be doing this I can't say where $pid = 13 or whatever. Any thoughts on some logic help here for me?
