Using Onchange or Onclick

[jessy]

I have a form which contains a combo box and a table ..i need that whenever the user selects an option from the combo box the page is reloaded but with the table data related to that client he choosed from the box .. i really need help with this and im very confused whether to use <select onchange= > or <option onclick>
and also how to tell him to reload same page

[Markus]

--Moved to Javascript.

[gits]

typically you use the onchange-event of the select-node. and for a submit you may call a function that uses the submit()-method

[bnashenas1984]

Here's what you can do:

<select onchange="this.form.submit()">

Don't forget to put your combo box in a form.
Each time the user changes the value of your combo box the form gets submited

Hope it helps

[jessy]

Okay now i managed to make the data changes with the user's selection BUT i faced another huge problem which is
the user is presented with many options(clients ) which are generated in a while loop and an option which is not in the while loop which states ALL clients
when the page loads for the first time the data in the table are for all clients but once i select any option and then try to select ALL clients again Nothing appears so i was asking if their anyway i could handle this
here's the code:

<select onChange=this.form.submit(); name="clients"> 
<option >All Clients </option>
<?$query=mysql_query("select * from clients");
    while($row=mysql_fetch_array($query))
    {   
    	
   echo"<option value=$row[c_id] >$row[c_name]</option>";	
    	
    }
$sql="select sum(order_price) from orders";
    
     if($_POST[clients])
        { 
        	$clients=$_POST[clients];
      
        $sql="select sum(order_price) from orders where client_id=$clients";
         }
     
          $query=mysql_query($sql);
           
               $row=mysql_fetch_array($query);

[bnashenas1984]

That's because you don't have a VALUE attribute for your first option which is ALL CLIENTS

When your page loads for the first time , the code recieves no value from your combo box but when you choose ALL CLIENTS for the second time then your PHP code recieves ALL CLIENT.

What you need to do is to set a NULL value for your first option like this

<option value="">All clients</option>

Post back if there is any other problem

[jessy]

Okay i made what u say But still facing the same problem nothing happens when i press ALL CLIENTS :(

[acoder]

Your onchange submits the form. Check that your PHP code displays all clients when the value of clients is empty.

[jessy]

Yeah thats exactly what i need to do !!
display all clients when value is empty ? all clients are displayed only once when the page loads for the very first time but then nothing appears again

[acoder]

Your PHP code needs a bit of alteration too. On line 11, you have:

if($_POST[clients])

you need to add a condition for when the POST value is empty.

Note that you can also avoid a page reload using JavaScript/Ajax.

[jessy]

Okay, now i added a condition but nothing changes

Any help on how to use AJax for this or any tutorial ...!

[acoder]

What condition did you add?

Ajax is useful if you want to avoid the page reload. If that's not a requirement, then it's not necessary. If you want a tutorial, check out the links in the Off-site Links thread.

[jessy]

:( i added the Condition

 if($_POST[clients]&&!empty($_POST[clients]))

also i checked some ajax tutorial but felt very depressed things r not that easy i thought

[acoder]

Shouldn't $_POST[clients] be $_POST['clients']? If you have more problems with the PHP code, start a new thread in the PHP forum.