Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[z.m]

Se poate ca sa am in capul de tabel carectere de genul /,-,""?
daca da,cum fac sa le introduc dac am:
$query = "ALTER TABLE m_picks CHANGE ".$fields1." ".$field1." varchar(255)";
$rezultat = mysql_query($query) or die ("Unable to do query" . mysql_error());

[z.m]

Am reusit sa introduc caracterele,dar imi baga in fata la ghilimele cate un slash,si la slash inca un slash

[johnny]

Cod:
$query = "ALTER TABLE m_picks CHANGE `".$fields1."` `".$field1."` varchar(255)";


dupa cum observi e un caracter mai "ciudat" langa " ...


de ce vrei sa introduci astfel de caractere in header?

[z.m]

E o structura a bazei de date mai complicata si am nevoie ca in capul de tabel sa am si caractere speciale.

[Radical]

Nu. Nu toate... Adica daor minus poate aparea in numele unui tabel:

Citat: 9 Language Structure - Database, Table, Index, Column, and Alias Names
Database - Maximum Length (bytes): 64 - Allowed Characters: Any character that is allowed in a directory name, except `/', `\', or `.'

Table - Maximum Length (bytes): 64 - Allowed Characters: Any character that is allowed in a filename, except `/', `\', or `.'

Column - Maximum Length (bytes): 64 - Allowed Characters: All characters.

Index - Maximum Length (bytes): 64 - Allowed Characters: All characters

Alias - Maximum Length (bytes): 255 - Allowed Characters: All characters

In addition to the restrictions noted in the table, no identifier can contain ASCII 0 or a byte with a value of 255. Database, table, and column names should not end with space characters. Before MySQL 4.1, identifier quote characters should not be used in identifiers.

Cam atat ! Am gasit eu !

[PHPRomania Bot]