gadenavne / sal / side formel output problem
Jeg har indsat følgende i en database :---------------------
(id, 'gadenavn', 'forkortelse af gade',' nr',' side')
----------------------
(1, 'A.D. Jørgensens Vej', 'adj', '1', 'sth');
(2, 'Acaciavej', 'acv', '2', 'stm');
(3, 'Adilsvej', 'adv', '3', 'stv');
(4, 'Adolph Steens Alle', 'asa', '4', '1th');
(5, 'Ahornskellet', 'ahs', '5', '1mf');
(6, 'Aksel Møllers Have', 'amh', '6', '1tv');
(7, 'Alhambravej', 'alv', '7', '2th');
(8, 'Allegade', 'alg', '8', '2mf');
(9, 'Amalievej', 'amv', '9', '2tv');
(10, 'Amicisvej', 'aiv', '10', '3th');
(11, 'Andebakkesti', 'abs', '11', '3mf');
(12, 'Ane Katrines Vej', 'akv', '12', '3tv');
(13, 'Arveprinsensvej', 'apv', '13', '4th');
(14, 'Asgårdsvej', 'agv', '14', '4mf');
(15, 'Askeskellet', 'ast', '15', '4tv');
(16, 'Asmussens Alle', 'asa', '16', '5th');
-----------------------
jeg har forsøgt at sætte en html formel op hvis jeg sige Gade : andebakkesti gadeid = 1
Nr : 30 nr = 30
Side : 1th side = 4
men den kommer med et output der hedder abs113mf, men den skulle jo hedde abs301th.
Mysql formel
<?
mysql_connect("localhost", "root","password");
mysql_select_db("gader");
$query = mysql_query("select * from gadenavne WHERE gadeid = '$gadeid'");
while ($row = mysql_fetch_array($query))
{
$gadeid = $row["gadeid"];
$gadenavn = $row["gadenavn"];
$subid = $row["subid"];
$nr = $row["nr"];
$side = $row["side"];
echo"<center><table cellpadding='0' cellspacing='0' border='0' width='100%' bgcolor='#FFFFFF'>";
echo"<tr>";
echo"<td>";
echo"<center><table cellpadding='0' cellspacing='0' border='0' width='100%'>";
echo"<tr>";
echo"<td>";
echo"<h3>Dit Sub Domain er $subid $nr $side</h3>";
echo"<br>";
echo"<form action=\"opret.php\" method=\"post\">";
echo"<input type=\"hidden\" name=\"navn\" value=\"$subid $nr $side\">";
echo"<br>";
echo"<tr><td><font size=\"2\" face=\"Verdana\">Din nuværende e-mail adr.: </font></td>";
echo"<td><input type=\"text\" name=\"email\" size=\"20\"></td>";
echo"</tr><tr>";
echo"<td><font size=\"2\" face=\"Verdana\">Password: </font></td>";
echo"<td><input type=\"password\" name=\"password\" size=\"20\" maxlength=\"10\"></td>";
echo"</tr><tr>";
echo"<td><font size=\"2\" face=\"Verdana\">Password (igen):</font></td>";
echo"<td><input type=\"password\" name=\"pass2\" size=\"20\" maxlength=\"10\"></td>";
echo"</tr><tr><td></td>";
echo"<td><input type=\"submit\" value=\"Gem\"></td>";
echo"</tr></table>";
}
?>
