Mqsql database panel

Hello I am trying to make a table on my website that allows me to see the keys in my database I currently have this code

$username="N/A";
$password="N/A";
$database="N/A";
$host="N/A";
$dbConn = mysql_connect($host, $username, $password, $database)
or die("Could not connect: " + mysql_error());
mysql_select_db($database, $dbConn)
or die("Could not find database: " + mysql_error());
 
 
$txt = "<table align=\"center\">";
    $txt .= "<tr><td>KeyCode</td><td>Date</td><td>Sold</td><td>Email</td></tr>";
    $sql = "SELECT * FROM `benkeys` where id = 1";
$res = mysql_query($sql, $dbConn)
or die(mysql_error());
if($res && mysql_num_rows($res)) {
}
 
mysql_close($dbConn);
        $cal = "js_del_key('".$row["keycode"]."'); return false;";
        $txt .= "<tr><td>".$row['keycode']."</td><td>".$row['datum']."</td>";
        $txt .= "<td>".$row['sold']."</td><td>".$row['email']."</td>";
        $txt .= "<td><input type=\"button\" name=\"del\" value=\"DELETE\" onclick=\"".$cal."\"></td></tr>";
 
    $cal = "js_add_key(); return false;";
    $txt .= "<tr><td><input type=\"text\" size=\"46\" id=\"nkey\" /></td><td>".date("Y-m-d")."</td>";
    $txt .= "<td>N</td><td>&nbsp;</td>";
    $txt .= "<td><input type=\"button\" name=\"addkey\" value=\"ADD NEW\" onclick=\"".$cal."\"></td></tr>";
    $txt .= "</table>";
    mysql_close($link);
    return($txt);
 
function p_adm_del_key($key)
{
    $link = dbconnect();
    $sql = "delete from `benkeys` where `keycode`='".$key."' limit 1";
    mysql_query($sql);
    mysql_close($link);
    return(p_adm_list_keys());
}
function p_adm_add_key($key)
{
    $link = dbconnect();
    $sql = "insert into `benkeys` (`keycode`,`datum`,`sold`) values ('".$key."','".date("Y-m-d")."','N')";
    mysql_query($sql);
    mysql_close($link);
    return(p_adm_list_keys());
}
function dbconnect()   
{
    $link = mysql_connect(DBHOST, DBUSER, DBPWD) or die ("Error: ".mysql_error());
    mysql_select_db(DBNAME) or die("Could not select database: ".mysql_error());
    return($link);
}
?>

Code (markup):

I don't get any errors but no table shows please help.

 

You forgot to use
$row=mysql_fetch_assoc($res);

 

Where would I put that?

 

on line number 18.

 

Ok fixed taht but nothing shows on the page

 

Could you export the table in SQL and send it to me? so that I can check locally on my PC.

 

Ill pm you details there's nothing in there to steal rly.

 

Here is the updated code:

<?php
 
$username="root";
$password="";
$database="test";
$host="localhost";
$dbConn = mysql_connect($host, $username, $password, $database)
or die("Could not connect: " + mysql_error());
mysql_select_db($database, $dbConn)
or die("Could not find database: " + mysql_error());
 
 
$txt = "<table align=\"center\">";
    $txt .= "<tr><td>KeyCode</td><td>Date</td><td>Sold</td><td>Email</td></tr>";
    $sql = "SELECT * FROM `benkeys`";
$res = mysql_query($sql, $dbConn)
or die(mysql_error());
while($row=mysql_fetch_assoc($res))
{
        $cal = "js_del_key('".$row["keycode"]."'); return false;";
        $txt .= "<tr><td>".$row['keycode']."</td><td>".$row['datum']."</td>";
        $txt .= "<td>".$row['sold']."</td><td>".$row['email']."</td>";
        $txt .= "<td><input type=\"button\" name=\"del\" value=\"DELETE\" onclick=\"".$cal."\"></td></tr>";
 
    $cal = "js_add_key(); return false;";
    $txt .= "<tr><td><input type=\"text\" size=\"46\" id=\"nkey\" /></td><td>".date("Y-m-d")."</td>";
    $txt .= "<td>N</td><td>&nbsp;</td>";
    $txt .= "<td><input type=\"button\" name=\"addkey\" value=\"ADD NEW\" onclick=\"".$cal."\"></td></tr>";
}
    $txt .= "</table>";
    echo $txt;
   
 
function p_adm_del_key($key)
{
    $link = dbconnect();
    $sql = "delete from `benkeys` where `keycode`='".$key."' limit 1";
    mysql_query($sql);
    mysql_close($link);
    return(p_adm_list_keys());
}
function p_adm_add_key($key)
{
    $link = dbconnect();
    $sql = "insert into `benkeys` (`keycode`,`datum`,`sold`) values ('".$key."','".date("Y-m-d")."','N')";
    mysql_query($sql);
    mysql_close($link);
    return(p_adm_list_keys());
}
function dbconnect() 
{
    $link = mysql_connect('localhost', 'root', '') or die ("Error: ".mysql_error());
    mysql_select_db('test') or die("Could not select database: ".mysql_error());
    return($link);
}
?>

PHP: