What does the SQL statement in the php environment mean? $ Query_Recordset1sprintf (& quot; SELECT * FROMtk_userWHEREtk_user_statusLIKE % sANDtk_user_statusNOTLIKE % sANDtk_display_nameLIKE % sORDERBY SQL statement in the php environment. what does this mean?
$ Query_Recordset1 = sprintf ("SELECT * FROM tk_user WHERE tk_user_status LIKE % s AND tk_user_status not like % s AND tk_display_name LIKE % s order by tk_user_registered DESC ",....
What operations did you perform? "Tk_user_status LIKE % s AND tk_user_status not like % s" is NOT a conflict? But the program runs normally!
------ Solution --------------------
Is there anything wrong with this? Fill three strings with three placeholders.
------ Solution --------------------
This is not a conflict! Tk_user_status LIKE % s AND tk_user_status not like % s
The previous variable % s is different from the subsequent variable % s. The following is the input parameter variable.
GetSQLValueString ("%". $ colrole_Recordset1. "%", "text "),
GetSQLValueString ("%". $ colrole_dis. "%", "text "),