Vælg dele af data fra database på forskellige måder.

$rb_res = mysql_query(SELECT * FROM tabel);
while ($rb_row = mysql_fetch_assoc($rb_res))
{
  if(!mysql_query(INSERT INTO indekstabel (navn) VALUES('$rb_row[navn]')))
  {
    die('Error: ' . mysql_error());
  } else {
    $id_ref = mysql_insert_id();
    $rb_ex_arr = explode(",", $rb_row['type']);
    foreach($rb_ex_arr as $rb_ex_val) {
      if(!mysql_query(INSERT INTO typetabel (id_ref, type) VALUES('$id_ref', '$rb_ex_val')))
      {
        die('Error: ' . mysql_error());
      }
    }
  }
}

echo "Typer:<br />
$type_res = mysql_query(SELECT DISTINCT id_ref,type FROM typetabel);
while($type_row = mysql_fetch_assoc($type_res)){
  echo "<a href=\"?type=".$type_row['type']."\">".$type_row['type']."</a><br />"
}

echo "ID'er af typen ".$_GET['type'].":<br />";
$id_res = mysql_query(SELECT id_ref FROM typetabel WHERE type = '$_GET["type"]');
while($id_row = mysql_fetch_assoc($id_res)){
  echo $id_row['id']."<br />";
}

$result = mysql_query(SELECT id_ref FROM typetabel WHERE type = '$_GET["type"]');
$type_num = mysql_num_rows($result);
echo "Der er ".$type_num." resultater af typen ".$_GET["type"].".<br />";

<?
include("config.php");

$id_res = mysql_query("SELECT DISTINCT(type), refid FROM type");
while($id_row = mysql_fetch_assoc($id_res))
{
  $num_res = mysql_query("SELECT refid FROM type WHERE type = '$id_row[type]'");
  $type_num = mysql_num_rows($num_res);
  echo "<a href=\"side2.php?refid=".$id_row['refid']."\">".$id_row['type']." (".$type_num.")</a><br />";
}

?>

mysql_query("SELECT DISTINCT(type), refid FROM type");

side2.php?refid=x

mysql_query("SELECT id FROM main WHERE id = $_GET['refid']");

include("config.php");
$id_res = mysql_query("SELECT DISTINCT(type), refid FROM type");
while($id_row = mysql_fetch_assoc($id_res)){
  $num_que = "SELECT refid FROM type WHERE type = '".$id_row['type']."'";
  $num_res = mysql_query($num_que);
  $type_num = mysql_num_rows($num_res);
  echo "<a href=\"side2.php?refid=".$id_row['refid']."\">".$id_row['type']." (".$type_num.")</a><br />";
}
?>

$id_res = mysql_query("SELECT type FROM type GROUP BY type");

<?
include("config.php");

$type_que = "SELECT * FROM type INNER JOIN Main ON type.refid = Main.id WHERE type.type = '".$_GET['type']."'";
$type_res = mysql_query($type_que);
while($type_row = mysql_fetch_assoc($type_res))

{
  echo ".$type_row['title']."<br>"; 
}
?>

<?
include("config.php");

$type_que = "SELECT * FROM type INNER JOIN Main ON type.refid = Main.id WHERE type.type = '".$_GET['type']."'";
$type_res = mysql_query($type_que);
while($type_row = mysql_fetch_assoc($type_res))

{
  echo $type_row['title']."<br />"; 
}
?>

<?
include("config.php");

$type_get = $_GET['type'];
echo "Typen hentet fra adressen: ".$type_get."<br />";
$type_que = "SELECT * FROM type INNER JOIN main ON type.refid = Main.id WHERE type.type = '$type_get'";
echo "<br />Query:".$type_que."<br /><br />";
$type_res = mysql_query($type_que);
while($type_row = mysql_fetch_assoc($type_res))
{
  echo $type_row['title']."<br />"; 
}
?>

<?
include("config.php");

$type_get = $_GET['type'];
echo "Typen hentet fra adressen: ".$type_get."<br />";
$type_que = "SELECT * FROM type INNER JOIN main ON type.refid = main.id WHERE type.type = '$type_get'";
echo "<br />Query:".$type_que."<br /><br />";
$type_res = mysql_query($type_que);
while($type_row = mysql_fetch_assoc($type_res))
{
  echo $type_row['title']."<br />"; 
}
?>

<?
$type_get = $_GET['type'];
echo "Typen hentet fra adressen: ".$type_get."<br />";
$type_que = "SELECT * FROM type INNER JOIN main ON type.refid = Main.id WHERE type.type = '$type_get'";
echo "<br />Query:".$type_que."<br /><br />";
?>