> 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 Frazer <[EMAIL PROTECTED]> wrote:

> 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 VALUES ('value1', 'value2', NULL, 'value3');
> INSERT INTO table VALUES ('value1', 'value2', , 'value3');
> 
> NOTE: I didn't read the entire post below...it's too early in the morning to
> think about code.  I'm off to populate some site content until my brain
> catches up with the clock.
> 
> Mike Frazer
> 
> 
> 
> 
> "Russ Michell" <[EMAIL PROTECTED]> wrote in message
> news:SIMEON.10110231044.D@k1c. anglia.ac.uk...
> > 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,strategies,rules,news,information,policies) VALUES(";
> > //loop while categories have been ticked
> > for($i=0;$i<count($category);$i++) {
> > if($category[$names] == 'yes') {
> > $sql .= "'$email',";
> > }
> > else {
> > $sql .= "NULL,";
> > }
> > }
> > //Remove the last comma
> > $sql = substr($sql,0,-1).")";
> > //$query = mysql_query($sql,$connect) or die(mysql_error());
> > echo $sql;
> > }
> >
> > I believe the problem to be this line:
> > 'if($category[$names] == 'yes') {' //Use this and NULL values aren't
> inserted
> >
> > 'if($HTTP_POST_VARS["category${$i}"] == 'yes') {' //Use this and ONLY NULL
> values are inserted
> >
> > The values are taken from the checkboxes thus:
> >
> > //Get all table column names, dynamically display them and use to process
> subscriptions:
> > $fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
> > $columns = mysql_num_fields($fields);
> > for ($i=0; $i<$columns; $i++) {
> > $names = mysql_field_name($fields, $i) . "\n";
> > $catselect .= "<b>$names </b><input type=\"checkbox\"
> name=\"category[$names]\" value=\"yes\"><br>\n";
> > }
> >
> > You can see it happening at:
> > http://gertrude.anglia.ac.uk/intranet/myanet/index.php
> >
> > Many thanks.
> > Russ
> >
> >
> >
> >
> > On Mon, 22 Oct 2001 12:28:38 -0500 Rick Emery <[EMAIL PROTECTED]> wrote:
> >
> > > Construct your INSERT a piece at a time.  Something like:
> > >
> > > $sql = "INSERT INTO $myanet02
> > > (staffdev,strategies,rules,news,information,policies) VALUES(";
> > >
> > > for($i=0;$i<count($category);$i++) {
> > > if($HTTP_POST_VARS["category{$i}"] == 'yes') {
> > > $sql .= "\'$email\',";
> > > }
> > > else {
> > > $sql .= "NULL,";
> > > }
> > > }
> > > $sql = substring($sql,0,-1).")";
> > > //$query = mysql_query($sql,$connect) or die(mysql_error());
> > > echo $sql;
> > >
> > > -----Original Message-----
> > > From: Russ Michell [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 22, 2001 11:23 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP-DB] looped insert
> > >
> > >
> > > Hi everyone:
> > >
> > > I've been fiddling with this all day, and well - if it was working you
> > > wouldn't be reading this right now! ;-)
> > > My script should take the selections made by users and process them via
> > > straightforward MySQL inserts:
> > >
> > > //Get all table column names, dynamically display them as checkboxes.
> Use to
> > > process subscriptions:
> > > $fields = mysql_list_fields("$dbName", "myanet_categories", $connect);
> > > $columns = mysql_num_fields($fields);
> > > for ($i=0; $i<$columns; $i++) {
> > > $names = mysql_field_name($fields, $i) . "\n";
> > > $catselect .= "<b>$names </b><input type=\"checkbox\"
> > > name=\"category[$names]\" value=\"yes\"><br>\n";
> > > }
> > >
> > >
> > > //If submit button selected, process those ticked checkbox categories:
> > > if(isset($submit)) {
> > > //loop while categories have been ticked
> > > for($i=0;$i<count($category);$i++) {
> > > if($HTTP_POST_VARS["category{$i}"] == 'yes') { //Not sure
> > > about this bit...
> > > $sql = "INSERT INTO $myanet02
> > > (staffdev,strategies,rules,news,information,policies)
> > > VALUES('$email','$email','$email','$email','$email','$email')";
> > > //$query = mysql_query($sql,$connect) or
> > > die(mysql_error());
> > > echo $sql;
> > > }
> > > }
> > > }
> > >
> > > At the moment not even echoing my $sql works. I know this aint gonna
> work as
> > > it is, because what I really need to know is:
> > >
> > > * How do I insert into only those categories that have been checked?
> > > (default is 'null' in a VARCHAR(50) field)
> > > * How do I only declare '$email' a single time as this is the only value
> > > being inserted?
> > >
> > > Many thanks:
> > > Russ
> > >
> > > #-------------------------------------------------------#
> > >
> > >   "Believe nothing - consider everything"
> > >
> > >   Russ Michell
> > >   Anglia Polytechnic University Webteam
> > >   Room 1C 'The Eastings' East Road, Cambridge
> > >
> > >   e: [EMAIL PROTECTED]
> > >   w: www.apu.ac.uk/webteam
> > >
> > >   www.theruss.com
> > >
> > > #-------------------------------------------------------#
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> >
> > #-------------------------------------------------------#
> >
> >   "Believe nothing - consider everything"
> >
> >   Russ Michell
> >   Anglia Polytechnic University Webteam
> >   Room 1C 'The Eastings' East Road, Cambridge
> >
> >   e: [EMAIL PROTECTED]
> >   w: www.apu.ac.uk/webteam
> >
> >   www.theruss.com
> >
> > #-------------------------------------------------------#
> >
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 

#-------------------------------------------------------#
                                
  "Believe nothing - consider everything"       
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com
                        
#-------------------------------------------------------#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to