HELP guys!!!
help me
I HAVE TABLE BELOW WHICH HAS THE CITIES . This table is in the database TABLENAME=CALIFORNIA
Cities 2013 2012 Foodsales2013 Foodsales2012 //COLUMN NAME
San Jose 34 30 15 10 //ENTRY 1
SAN FRANSISCO 21 15 12 09 // ENTRY 2
For this above table i want to retrieve the single row when i click on the grid
i have written the php file which doesnt work
<?php require_once("../dhtmlxConnector_php/codebase/grid_connector.php"); $conn = mysql_connect("localhost","root","root"); mysql_select_db("insect"); $grid = new GridConnector($conn,"MySQL"); $grid ->render_table("",); $grid->render_sql("SELECT * FROM `CALIFORNIA` WHERE Cities=rId ","CITIES,2013,2012,Foodsales2013,Foodsales2012"); ?>When i double click it must take the row id and display consider row id as Cities