kan ikke finde fejlen
Hey Eksperter...jeg har en strimmel kode her som gerne skulle kunne oprette nogen ting i vhosts men jeg kan ik ret får den ril at skrive til sql'en :-(
håber der er en der lige vil hjælpe mig vidre...
<head>
</head>
<?php
$db = mysql_connect("localhost", "xxxxx", "xxxxxx") or die (mysql_error());
mysql_select_db("domains") or die (mysql_error());
mysql_query("INSERT INTO vhosts(id, domain, docroot) values ($domain','$docroot')");
?>
<form action="<? $PHP_SELF ?>" method="post">
<table border="0" width="100%" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0" cellspacing="0" height="101">
<tr>
<td width="100%" height="16"><font color="000000" face="verdana" size="1">Domain:</font></td>
<td width="100%" height="16" ></td>
</tr>
<tr>
<td width="50%" height="22">
<input type="text" name="domain" size="20" maxlength="20">
</font></td>
</tr>
<tr>
<td width="100%" height="16"><font color="000000" face="verdana" size="1">Docroot:</td>
<td width="100%" height="16" ></td>
</tr>
<tr>
<td width="50%" height="22">
<input type="text" name="docroot" size="20" maxlength="20">
</font></td>
</tr>
<tr>
<td width="50%" height="26">
<input type="submit" value="Opret">
<input type="submit" class="button" name="clear" value="Clear">
<input type="submit" class="button" name="Opdater" value="Opdater"><p>
</tr>
</tabel>
</form>
<tr>
<td width="50%">
<?
$result = mysql_query("select id, domain, docroot FROM vhosts order by id desc LIMIT 0, 13");
while($row = mysql_fetch_array($result)){
echo "
<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border-top: 1px solid #BBB5A5\" bordercolor=\"#111111\" width=\"15%\" height=\"1\">
<tr>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\">$row[id]</td>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\">$row[domain]</td>
<td width=\"35%\" valign=\"top\" height=\"1\">
<font face=\"Verdana\" size=\"1\"> $row[docroot]<br>
</td>
</font></td>
</tr></table>
";
}
?>
