Php / Mysql :0:,:1:

[nicolino101]

Has anyone ever seen or used these type of variables when creating an sql_query?

ex...

Insert Into db.table ('id','name','a ddress') Values(:0:, :1:, :2:)

Please let me know what the heck they are?

[ronverdonk]

No never seen it. I also never have seen a column name within single quotes. I am sure that will not work.

Ronald

[nicolino101]

No never seen it. I also never have seen a column name within single quotes. I am sure that will not work.

Ronald

Actually it's only the :0:, :1: (use of colons) that I'm concerned with...
<br />
Can't seem to find anything on it.

[Atli]

I have never seen this either, nor do I think this is valid syntax in either PHP or MySQL.

Only possible reason I can see for doing something like this is if you plan on using regex to replace them with valid values.
Perhaps a part of some custom template system?

[dlite922]

Has anyone ever seen or used these type of variables when creating an sql_query?

ex...

Insert Into db.table ('id','name','a ddress') Values(:0:, :1:, :2:)

Please let me know what the heck they are?

Actually i have seen this, but it intrigued me then but never followed through.

It has to do with variables like you said, mysql variables.

Why not check out the manual and let us know. I'd like to find out and i'm sure these two knuckleheads would like to know that this is actually valid syntax. (or there is something like this).

[dlite922]

FOUND IT!!

http://dev.mysql.com/doc/refman/6.0/en/user-variables.html

That's in 6.0, didn't look to see in prev ver but i'm sure this isn't something new.

roverdonk, atli..... go hit the books! ;)

But your right, what he had, was not valid syntax, but I think this is where I've seen colons used. In his example 1 and 2 are variable names.

C YA!

[rpnew]

Has anyone ever seen or used these type of variables when creating an sql_query?

ex...

Insert Into db.table ('id','name','a ddress') Values(:0:, :1:, :2:)

Please let me know what the heck they are?

Hi,

'id' can be `id` in MySql but never seen the values clause like that... post here if anyone gets answer..

Regards,
RP

[rpnew]

FOUND IT!!

http://dev.mysql.com/doc/refman/6.0/en/user-variables.html

That's in 6.0, didn't look to see in prev ver but i'm sure this isn't something new.

roverdonk, atli..... go hit the books! ;)

But your right, what he had, was not valid syntax, but I think this is where I've seen colons used. In his example 1 and 2 are variable names.

C YA!

Hi,

Its there in earlier version as well but not what he has written... : on both side.. or something like that...

Regards,
RP

[nicolino101]

Thanks for the help... and I'm sorry about the confusion.
It should have been

Insert Into db.table id, name, address Values(:0:, :1:, :2:)

The colons are used for user defined variables in Mysql 6.
But, in my case I believe that they are being used differently.

Possibly as stated above in a regex statement on retrieval.

Not a MySql or PHP thing.

This is a great forum...