Forum
Topic RSS
09:57
31/08/2010
OfflineNotice: Undefined index: page in C:\wamp\www\nwiseCRM\testGrid.php on line 64
Notice: Undefined index: rows in C:\wamp\www\nwiseCRM\testGrid.php on line 67
Notice: Undefined index: sidx in C:\wamp\www\nwiseCRM\testGrid.php on line 71
Notice: Undefined index: sord in C:\wamp\www\nwiseCRM\testGrid.php on line 74
Notice: Use of undefined constant grid - assumed 'grid' in C:\wamp\www\nwiseCRM\testGrid.php on line 83
Couldn't execute query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Tried to solve this with SQL syntax.
mysql_select_db(grid, $db) or die("Error connecting to db.");
$result = mysql_query("SELECT COUNT(*) AS count FROM invheader");
$result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error());$SQL = "SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx $sord LIMIT $start , $limit";
I copied from jqgrid's files but changed name for db,tablename etc.
Without php it works well with jqgrid.
Thanks for help!
// Pilem1969
Most Users Ever Online: 994
Currently Online:
37 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
Log In
Home