I code all my apps to look for an empty variable and dump and empty set into it. That way when I code the rest of the information into the database, the files are cleaner and I don't have to worry about users and bad sets. $var = ''; Robert ----- Original Message ----- From: Stewart Priest <smiley@xxxxxxxxxxxxxxxxx> Date: Wednesday, November 9, 2005 2:43 pm Subject: Re: Unable to send variables to MySQL table > <snip> > print $add_to_db; > </snip> > > Thanks for all your replies! I didn't expect to get one so quick, > so thanks! > > After I did the above, I pasted the output into MySQL. Guess what? > It didn't > work! > > I was only sending values for $item1_desc and $item1_cost. Because > I was not > sending values for the other columns, I was getting an error > message saying > the data was truncated for the empty variables. > > Now I need to figure out how to send empty values... would NULL do > the job? > > Thanks again! > Stewart > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
