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.

[Chuck Anderson]

Jerry Stuckle wrote:

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_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.

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

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

His question (to quote) about "how double quotes (") differ from single
quotes (')?"

It's spot on, Jerry. Did you even bother to look? That page it has a
very thorough discussion of Variable parsing and how to use both types.
--
*************** **************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Nothing he's got he really needs
Twenty first century schizoid man.
*************** *************** *****

[Jerry Stuckle]

Chuck Anderson wrote:

Jerry Stuckle wrote:

>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_comma nd = "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.

His question (to quote) about "how double quotes (") differ from single
quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it has a
very thorough discussion of Variable parsing and how to use both types.

Read again. He was asking about back tickies (`) in MySQL statements,
not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

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

[NC]

On May 27, 7:00 pm, MikeB <MPBr...@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.

Backticks (that's what they are called in programming, rather than
"accent graves") are identifier quotes in MySQL:

http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

Generally, they are not required, unless the identifier (the name of a
database, a table, a field, or another entity within a database)
happens to be the same as a reserved word or can be construed as an
expression. For example:

SELECT * FROM `select` WHERE id = 100;

In this case, you need to distinguish the table named `select` from
the beginning of the SELECT statement, so you have to use the
backticks.

For instance, I have the following:

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

Note that the name of the table includes a dash (aka the minus sign),
so if the name is not quoted, MySQL will be tempted to treat it as an
expression (7 minus 1_List), which, of course, is likely to produce an
SQL error.

I tried looking around on the php.net site

MySQL has a Web site, too, you know... :)

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.

Yes. See the PHP Manual (and read up on the heredoc syntax, too,
while you are on the subject of strings):

http://php.net/string

Cheers,
NC

[Chuck Anderson]

Jerry Stuckle wrote:

Chuck Anderson wrote:

>Jerry Stuckle wrote:

>>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_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.
>
>
Re: quotes - http://us.php.net/types.string

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

His question (to quote) about "how double quotes (") differ from single
quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it has a
very thorough discussion of Variable parsing and how to use both types.
B.S.

Read again. He was asking about back tickies (`) in MySQL statements,
not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you again:

I'm learning PHP and MySQL ......

..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

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

[Jerry Stuckle]

Chuck Anderson wrote:

Jerry Stuckle wrote:

>Chuck Anderson wrote:

>>Jerry Stuckle wrote:

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_comma nd = "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.

His question (to quote) about "how double quotes (") differ from
single quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it has
a very thorough discussion of Variable parsing and how to use both
types.
B.S.

Read again. He was asking about back tickies (`) in MySQL statements,
not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you
again:

>I'm learning PHP and MySQL ......

>..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

Yep, you obviously don't understand plain English.

"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.?"

That's his question - not single vs. double quotes.

You're right. Case closed.

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

[Chuck Anderson]

Jerry Stuckle wrote:

Chuck Anderson wrote:

>Jerry Stuckle wrote:

>>Chuck Anderson wrote:
Jerry Stuckle wrote:
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_comm and = "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.
>
>
His question (to quote) about "how double quotes (") differ from
single quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it has
a very thorough discussion of Variable parsing and how to use both
types.
B.S.

Read again. He was asking about back tickies (`) in MySQL statements,
not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you
again:

>>I'm learning PHP and MySQL ......

..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

Yep, you obviously don't understand plain English.

"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.?"

That's his question - not single vs. double quotes.

You're right. Case closed.

Your assumption is clearly wrong.

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

[Guillaume]

Chuck Anderson a écrit :

Your assumption is clearly wrong.

Yeah, let's do an other discussion about good/bad assumptions, popcorn
anyone ?

(Yet I notice that the problem once again occurs with a MySQL related
problem... though it's not related at all :p)

Btw guys, you both are "false" in a way, cause you both make
assumptions. From the OP's post, all I can say is *MAYBE* he wanted to
definitely clear the ' vs " point, as long as having a solution for his
issue, *MAYBE* he didn't care at all in the end.
Don't just say he was thinking a way you're not sure about, yet again :)

Regards,
--
Guillaume

[Jerry Stuckle]

Chuck Anderson wrote:

Jerry Stuckle wrote:

>Chuck Anderson wrote:

>>Jerry Stuckle wrote:

Chuck Anderson wrote:
Jerry Stuckle wrote:
>
>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_com mand = "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
>>>someon e 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.
>>
His question (to quote) about "how double quotes (") differ from
single quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it
has a very thorough discussion of Variable parsing and how to use
both types.
>
>
B.S.
>
Read again. He was asking about back tickies (`) in MySQL
statements , not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you
again:
I'm learning PHP and MySQL ......
..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

Yep, you obviously don't understand plain English.

"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.?"

That's his question - not single vs. double quotes.

You're right. Case closed.

Your assumption is clearly wrong.

Stoopid idiot. Can't even read plain English.

Better go back to first grade.

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

[Rik Wasmus]

Jerry Stuckle wrote:

Chuck Anderson wrote:

>Jerry Stuckle wrote:

>>Chuck Anderson wrote:

Jerry Stuckle wrote:

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_comm and = "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.
>
His question (to quote) about "how double quotes (") differ from
single quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it has
a very thorough discussion of Variable parsing and how to use both
types.
B.S.

Read again. He was asking about back tickies (`) in MySQL
statements, not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you
again:

>>I'm learning PHP and MySQL ......

>>..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

Yep, you obviously don't understand plain English.

"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.?"

That's his question - not single vs. double quotes.

You're right. Case closed.

Erm, Jerry, it is possible the OP asked 2 (two, more then one) question
in his post...
--
Rik Wasmus
....spamrun finished

[Jerry Stuckle]

Rik Wasmus wrote:

Jerry Stuckle wrote:

>Chuck Anderson wrote:

>>Jerry Stuckle wrote:
Chuck Anderson wrote:

Jerry Stuckle wrote:
>
>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_com mand = "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
>>>someon e 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.
>>
His question (to quote) about "how double quotes (") differ from
single quotes (')?"
It's spot on, Jerry. Did you even bother to look? That page it
has a very thorough discussion of Variable parsing and how to use
both types.
>
>
B.S.

Read again. He was asking about back tickies (`) in MySQL
statements , not single quotes (') in PHP.

It had absolutely nothing to do with PHP strings.

Du-uh ...... try again He spoke of both. Here I'll quote it for you
again:

I'm learning PHP and MySQL ......

..... 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.

Enough of this waste of time already. Haven't you better things to do?

Case closed.

Yep, you obviously don't understand plain English.

"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.?"

That's his question - not single vs. double quotes.

You're right. Case closed.

Erm, Jerry, it is possible the OP asked 2 (two, more then one) question
in his post...

Hi, Rik,

Yes and no. His question was about the backticks. A side comment
related to him having single vs. double quotes figured out (he thinks).

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