>Ok, so just that I am clear, you are SELECTing and pulling all the data
>that you are submitting in the above INSERT statement from the DB
>initially,
>then you are only modifying the confirm_number value and then re-
>submitting all the values, as they originally were,
Well, actually when all
update contacts set confirm_number = confirm_number + 1 order by
contact
desc limit 1
Here is the php query I've been using to send the record in the first
place
$query="INSERT INTO contacts (first_name, last_name, email, phn_number,
address, city, state, zip, dates, comments, confirm_number)
2 matches
Mail list logo
