MySQL Query #2
#5

Learn your quotes. Backticks (`) are not the same as quotes ('). Backticks are used to denote the enclosed value as a table or column name. Normal quotes are used to denote the enclosed value as a literal. Meaning this:
PHP код:
WHERE `Name` = `%e
is looking for rows where the column name is equal to the column whatever-%e-contains.

Only use the normal quotes for strings and just get rid of all the backticks altogether.
Reply


Messages In This Thread
MySQL Query #2 - by DeeadPool - 08.04.2017, 07:45
Re: MySQL Query #2 - by DeeadPool - 08.04.2017, 19:03
Re: MySQL Query #2 - by ShoortyFl - 08.04.2017, 19:13
Re: MySQL Query #2 - by DeeadPool - 08.04.2017, 19:16
Re: MySQL Query #2 - by Vince - 08.04.2017, 19:17
Re: MySQL Query #2 - by DeeadPool - 08.04.2017, 19:41

Forum Jump:


Users browsing this thread: 1 Guest(s)