MySQL table names in PHP code

[MikeB]

I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Thanks.

[Jerry Stuckle]

MikeB wrote:

I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Thanks.

That's because it's a MySQL convention and has nothing to do with PHP.
Try the MySQL documentation.

SQL commands are just strings PHP passes to the database. From there
on, it's the databases responsibility.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[sheldonlg]

Jerry Stuckle wrote:

MikeB wrote:

>I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Thanks.

That's because it's a MySQL convention and has nothing to do with PHP.
Try the MySQL documentation.

SQL commands are just strings PHP passes to the database. From there
on, it's the databases responsibility.

They don't have to be escaped. They work fine without them.

$sql_command = "SELECT * from foo";

works.

[Curtis]

MikeB wrote:

I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Thanks.

You might want to try following up in comp.databases. mysql.

--
Curtis

[thelma]

MikeB <MP*****@gmail. comwrote:
: I'm learning PHP and MySQL. In the samples I work with, the SQL table
: names are "escaped" in accent grave (`) marks, not in single or double
: quotes.

: Can anyone explain that?

: For instance, I have the following:

: $sql_command = "SELECT * from `7-1_List`";

I discovered backquotes when I inherited a MYSQL database that
had a table with a column named 'interval'. MYSQL refused to let
me reference that column: I couldn't select it, update it, remove
it. The good people here and at the MYSQL newsgroup told me that
I would need to add those backquotes because 'interval' is
otherwise recognized as a MYSQL datatype.

I would guess that the backquotes are hiding that '-' [minus?]
from MYSQL--I prefer to rename things that need such extra handling.
--thelma

[Chuck Anderson]

MikeB wrote:

I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Re: quotes - http://us.php.net/types.string

--
*************** **************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Nothing he's got he really needs
Twenty first century schizoid man.
*************** *************** *****

[Tim Roberts]

sheldonlg <sheldonlgwrote :

>Jerry Stuckle wrote:

>MikeB wrote:

>>I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_comman d = "SELECT * from `7-1_List`";
...

That's because it's a MySQL convention and has nothing to do with PHP.
Try the MySQL documentation.

SQL commands are just strings PHP passes to the database. From there
on, it's the databases responsibility.

They don't have to be escaped. They work fine without them.

$sql_command = "SELECT * from foo";

works.

Of course it does, but "foo" is a very different name from "7-1_List". His
table name contains special characters that DO need to be escaped.
--
Tim Roberts, ti**@probo.com
Providenza & Boekelheide, Inc.

[Guillaume]

sheldonlg a écrit :

They don't have to be escaped. They work fine without them.

$sql_command = "SELECT * from foo";

works.

Yeah but this escaping is here to use named fields/tables with a name
matching a MySQL reserved name.

I encountered it a lot with int and (previously) date, those indeed
being MySQL reserved types, but also a nice name for a date field and a
(RPG game based site) intelligence status (just like str, hp, vit...).

SELECT `int` FROM mytable
works whereas
SELECT int FROM mytable
tries to access the int type and fails.

Long ago (and as far as I remember), the same applied to date, referring
to the date() function.

Btw this is nowhere close to a PHP related issue ^^

Regards,
--
Guillaume

[Jerry Stuckle]

sheldonlg wrote:

Jerry Stuckle wrote:

>MikeB wrote:

>>I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_comman d = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Thanks.

That's because it's a MySQL convention and has nothing to do with PHP.
Try the MySQL documentation.

SQL commands are just strings PHP passes to the database. From there
on, it's the databases responsibility.

They don't have to be escaped. They work fine without them.

$sql_command = "SELECT * from foo";

works.

It depends - sometimes you do. But that's a question for
comp.databases. mysql, not comp.lang.php.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Jerry Stuckle]

Chuck Anderson wrote:

MikeB wrote:

>I'm learning PHP and MySQL. In the samples I work with, the SQL table
names are "escaped" in accent grave (`) marks, not in single or double
quotes.

Can anyone explain that?

For instance, I have the following:

$sql_command = "SELECT * from `7-1_List`";

I tried looking around on the php.net site, but clearly I'm not using
the right search terms.

While I'm asking, I think I've figured out how double quotes (")
differ from single quotes ('), but if there is a discussion that
someone can point me to, that would be very nice.

Re: quotes - http://us.php.net/types.string

Good try, but it has nothing to do with the user's question.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===