I'd like to set a value + 1, and then select it using MySql. Anyone happen to know how, I've only found implementations that are a lot heavier than what I need.
Uh, if you put the select query right after the update query, then yes. They will be two different calls to mysql though, as like that page says, you can't update and select in the same query.
If you're asking if it will be updated yet when selecting it, yes it will be updated.
You are not guaranteed to have one occur right after the other. Another connection may query the data in between your two queries.
The only way around this is to use a database engine with proper transaction support (like MySQL InnoDB, or PostgreSQL) and set the transaction isolation level to READ COMMITTED or higher. Then enclose your two queries within a single transaction.
You could make the first table auto_increment, and the second table normal (no increment).
Insert into the first table, use mysql_insert_id() to get the ID number that was inserted, then manually insert into the second table using the ID number you got back.
That would work for a single channel of rows. As for multiple...you need a DBMS that allows you to define a custom sequence, or has triggers of some sort.
I'm on a page about incorrect corrections, and spent the better part of like two hours trying to get someone to understand that -5^2 = -25, not 25, and then that post had comments get reposted because that group is self sustaining, and that person was in turn trying to explain what I just explained to them. And I'm taking that as a victory
I will be AFK for a couple of days you guys hold down the fort while I am gone. I will be checking in on my phone but that will severly limit me. Be back saturday!