2. PHPRunner General questions
  3. [SOLVED]  $strSQL
This topic is locked
[SOLVED]

 $strSQL

 		9/13/2016 4:41:50 AM
PHPRunner General questions
W
 workingwim author

Hello,

USE Mysql.

I like to use $strSQL in a List for select all records with Name = UserID.
In the List Page: Before SQLQuery event i have code:

$strSQL = AddWhere(strSQL, "[Name]='" & session_id("UserID") & "'")
I get a error:

256

Fout beschrijving 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 'strSQL count(*) trSQL where ' at line 1
Please help to solve the error with right code?.
Regards,
Workingwim.
Myr0n 9/13/2016



Hello,

USE Mysql.

I like to use $strSQL in a List for select all records with Name = UserID.
In the List Page: Before SQLQuery event i have code:

$strSQL = AddWhere(strSQL, "[Name]='" & session_id("UserID") & "'")
I get a error:

256

Fout beschrijving 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 'strSQL count(*) trSQL where ' at line 1
Please help to solve the error with right code?.
Regards,
Workingwim.


you need to add in your session variable $_SESSION["UserID"]
[font="Courier New"]
W
 		workingwim author 9/13/2016



you need to add in your session variable $_SESSION["UserID"]
[font="Courier New"]