[PHP-DB] Help Me Please ... it's urgent !!

signup Tue, 23 Jan 2001 05:54:44 -0800
Hi ...

My name is Dedy Wahyudi ...

I follow your instruction at webmonkey site regarding PHP/MySQL Tutorial ..

But there is some problem i'm having ... may be you can tell me  ....

<? 
$connect= mysql_connect("localhost","root")
or die ("Can not established a connection to Localhost !!!");
mysql_select_db ("data");
if ($comp) {
$cari="SELECT * FROM admin WHERE company=$comp";
$hasil=mysql_query($cari);
while ($row=mysql_fetch_array($hasil)) {
print "<tr><td valign='top' nowrap colspan='5'><font size='2'></font><font 
size='2'></font><font size='2'></font><font size='2'></font><font 
size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap>&nbsp;</td><td width='153' valign='top' 
nowrap bgcolor='#33CCCC'><font size='2'>&nbsp;<b>Type of Service</b></font></td><td 
width='10' valign='top' nowrap bgcolor='#33CCCC'><div align='center'><font 
size='2'><b>:</b></font></div></td><td width='277' valign='top' 
bgcolor='#33CCCC'><b>".$row['type']."</b></td><td width='5' valign='top' 
nowrap>&nbsp;</td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font size='2'>&nbsp;Company 
Name</font></h3></td><td width='10' valign='top' nowrap bgcolor='#33CCCC'><h3 
align='center'><font size='2'>:</font></h3></td><td width='277' valign='top' 
bgcolor='#33CCCC'><font size='2'><b>".$row['company']."</b></font></td><td width='5' 
valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font size='2'>&nbsp;Contact 
Person</font></h3></td><td width='10' valign='top' nowrap bgcolor='#33CCCC'><h3 
align='center'><font size='2'>:</font></h3></td><td width='277' valign='top' 
bgcolor='#33CCCC'><font size='2'><b>".$row['person']."</b></font></td><td width='5' 
valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Title</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'><font size='2'><b>".$row['title']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Department</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'><font size='2'><b>".$row['dept']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Phone</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'><font size='2'><b>".$row['phone']."</b>&nbsp; 
Ext.&nbsp;<b>".$row['ext']."</b></font></td><td width='5' valign='top' nowrap><font 
size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Fax</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'><font size='2'><b>".$row['fax']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font size='2'>&nbsp;Cellular 
Phone</font></h3></td><td width='10' valign='top' nowrap bgcolor='#33CCCC'><h3 
align='center'><font size='2'>:</font></h3></td><td width='277' valign='top' 
bgcolor='#33CCCC'><font size='2'><b>".$row['cel']."</b></font></td><td width='5' 
valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Address</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'><p><font 
size='2'><b>".$row['address1']."</b><br><b>".$row['address2']."</b><br></font></p></td><td
 width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;City</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'> <font size='2'><b>".$row['city']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Postcode</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'> <font size='2'><b>".$row['post']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font size='2'>&nbsp;E-Mail 
Address</font></h3></td><td width='10' valign='top' nowrap bgcolor='#33CCCC'><h3 
align='center'><font size='2'>:</font></h3></td><td width='277' valign='top' 
bgcolor='#33CCCC'> <font size='2'><b>".$row['email']."</b></font></td><td width='5' 
valign='top' nowrap><font size='2'></font></td></tr>";
print "<tr><td width='5' valign='top' nowrap><font size='2'></font></td><td 
width='153' valign='top' nowrap bgcolor='#33CCCC'><h3><font 
size='2'>&nbsp;Note</font></h3></td><td width='10' valign='top' nowrap 
bgcolor='#33CCCC'><h3 align='center'><font size='2'>:</font></h3></td><td width='277' 
valign='top' bgcolor='#33CCCC'> <font size='2'><b>".$row['note']."</b></font></td><td 
width='5' valign='top' nowrap><font size='2'></font></td></tr>";
}
} 
else {
$query = "SELECT company FROM admin WHERE TYPE='IWL/IDL'";
$result = mysql_query($query);
echo "<form name='jumpiwl2'>";
echo "<select name='comp' onChange='MM_jumpMenu('self',this,0)' size='1'>";
echo "<option selected >-- Choose the Company --</option>";
while ($rows = mysql_fetch_array($result)) {
printf ("<option value=\"%s?comp=%s \">%s</option>", $PHP_SELF, $rows["company"], 
$rows["company"]);
}
echo "</select>";
echo "</form>"; 
}
?>

Whenever i run this script, it always said that :

Warning: Undefined variable: comp in c:\homepage\viewadmiwl.php on line 28


which is mean that variable $comp is not recognize ...

Could you tell me what when wrong ??? coz I really need this thing working as soon as 
possible ...

Thank you very much for your attention ..

Regards,

Dedy Wahyudi





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Help Me Please ... it's urgent !!

Reply via email to
