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 Mik

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-23 Thread Russ Michell
Gottit at last!: //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 while(list($key,$val) = each($category)) {

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 whi

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 (staffdev,strategie