SQL Syntax error

6 posts by 3 authors in: Forums > CMS Builder
Last Post: December 21, 2022   (RSS)

By Dave - December 7, 2022

Hi phplast, 

Did you get this resolved?  If not, try printing out the query with: echo $query;

It's a lot easier to spot errors in the generated SQL code.

Hope that helps, 

Dave Edis - Senior Developer
interactivetools.com

Resolved as mentioned via email.

Thanks.

Hi,

If you could pass on the actual solution it might be helpful to someone else,

Thanks,

Jerry

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

For some reason I failed to determine, the syntax I posted earlier didn.t work.

However, using the below instead, did.

mysql_insert('_accesslist', array(
'userNum' => $user_num,
'tableName' => 'apply_for_cme',
'accessLevel' => '6',
'maxRecords' => '1000', // max listings allowed
'randomSaveId' => '123456789', /
));

Thanks,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php