Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh->prepare('
       SELECT *
    ...
    ');
    
    $sth->execute($post_id, $language_name);
    
  2. or download this
    CREATE TABLE `languages` (
        `lang_id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ...
        `post_id`, INT(11) UNSIGNED NOT NULL,
        `post_translation_id` INT(11) UNSIGNED NOT NULL,
    );
    
  3. or download this
    CREATE TABLE `languages` (
        `lang_id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ...
    CREATE TABLE `posts` (
        `post_id`, INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    );