How do I pass the COUNT attribute in my sql string, since "COUNT" is a reserved php word?

Question

How do I pass the COUNT attribute in my sql string, since "COUNT" is a reserved php word?

Asked 7 years, 6 months ago

Viewed 91 times

0

Follows the string of select:

$resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";

Missing close a parenthesis at the end of your code.

– Filipe Martins

2017/04/28 at 16:59
2

If the count will be inside a string makes no difference if it is reserved word or not.

– Jéf Bueno

2017/04/28 at 17:15

1 answer

Browser other questions tagged php mysql mariadb

You are not signed in. Login or sign up in order to post.

by Solange • **309** points · Answer 1 · 2017-05-01T13:08:38+00:00

The count(*) is inside the string, so no problem, to get its value and be more readable too, I suggest assigning an alias to it ex: select count(*) as total from ...