HOW TO USE USER_ID or USER

Topic: HOW TO USE USER_ID or USER_NAME (Read 6031 times) previous topic - next topic

HOW TO USE USER_ID or USER_NAME

January 28, 2019, 11:24:36 AM

Hello, o need help, new here.

I need to filter in adding register un a table with the iddentified user. and this daes not work, why??

"SELECT nombre AS Responsable FROM responsables WHERE responsables.id = 'USER_ID' ORDER BY nombre ASC"

Thanks

Re: HOW TO USE USER_ID or USER_NAME

Reply #1 – February 04, 2019, 06:05:32 PM

The USER_ID and USER_NAME are PHP Constants

Here is the correct way of doing it.

Code: [Select]

"SELECT nombre as Responsable from responsables where responsibles.id='" . USER_ID . "' ORDER BY nombre ASC"

Regards