<?php
    function dbconnect()
    {
        $db_host = "localhost";
        $db_user = "db_user";
        $db_password = "password";
        $db_database = "test";

        $db_connect = mysql_connect($db_host,$db_user,$db_password)
            or die("ERROR: Could not connect to the database!<br>MySql Error: " . mysql_error());
        mysql_select_db($db_database, $db_connect)
            or die("ERROR: Could not select database!<br>MySql Error: " . mysql_error());
        return $db_connect;
    }

    function sqlquery($sql_query)
    {
        $link = dbconnect();
        $result = mysql_query($sql_query);
        return $result;
    }
//-----
    echo "<h2>Sletter gammel tabell</h2>";
    $res = sqlquery("DROP TABLE temptest");

    $res = sqlquery("
        CREATE TABLE IF NOT EXISTS `temptest` (
        `id` int(11) NOT NULL auto_increment,
        `bestiller` varchar(10),
        `bestnr` varchar(4),
        PRIMARY KEY  (`id`) )
    ",FALSE);

    echo "<H2>Oppretter testdata</H2>";
    $res = sqlquery("
        INSERT INTO temptest
            (bestiller, bestnr)
        VALUES
            ('Test','0001')
    ");

    echo "<H2>Vise data fra tabell</H2>";

    $bnr="0001";
    $res=sqlquery("SELECT * from temptest WHERE bestnr='$bnr'");
    $res_num = mysql_num_rows($res);

    echo "<i>Antall poster i select:</i> $res_num<br/>";

    $row = mysql_fetch_row($res);

    $bestnr = $row['bestnr']; // FEILER - Feilmelding: Notice: Undefined index: bestnr in D:\wamp\www\test.php on line 52
    echo "<i>bestnr:</i> $bestnr";


?>