473,480 Members | 2268 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

MySQL table names in PHP code

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.
Jun 2 '08 #1
23 1572
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*******@attglobal.net
==================
Jun 2 '08 #2
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.
Jun 2 '08 #3
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
Jun 2 '08 #4
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
Jun 2 '08 #5
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.
***********************************

Jun 2 '08 #6
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_command = "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.
Jun 2 '08 #7
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
Jun 2 '08 #8
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_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.
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*******@attglobal.net
==================
Jun 2 '08 #9
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*******@attglobal.net
==================
Jun 2 '08 #10
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_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.
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.
***********************************

Jun 2 '08 #11
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_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.

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*******@attglobal.net
==================
Jun 2 '08 #12
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
Jun 2 '08 #13
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_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.
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.
***********************************

Jun 2 '08 #14
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_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.

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*******@attglobal.net
==================
Jun 2 '08 #15
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_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.
>
>
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.
***********************************

Jun 2 '08 #16
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
Jun 2 '08 #17
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_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.
>>
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*******@attglobal.net
==================
Jun 2 '08 #18
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_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.
>
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
Jun 2 '08 #19
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_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.
>>
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*******@attglobal.net
==================
Jun 2 '08 #20
Jerry Stuckle a écrit :
Yes and no. His question was about the backticks. A side comment
related to him having single vs. double quotes figured out (he thinks).
Whatever, just quit it, who cares actually ?
At least the comment you consider as inappropriate is the most PHP
oriented of this topic. Not such a big deal.

Regards,
--
Guillaume
Jun 2 '08 #21
Guillaume wrote:
Jerry Stuckle a écrit :
>Yes and no. His question was about the backticks. A side comment
related to him having single vs. double quotes figured out (he thinks).

Whatever, just quit it, who cares actually ?
At least the comment you consider as inappropriate is the most PHP
oriented of this topic. Not such a big deal.

Regards,
No, backticks in MySQL table names has nothing to do with PHP. They're
not used by other databases, but the syntax is identical in other
languages when calling MySQL.

It has nothing to do with PHP - which is why it is not documented in the
PHP manual (but it is in the MySQL manual - which should give you a hint).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jun 2 '08 #22
>the comment you consider as inappropriate
I was talking about Chuck's comment, which only concern was quotes vs
double quotes in PHP. Which indeed was the nearest to the NG subject,
though it may (or may not) be appropriate to the OP.

I mean, he would have said something not really exact, appropriate or
accurate, if OT then one could say "don't post if that's OT and possibly
useless".
While Chuck posted something that *may* be useless to the OP (depends on
what he really meant), but at least is related to the topic.

Regards,
--
Guillaume
Jun 2 '08 #23
Wow. OK, firstly thank you all for the polite way you answered my
first question while pointing out that it was also OT. Other forums
are not always so kind.

Since I didn't realize that the backticks were SQL, I guess I
conflated them with quotes and double quotes to some extent.

I did actually ask two questions, the first one about the backticks
and then a secondary and much less important question about the quotes
vs double quotes issue so that I could read up on those and make sure
my understanding of them were thorough.

So I appreciate the responses I got to both answers. Thank you all.

Jun 2 '08 #24

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3540
by: jacob nikom | last post by:
I would like to create data model for a group of stores. All stores in this group are very similar to each other, so it is natural to allocate one MySQL database per store. Each database is going...
0
3919
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
1
538
by: David | last post by:
Hi, I currently administer our MySQL db version 3.23.56 on a Linux Cobalt Qube server via an external fron-end piece of software. My Table Names have capital letters at the beginning, i.e....
1
1578
by: Neil Zanella | last post by:
Hello, Consider the following PostgreSQL or Oracle SQL DDL code: CREATE TABLE fooTable ( foo INTEGER, PRIMARY KEY (foo) ); CREATE TABLE barTable (
39
8363
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...
39
3182
by: windandwaves | last post by:
Hi Folk I have to store up to eight boolean bits of information about an item in my database. e.g. with restaurant drive-through facility yellow windows
6
38444
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
39
5820
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
1
9542
ssnaik84
by: ssnaik84 | last post by:
Hi Guys, Last year I got a chance to work with R&D team, which was working on DB scripts conversion.. Though there is migration tool available, it converts only tables and constraints.. Rest of...
0
7054
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7057
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7102
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7003
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4798
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3008
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1310
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
570
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
199
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.