Im sure the answer to this one is simple but I cant figure it out. This is what I have resorted to:

PHP Code:

mysql_query("UPDATE userdb SET emailupdate = '1' WHERE userID='$userID'") or die(mysql_error());
mysql_query("UPDATE userdb SET email='email' WHERE userID='$userID'") or die(mysql_error()); 


That works fine, but I want to get that all in one line so I dont have more queries then necessary. I cant get it to work. I have tried all sorts of variations , putting the AND before the WHERE and after and doubling up on different things.

Thanks

PHP Code:

mysql_query("UPDATE userdb SET emailupdate = '1',email='email' WHERE userID='$userID'") or die(mysql_error()); 


Thanks for the quick response JeremyMiller, Ill have to try the code tommorow when I am more coherent.

Do you (or anyone else) know of a good mySQL tutorial (preferably one that is designed specifically for PHP), I use w3schools and then just searching on PHP but I havent found anything that uses commas in a mySQL query.

Thanks again.

I usually recommend www.tizag.com

Also, I use http://dev.mysql.com/doc/refman/5.0/en/
Search for the type of query you want to run, like select, insert, update, etc., and you will find a page with the syntax.

Originally Posted by frost

Also, I use http://dev.mysql.com/doc/refman/5.0/en/
Search for the type of query you want to run, like select, insert, update, etc., and you will find a page with the syntax.

I'm afraid that's how I primarily learn things too: reading the syntax. Now, the ability to do that well comes from years of experience in a variety of languages -- I already know most of the concepts, just need to learn how to express the same concept in a new language. Learning the concepts, however, took a long time and a bit of formal training.

I frequently think that too many people get into programming without first taking the time to study; believing that if they just "do" then they will automatically "do well." One will do much better in the long run to take the necessary time to study a new language -- learn it's syntax; learn programming structures and design paradigms; investigate the community to see what their concerns are and how common problems are frequently overcome; ... and, it can't hurt to actually purchase an academic text used in a university you prefer (it's all listed online in their course listings). Self teaching isn't, for most, easier than formal education as a greater degree of dedication and less easy-to-access, quality assistance is available.