upgraded now code wont work, LAST TIME
Posted: Sat Jan 08, 2005 6:40 pm
feyd | Help us, help you. Please use
i think i understand what the problem is i just need to know how to fix it. when there is no $id i get the error message
feyd | Help us, help you. Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
the code is a little redundant i knowCode: Select all
<html>
<body>
<?php
$db = mysql_connect("localhost", "root");
$id = $_GET['id'];
mysql_select_db("test",$db);
// display individual record
if ($id) {
// show employee list
$result1 = mysql_query("SELECT * FROM employees",$db);
if ($myrow = mysql_fetch_array($result1)) {
// display list if there are records to display
echo ("<div align="center">");
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760">");
echo ("<tr>");
echo ("<td width="100%">");
// banner table
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" background="http://pirating.net/bannerbk.jpg">");
echo ("<tr>");
echo ("<td width="100%" height="190"> </td>");
echo ("</tr>");
// main nav
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" bgcolor="#60689F">");
echo ("<tr>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF"><a style="color: #FFFFFF; font-family: Arial; text-decoration: none" href="betahome.php">Home</a></font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Mission</font></td>");
echo ("<td width="20%" align="center" bgcolor="#8C92B9"><font face="Arial" color="#FFFFFF">Bios</font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Services</font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Contact</font></td>");
echo ("</tr>");
// sub nav
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" bgcolor="#8C92B9">");
echo ("<tr>");
do {
printf("<td align="center"><a style="color: #FFFFFF; font-family: Arial; text-decoration: none" href="%s?id=%s">%s</a></td>\n", $_SERVER['PHP_SELF']
, $myrow["id"], $myrow["name"]);
} while ($myrow = mysql_fetch_array($result1));
} else {
// no records to display
echo "Sorry, no records were found!";
}
echo ("</table>");
$result2 = mysql_query("SELECT * FROM employees WHERE id={$_GET['id']}",$db);
$myrow = mysql_fetch_array($result2);
printf("<br><font face="Arial" size="5"> %s\n</font><br><br>", $myrow["name"]);
printf("<font face="arial"> %s\n</font>", $myrow["bio"]);
} else {
// show employee list
$result1 = mysql_query("SELECT * FROM employees",$db);
if ($myrow = mysql_fetch_array($result1)) {
// display list if there are records to display
echo ("<div align="center">");
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760">");
echo ("<tr>");
echo ("<td width="100%">");
// banner table
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" background="http://pirating.net/bannerbk.jpg">");
echo ("<tr>");
echo ("<td width="100%" height="190"> </td>");
echo ("</tr>");
// main nav
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" bgcolor="#60689F">");
echo ("<tr>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF"><a style="color: #FFFFFF; font-family: Arial; text-decoration: none" href="betahome.php">Home</a></font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Mission</font></td>");
echo ("<td width="20%" align="center" bgcolor="#8C92B9"><font face="Arial" color="#FFFFFF">Bios</font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Services</font></td>");
echo ("<td width="20%" align="center"><font face="Arial" color="#FFFFFF">Contact</font></td>");
echo ("</tr>");
// sub nav
echo ("<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="760" bgcolor="#8C92B9">");
echo ("<tr>");
do {
printf("<td align="center"><a style="color: #FFFFFF; font-family: Arial; text-decoration: none" href="%s?id=%s">%s</a></td>\n", $_SERVER['PHP_SELF'], $myrow["id"], $myrow["name"]);
} while ($myrow = mysql_fetch_array($result1));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
</body>
</html>did i mention you can have my first born child?Notice: Undefined index: id in c:\program files\easyphp\www\betabios.php on line 8
feyd | Help us, help you. Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]