2 errors occure.
Script;Notice: Undefined index: Paqnr in c:\apache\htdocs\retrieve.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\apache\htdocs\retrieve.php on line 33
Code: Select all
// formulario, solo pone el codigo paquete
ECHO <<<HTML
<html>
<head>
<body class="v">
<form name="retrieve" action={$_SERVER['PHP_SELF']} method="GET" class="center">
<table width="250" border="0" class="center" cellpading="3">
<tr>
<td>
<div class="center"><b>Required information?</b></div>
</td>
</tr>
Enter Paq. number:<input type="Paqnr" name="paqnr">
<br>
<Div class="r"><input name="Paqnr" type="submit" ID="Paqnr" WIDTH="5"
CLASSID="CLSID:B6FC3A14-F837-11D0-9CC8-006008058734"></div>
HTML;
// connectarse con el base datos.
$dbase ="home";
$tablename ="pongo";
$connect= mysql_connect('localhost')
or die("Cant connect: " .mysql_error());
// consultar el tabla pongo
$query = "SELECT * FROM pongo WHERE Paqnr='" .$_GET['Paqnr']. "'"; //line 31 ( i also tried ='" .$paqnr. " ' ";
$result = mysql_query($query);
if($row = mysql_fetch_array($result)) // line 33
{
echo "<tr class="V"> ";
echo "<td width="100" class="v"> ";
echo "<div class="r">Numero Paquete</div> ";
echo "</td>\n ";
echo "<td width="150"> ";
echo $row['Paqnr'];
echo " </td>\n ";
echo " </tr>\n ";
and so On......
}
?>What am i doing wrong.