Re: mySQL query question

Jim Lucas wrote: > Michael S. Dunsavage wrote: >> On Fri, 2008-11-14 at 13:31 -0800, Jim Lucas wrote: >>>> '{$Comments}', >>>> @confirm_number >>>> ) >>> The above should be this instead >>> >>> @confirm_number >>> ); >> Even after fixing that, nothing gets inserted into the database. I've >> been all over the variables and column names and the naming is correct. > > Take the @ off the mysql_query() and also check into mysql_error() function. > also, try it with a striped down version of the insert, just inserting the confirm_number INSERT INTO contacts (confirm_number) VALUES (@confirm_number); and see if that creates a new record. -- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare