CodingForums.com - View Single Post

Old Pedant · 03-06-2013, 08:55 PM

I have to say, this strikes me as indicative of bad DB design:

Code:

    $tbl_name = 'yourtable'; 
    $sql="INSERT INTO $tbl_name (gamename, gamecode, region, mode, vmc, smb, hdd, usb, notes, comp) 
        VALUES  ...

Why does the name of the table need to be a variable? Surely you don't have more than one table with the same fields??? Or did we discuss this before?

03-06-2013, 08:55 PM	PM User \| #15
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,579 Thanks: 62 Thanked 4,063 Times in 4,032 Posts	I have to say, this strikes me as indicative of bad DB design: Code: $tbl_name = 'yourtable'; $sql="INSERT INTO $tbl_name (gamename, gamecode, region, mode, vmc, smb, hdd, usb, notes, comp) VALUES ... Why does the name of the table need to be a variable? Surely you don't have more than one table with the same fields??? Or did we discuss this before? __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.