PHP doesn't read

phpdesp

Hi,

I got this code:

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<form>
<form action="add.php"method="GET">
<select name="qtable">

<?php

$dbname = 'ii';
if (!mysql_connect('localhost', 'root', 'NULL')) {
    print 'Could not connect to mysql';
    exit;
}

$result = mysql_list_tables($dbname);

if (!$result) {
    print "DB Error, could not list tables\n";
    print 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    print "Table: $row[0]\n";
}

mysql_free_result($result);

?>

</select>
</form>

</body>
</html>

And the prob is that php doesn't parse it.. I just get the page without anything on it (except the empty form which is not php code). What have I missed? I bet something really stupid..

planetsim

Firstly have you got tables in your database.

secondly.. You have the <form> tag called twice

<form>
<form action="add.php"method="GET">
<select name="qtable">

planetsim

Also i missed this

<?php 

$dbname = 'ii'; 
if (!mysql_connect('localhost', 'root', 'NULL')) { 
    print 'Could not connect to mysql'; 
    exit; 
} 

$result = mysql_list_tables($dbname); 

if (!$result) { 
    print "DB Error, could not list tables\n"; 
    print 'MySQL Error: ' . mysql_error(); 
    exit; 
} 

while ($row = mysql_fetch_row($result)) { 
    print "<option value=\"".$row[0]."\">Table: ".$row[0]."</option>\n"; 
} 

mysql_free_result($result); 

?>

phpdesp

I corrected all of that... it still gives me nothing.

and yes I do have tables.

phpdesp

Ok... stupid thing. There were '''s around the NULL in the password.

phpdesp

Thanks for the help.