Hi John,

Considering that I don't have MySql installed here and therefore can't test
your code, I'm going to guess that the msql_fetch_array is not storing the
array as per the indexes that you want. Try using MYSQL_ASSOC or MYSQL_BOTH
as the second parameter. MYSQL_ASSOC causes the elements to be indexed by
field names and MYSQL_BOTH FORCES the indexes to be stored both ways. It may
be possible that your default is setup to MYSQL_NUM and that would be why
you're getting an error.

Try:
    $myrow = mysql_fetch_array($result,MYSQL_ASSOC);

Hope this helps.
Later,
Jorge
[EMAIL PROTECTED]
----- Original Message -----
From: John Halladay <[EMAIL PROTECTED]>
To: 'Jorge Santos' <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 1:11 PM
Subject: RE: [PHP-DB] Undefined Variable and argument not valid . . .


> Great!  That fixed the first error, but I'm still getting the other error
on
> the second page stating:
>
> Warning: Supplied argument is not a valid MySQL result resource in
> C:\Inetpub\wwwroot/maybe.php on line 15
> Company Name:
> Contact:
> Phone Number:
>
> Here is line 15:
>
> $myrow = mysql_fetch_array($result);
>
> Any ideas?  Thanks again for your help.
>
> John
>
> -----Original Message-----
> From: Jorge Santos [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 11:05 AM
> To: John Halladay
> Cc: PHP-DB
> Subject: Re: [PHP-DB] Undefined Variable and argument not valid . . .
>
>
> Hi  John,
>
> You're trying to use a variable that is not set. Try using the isset
> function... Like this:
>
> if (isset($COCOD))
>     $result = mysql_query("SELECT * FROM tblAA_MIKER_COMPDAT WHERE
>     COCOD=$COCOD",$db);
>
> Hope this helps...
> Later,
> Jorge
> [EMAIL PROTECTED]
> ----- Original Message -----
> From: John Halladay <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, February 14, 2001 12:51 PM
> Subject: [PHP-DB] Undefined Variable and argument not valid . . .
>
>
> > 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
> > 11
> >
> > 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:
> > Contact:
> > Phone Number:
> >
> >
> > <html>
> >
> > <body>
> >
> > <?php
> >
> > $db = mysql_connect("localhost", "root", "*******");
> >
> > mysql_select_db("schedules",$db);
> >
> > if ($COCOD) {
> >
> > $result = mysql_query("SELECT * FROM tblAA_MIKER_COMPDAT WHERE
> > COCOD=$COCOD",$db);
> >
> > $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"],
> > $myrow["CONAM"]);
> >
> > } while ($myrow = mysql_fetch_array($result));
> >
> > } else {
> >
> > echo "Sorry, no records were found!";
> >
> > }
> >
> > }
> >
> > ?>
> >
> > </body>
> >
> > </html>
> >
> > Thanks.
> >
> > John Halladay
> >
> > --
> > 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 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]

Reply via email to