thanks.

I have made a dbconfig.php on the page

itself!

Now I have a dynamical dropdownlist.

But now I want to show my grid without

jqgrid.html but nothing displays.

check:

http://www.egmondonline.furion.....l/demo.php

view the source code.

My records are visable but when I call a function

like this in my page:

<? include("dbconfig.php"); 

  $select = "select * from invheader";
   $query  = mysql_query($select) or die (mysql_error());
  $list = mysql_fetch_assoc($query);
?>

I get :

"No database selected"

But is I delete this:

<?
  $select = "select * from invheader";
   $query  = mysql_query($select) or die (mysql_error());
  $list = mysql_fetch_assoc($query);
?>

It works again, very strange!

I suggest first to try with simple data not generated from PHP.

The example  is from demo site:

colModel:[

{name:'id',index:'id', width:90, sorttype:"int", editable: true}, {name:'name',index:'name', width:150,editable: true,editoptions:{size:"20",maxlength:"30"}}, {name:'stock',index:'stock', width:60, editable: true,edittype:"checkbox",editoptions: {value:"Yes:No"}}, {name:'ship',index:'ship', width:90, editable: true,edittype:"select",editoptions:{value:"FE:FedEx;IN:InTime;TN:TNT;AR:ARAMEX"}}, {name:'note',index:'note', width:200, sortable:false,editable: true,edittype:"textarea", editoptions:{rows:"2",cols:"10"}}

]

You should care that the last item should not contain ; at end - i.e

this is wrong

editoptions:{value:"FE:FedEx;IN:InTime;TN:TNT;AR:ARAMEX;"}

Regards

Tony

But I dont know how to integrate it

in your plugin.

I get the error undefined every time

php.net is a good start. Also check how to work with mysql functions

Regards

Tony

result (blank). The result is from search.php.

echo $row[tax]; doesnt work again

no result.

please give me a good example .

I want a dynamical selectbox that

get values from the database.

Thanks for helping tony

Try to echo the result and see what you have. See what you

output with this PHP code is compatible with the options.

Also if you make pure PHP

echo $row[tax];

What you have?

Regards

Tony

     {

name:'tax',

index:'tax',

width:80,

align:”right”,

edittype:'select',

editable:true,

editoptions:{value:”:All;<?=$row[tax]?>”}

}, 

Please give me a good example many people

asking for it on the web!

A love the plugin but it won't work my way

for jqgrid searching for days can't find

a good example?

I know php well but it wont work sorry being noobish

Refere to PHP functions how to convert SQL query result to

the string that is acceptable in jqGrid.

Regards

Tony

This won't work:

editoptions:{value:”:<? $select ="select * from table";

$query = mysql_query($select);

while($list=mysql_fetch_assoc($query)){

echo''.$list['blaat'].'';

}

”}

How to make it work?

jQuery("#grid_id").navGrid('#Pager',{
        edit:false,add:false,del:false,search:false
....

2) Using server side code creates a response as the value in the editoptions

I have two questions about the editoptions in grid.

1.) I want to make the search bar static so you don't have to click on search.

2.) With editoptions in the searchbar I want to make dropdowns with automatic database response. How to make it that way? Now I use static numbers like :

 editoptions:{value:":All;0.00:0.00;12:12.00;20:20.00;40:40.00;60:60.00;120:120.00"} 

change it to:

editoptions:{value:":(database)"}

Like this way, is there any option?

Sorry for my bad english!

Many regards,

paapie