Loading data from MySQL

Suite and Optimus Suite 5
#1

It’s my first try at testing hmlxgrid.

I’m trying to load data from a MySQL table. Everything works correctly but one thing: only the first column gets inserted into the table.

In the connector.php file I wrote this line:
$conn->render_table(“Ecorceur”,“prodDate"jourID”,“billes_0”,“vol_0”,“billes_1”,“vol_1”,“billes_2”,“vol_2”);

The field “prodDate” is the primary key. With this line, the grid shows only the values of the field “jourID”.

I tried to modify the previous line like this:
$conn->render_table(“Ecorceur”,“prodDate”,“prodDate”,“jourID”,“billes_0”,“vol_0”,“billes_1”,“vol_1”,“billes_2”,“vol_2”);

In this case, the primary key field appears two times and the grid show only the values of this field.

Any idea what I should look for?

Thank you for any help.

#2

data fields is a coma separated list:
$conn->render_table(“Ecorceur”,“prodDate”,“prodDate,jourID,billes_0,vol_0,billes_1,vol_1,billes_2,vol_2”);

#3

Thank your very much, you make my day! Everything works now.