<?php
include_once "html.php";
include_once "mysql_query.php";
?>
<?php
$link = @mysql_connect("{$servername}", "{$username}", "{$password}");
if (!$link) {
die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die("Unable to select database");
#$constraints = get_all_get_values($DECK_TABLE_SHOW_ATTR);
#print_deck_select_table($DECK_TABLE_NAME, $DECK_TABLE_SHOW_ATTR, $constraints);
#
#echo "<div id=\"deck_table_side\"><div>";
if (array_key_exists("id", $_GET)) {
$id = $_GET["id"];
$table = get_deck_table_name($id);
if (mysql_num_rows(mysql_query("SHOW TABLES LIKE '{$table}'")) == 1) {
print_aside_deck($id);
#print_msg(get_deck_name_by_id($id));
#$total = print_table($table, $DECK_SINGLE_TABLE_ATTR, 'print_single_deck_table_callback');
#print_msg("total = $total");
}
}
#echo "QQQQQQQ";
mysql_close($link);
?>
print_msg("<h2>same deck</h2>");
return;
}
$table1 = get_deck_table_name($deck1_id);
$table2 = get_deck_table_name($deck2_id);
echo "<aside class=\"left\">";
#echo "<aside>";
print_aside_deck($deck1_id);
#print_msg(get_deck_name_by_id($deck1_id));
#$total = print_table($table1, $DECK_SINGLE_TABLE_ATTR, 'print_single_deck_table_callback');
#print_msg("total = $total");
#$total = print_table($table1, $DECK_SINGLE_TABLE_ATTR);
#print_msg("total = $total");
echo "</aside>";
echo "<aside>";
print_aside_deck($deck2_id);
#print_msg(get_deck_name_by_id($deck2_id));
#$total = print_table($table2, $DECK_SINGLE_TABLE_ATTR);
#print_msg("total = $total");
echo "</aside>";
$sub_query = "SELECT {$table1}.id AS id, {$table1}.num AS num1, {$table2}.num AS num2 FROM {$table1} LEFT JOIN {$table2} ON {$table1}.id = {$table2}.id UNION SELECT {$table2}.id AS id, {$table1}.num AS num1, {$table2}.num AS num2 FROM {$table1} RIGHT JOIN {$table2} ON {$table1}.id = {$table2}.id";
#print_msg($sub_query);
$show_attr = array("num1", "num2");
$show_attr = array_merge($show_attr, $CARD_TABLE_SHOW_ATTR);
$show_str = implode(', ', $show_attr);
#$show_str = implode(', ', $CARD_TABLE_SHOW_ATTR);
#$sub_query = "SELECT $table1.id AS id, $table1.num AS num1, $table2.num AS num2 FROM $table1 INNER JOIN $table2 ON $table1.id = $table2.id";
$query = "SELECT {$show_str} FROM {$CARD_TABLE_NAME} INNER JOIN ({$sub_query}) sub ON {$CARD_TABLE_NAME}.id = sub.id;";
#$query = "SELECT * FROM $table1 NATURAL JOIN SELECT * FROM $table2;";
#print_msg($sub_query);
#print_msg($query);
