Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
problem with SQL syntax in jqgrid
01/09/2010
09:57
Avatar
pilem1969
New Member
Members
Forum Posts: 2
Member Since:
31/08/2010
sp_UserOfflineSmall Offline

Notice: 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

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information