possible bug with selecting individual columns vs select splat.

[dupes2k]

Description

The following code:

<?php
// If using an SQL statement like:
$sql = "SELECT * FROM"...

// then you can assign array variables just fine as pulled from your $result->fetch_assoc() in your while loop.

// However if your SQL is like:
$sql = "SELECT my_var1 and my_var2 FROM"...

Resulted in this output:

// then using print_r() on the returned structure shows:
//Array
//{
//     [my_var1 and my_var2] => 0
//}

But I expected this output instead:

// normal array structure as shown with print_r()

PHP Version

php ver 8.2.28

Operating System

Debian 12 (bookworm)

[MorganLOCode]

Which dialect of SQL is that which uses "and" in that way?

[tcoch]

I just tried it and this works for MySQL.

And actually, the PHP output seems fine to me, since I got not two columns but just the one in the query result.

select a, b from table gives you this:

a	b
data_a	data_b
...	...

while select a and b from table gives you this:

a and b
0
...

[nielsdos]

This isn't a bug, if you write "a and b" in the select classes then you're evaluating a boolean. You can put expressions in the select clause. You should use a comma.