FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Reset Auto Increment to lower value
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Reset Auto Increment to lower value [message #180132 is a reply to message #180127] Fri, 11 January 2013 10:05 Go to previous messageGo to previous message
Captain Paralytic is currently offline  Captain Paralytic
Messages: 204
Registered: September 2010
Karma:
Senior Member
On Jan 10, 5:55 pm, makam...@gmail.com wrote:
> I need to create a tiles table that has a structure like this forhttp://www.myownmealplanner.com:
>
> user_id sub_tile_id
> 1       1
> 1       2
> 1       3
> 2       1
> 2       2
> 2       3
> 3       1
> 3       2
> 3       3
> etc.
> I can't just create new tables for new users because I'm using cakephp and that would require new models, views, and controllers for every new table.. How do I get the sub_tile_id to auto_increment starting at every new user id? According to the manual I can't restart auto-increment with a lower value than it has already displayed so this needs to be done with php somehow..

If you are uaing MySQL then this is the default behaviour:
http://stackoverflow.com/questions/3804845/auto-increment-usage-in-composit e-key
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: php unit testing - how to find the right person
Next Topic: Anyone have experience with any php debuggers?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 04:02:00 GMT 2024

Total time taken to generate the page: 0.03988 seconds