SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Member snuffles117's Avatar
    Join Date
    Jun 2007
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation Please help me with my array textbox...

    Guys please help me with this one... It's giving me a headache already...

    The script is about editing requirements. We have leads and leads have one or more requirements. I have a script that is supposedly can edit the requirement. The user must be able to add the quantity of the existing requirement and the user can also add a new requirement.

    here's a bit of script from the form:

    PHP Code:
    <?
            $h_id    
    =    0;
            
    $get_hardware    =    mysql_query("select * from tbl_products where category='hardware'");
        
    ?>
        <table border="0" cellspacing="0" cellpadding="0">
            <?
                
                
    while($hardware mysql_fetch_array($get_hardware)){
                    
    $prod_id    =    $hardware["id"];
                    
    $prod    =    $hardware["name"];
                    
                    
    $hwreq    =    mysql_query("select requirement, qty from tbl_requirements where id='$id' and requirement='$prod_id'");
                    
    $hr=mysql_fetch_row($hwreq);
                
                    if(
    $prod_id==$hr["0"]){
                    echo
    "<tr>
                            <th align=\"left\" width=\"60%\"><input name=\"hreq[]\" type=\"checkbox\" value=\"
    $prod_id\" checked />".$prod."&nbsp;</th>
                            <td><input type=\"text\" name=\"hw[]\" id=\"
    $h_id\" size=\"6\" value=\"".$hr["1"]."\" OnChange=\"checMySwBox(this.id)\"></td>
                    </tr>"
    ;
                    
    $h_id++;
                    }
                    else{
            
                        echo
    "<tr>
                                <th align=\"left\" width=\"60%\"><input name=\"hreq[]\" type=\"checkbox\" value=\"
    $prod_id\" />".$prod."&nbsp;</th>
                                <td><input type=\"text\" name=\"hw[]\" id=\"
    $h_id\" size=\"6\" OnChange=\"checMySwBox(this.id)\"></td>
                        </tr>"
    ;
                        
    $h_id++;
                    }
                        
                    
                }
            
    ?>
        </table>
    And then here's the script that processes the one above:

    PHP Code:
    $hw            =    $_REQUEST['hw'];
    $hreq            =    $_REQUEST['hreq'];

    if(
    count($hreq)>0){

                                       for(
    $i=0$i<count($hreq); $i++){
                        
    $addhreq    =    mysql_query("insert into tbl_requirements values('$id','".$hreq[$i]."','".$hw[$i]."')");
                        echo 
    "count=".count($hreq)." prod-".$hreq[$i]." qty=".$hw[$i];
                    }
                    
                } 
    Basically, before the if statement, I have a query that deletes the previous requirements of the lead. So the idea is to delete the old requirements, and then add the new ones.

    The problem now is that everytime I run the script, the arrayed textboxes is not working, I mean they all return 0, i don't know what's the problem... can anyone help me please???!!

    Thanks in advance!

  2. #2
    SitePoint Member snuffles117's Avatar
    Join Date
    Jun 2007
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i already fixed it...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •