table dynamic

[insert_php]
$conn = new mysqli(“localhost”, “q4j8e5j1_vito”, “OO.c,Tefw,{2”, “q4j8e5j1_library”);

/* check connection */
if ($conn->connect_errno) {
printf(“Connect failed: %s\n”, $conn->connect_error);
exit();
}

$selected = $_REQUEST[‘selected’];
echo “

“;

echo “

“;

$id_counter = 0;

$result = mysqli_query($conn,”SELECT * FROM series WHERE series = ‘$selected'”);
while($newArray = mysqli_fetch_array($result)){
$series = $newArray[‘series’];

if ( wpmd_is_phone() ) {
echo “

\n

\n

“;
} else {
echo “

\n

\n

“;
}

$result2 = mysqli_query($conn,”SELECT * FROM items WHERE series = ‘$selected’ ORDER BY item_number”);
while($newArray2 = mysqli_fetch_array($result2)){

$id = $newArray2[‘id’];
$item_number = trim($newArray2[‘item_number’]);
$item_name = $newArray2[‘item_name’];

$id_counter++;

$pdf = $newArray2[‘pdf’];
$manual = $newArray2[‘manual’];
$cad = $newArray2[‘cad’];
$video = $newArray2[‘video’];
$youtube_video_id = $newArray2[‘youtube_video_id’];

echo “

\n”;
echo “

\n”;

echo “

\n”;

//pd
if($pdf == “on”){
echo “

\n”;

//manual
echo “

\n”;

//cad
echo “

\n”;

if ( wpmd_is_phone() ) {
echo “

“;
}

echo “

\n”;

}

}
echo “

$series SERIES:
$series SERIES:
$item_number	$item_name	“; } else { echo “	“; } echo “PDF View”; if($pdf == “on”){ echo ““; } echo “	“; if($manual == “on”){ echo “	“; } else { echo “	“; } echo “Manual”; if($manual == “on”){ echo ““; } echo “	“; if($cad == “on”){ echo “	“; } else { echo “	“; } echo “CAD”; if($cad == “on”){ echo ““; } echo “

“;

if($id_counter < 1){ echo "No data found for this series.

“;
}

echo ““;

[/insert_php]