Filtering Empty Array

[bananahead]

Hello,

Im a noob when it comes to php, and Im trying to figure out how to work out a code that will allow me to filter out an array.

Basically, I have a system to assign offers to my clients and I have a page that is used to assign offers. Once all offers are assigned to a client, I dont want the form to be displayed anymore, but i cant get it work. here is the code:

[PHP]$html .= "<div style='background-image:url(images/gradientdiv.gif); height:26px;'>$row[firstname] $row[lastname](<a href=\"javascript:showDiv('div$member_id');\" style='color:blue;'>Assign Offers</a>)</div> <div id='div$member_id' style='display:none; background-color:#FFFFD9;'>"; $sql_select_offers = "select o.offer_id, o.offer_name from offers o where not exists (select * from members_offers inner join offers on members_offers.offer_id = offers.offer_id where members_offers.member_id = $member_id and o.offer_id = offers.offer_id)"; $result_set_offers = mysql_query($sql_select_offers); $html .= '<form action="assign_offers.php">Check to Assign:<br />'; $html .= "<input type='hidden' name='member_id' value='$member_id' />"; while($row = mysql_fetch_array($result_set_offers)) { $html .= "<input type='checkbox' name='$row[offer_id]' value='$row[offer_id]' />$row[offer_name]<br />"; } $html .= "<input type='submit' value='Save' /></form></div>"; }[/PHP]


The code works fine, but it retrieves all users from the DB, and even those that have all offers already assigned to them, so basically I end up having a <div> tag with only "check to assign" and the save button in it. How can I hide those records that have offers all assigned already?

Thanks a bunch!!!

[dlite922]

Your code is not clean.

But let me understand what you're trying to do first.

You display a page with check boxes.

User checks whatever checkbox they like.

You store that in the database.

Then the user should be directed to another page?


Am I warm?


Let us know,


Dan

[bananahead]

Sorry for the code, I pasted and tried to fix it, but it came up like that

<?php
 
    include 'includes/conecta.php';
 
    $sql_select = "select member_id, firstname, lastname 
                    from members";
 
    $result_set = mysql_query($sql_select);
 
    $html = '';
 
    while($row = mysql_fetch_array($result_set)) {
 
        $member_id = $row['member_id'];
        $html .= "<div style='background-image:url(images/gradientdiv.gif); height:26px;'>$row[firstname] $row[lastname](<a href=\"javascript:showDiv('div$member_id');\" 
                    style='color:blue;'>Assign Offers</a>)</div>
                    <div id='div$member_id' style='display:none; background-color:#FFFFD9;'>";
        $sql_select_offers = "select o.offer_id, o.offer_name
                                from offers o 
                                where not exists (select *
                                from members_offers inner join offers 
                                    on members_offers.offer_id = offers.offer_id
                                where members_offers.member_id = $member_id
                                    and o.offer_id = offers.offer_id)";
        $result_set_offers = mysql_query($sql_select_offers);
 
 
        $html .= "<form action='assign_offers.php'>Check to Assign: <input type='checkbox' name='checkall' onclick=\"checkUncheckAll(this);\"/><br />";
        $html .= "<input type='hidden' name='member_id' value='$member_id' />";
 
        while($row = mysql_fetch_array($result_set_offers)) {        
            $html .= "<input type='checkbox' name='$row[offer_id]' value='$row[offer_id]' />
                        $row[offer_name]<br />";
        }
        $html .= "<input type='submit' value='Save' /></form></div>";
 
    }
 
?>
 

I have a contorl panel for my employess to feed customer data into it. Part of the process is to select offers that will be assigned to that customer. They do it by checking the checkboxes and that flags them as assigned to that customer.

The problem is that with the code above,( which lists all customers and a div where the checkboxes are to be checked) is that if I check all the checkboxes for each one of the customers returned from the database, after I assign all offers, the div will still be generated, but since the offers are marked as assigned already, they wont show on the div, but the form tag still exists. I want to able to hide that once a customer gets all offers assigned to him.

I think I made a bit more clear now :)