Member Avatar for paradox814

is there a way to auto increment a value in a MySQL with PHP without having to lookup the value for instance:

UPDATE SomeTable SET cell=cell++ WHERE row='some_row'

  • 2 Contributors
  • 1 Reply
  • 59 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by SmoothDime
Member Avatar for SmoothDime

UPDATE table SET cell = cell + 1 WHERE id = 5;

i pretty sure that works.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.