Could someone please give me some direction on what is wrong with what I am
trying to do below.  I've checked it over but still get the same errors.
What I'm trying to do is have a list of links that display information when
you click them.

I'm getting the following error at the top of the first page where all the
links are displayed.
Warning: Undefined variable: COCOD in C:\Inetpub\wwwroot/maybe.php on line

I'm getting this error when I click on one of the links and there is no info
displayed under the three listing below.
Warning: Supplied argument is not a valid MySQL result resource in
C:\Inetpub\wwwroot/maybe.php on line 15
Company Name: 
Phone Number: 




$db = mysql_connect("localhost", "root", "*******");


if ($COCOD) {

$result = mysql_query("SELECT * FROM tblAA_MIKER_COMPDAT WHERE

$myrow = mysql_fetch_array($result);

printf("Company Name: %s\n<br>", $myrow["CONAM"]);

printf("Contact: %s\n<br>", $myrow["Contact"]);

printf("Phone Number: %s\n<br>", $myrow["PhoneNumber"]);

} else {

$result = mysql_query("SELECT * FROM tblAA_MIKER_COMPDAT",$db);

if ($myrow = mysql_fetch_array($result)) {

do {

printf("<a href=\"%s?COCOD=%s\">%s</a><br>\n", $PHP_SELF, $myrow["COCOD"],

} while ($myrow = mysql_fetch_array($result));

} else {

echo "Sorry, no records were found!";   







John Halladay

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to