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

[c0stty]

Salut,

As vrea sa adaug in baza de date ceva de genul

table_name_1
table_name_2
table_name_$i :roll:

Stie cineva cineva cum introduc acel contor ?

[dechim]

Cod:
// $conn este identificatorul conexiunii MySQL
$prefix_tabela = 'table_name_'

$result = mysql_query("SHOW TABLES FROM baza_de_date LIKE '".$prefix_tabela."%';",$conn)) ;

$ord=0;
while ($line = mysql_fetch_array($result)
 {
    $ord1 = (integer) substr($line[0],strlen($prefix_tabela));
   if ($ord1>$ord) $ord=$ord1;
 }
$ord++;
$tb_name = $prefix_tabela.$ord;
mysql_query('CREATE TABLE '.$tb_name.' ( ... urmeaza structura .. ), $conn);

[PHPRomania Bot]