Re: RE: [PHP-DB] looped insert

2001-10-24 Thread Mike Frazer
Just thought this would be helpful... I've found the occassional problem with trying to insert a script-generated null value (rare but it does happen). If this becomes a problem, remember that NULL is just another word for nothing. MySQL will accept either of the following: INSERT INTO table

Re: RE: [PHP-DB] looped insert

2001-10-24 Thread Russ Michell
NOTE: I didn't read the entire post below...it's too early in the morning to think about code. haha I did that the other day when I tried (and failed) to help out someone else - damn tired, hadn't even had a whiff of beer... Cheers for your help! Russ On Wed, 24 Oct 2001 09:10:59 -0400 Mike

Re: RE: [PHP-DB] looped insert

2001-10-23 Thread Russ Michell
Hi Rick: Cheers for the info. Thwe following code almost does it, however, the NULL value isn't inserted, if checkboxes are != to 'yes': //If submit button selected, process those ticked checkbox categories: if(isset($submit)) { //Start off sql $sql = INSERT INTO $myanet02

Re: RE: [PHP-DB] looped insert

2001-10-23 Thread Russ Michell
Hi all + Rick: Since the last email I have got even closer, here is the code: //If submit button selected, process those ticked checkbox categories: if(isset($submit)) { //Start off sql $sql = INSERT INTO $myanet02 (; //loop while categories have been ticked