I told you it was something stupid! That was it. Thank you. Its good to be
able to bounce this stuff off of someone. I'm surprised that doesn't
generate a parse error. Sometimes we just get so wrapped up in it, that it
takes another set of eyes to see the forest for the trees.
Curtis
----- Original Message -----
From: "Jason Beebe" <[EMAIL PROTECTED]>
To: "Curtis Maurand" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 1:57 AM
Subject: RE: [PHP-DB] Something Stupid
> drop the ; from the while. it is not parsing anything within the scope of
> the while loop because there is a ; saying the while loop ends w/o doing
> anything.
>
> -----Original Message-----
> From: Curtis Maurand [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 9:39 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Something Stupid
>
>
> I have got to be doien something stupid.
>
> consider the following code.
> hosts, usernames and passwords have been changed to protect the innocent.
>
> <?
> $mysql_link =
> mysql_connect("myhost.domain.com","some.user","some.password "
> $myquery = "select car_no,drv_name from cars order by car_no + 0";
> $myresult = mysql_db_query("topten", $myquery, $mysql_link);
> while($rows = mysql_fetch_array($myresult));
> {
> print("$rows[0]<br>\n");
> }
> ?>
>
> I get no output and no errors. I use code almost identical to this all
over
> the place, yet this one doesn;t work.
> I've tried just a bare qery and I still get nothing. the connection is
> working as we can see from the log entry below. At this point, I'm lost.
> If the technique I'm using is considered bad practice, I'm open to
> suggestions. My code would normally print out a table, but for the sake
of
> trouble shooting, I reduced it to this which should print a single column
of
> numbers.
>
> Anyone have any ideas?
>
> the mysqld.log records the query.
>
> 010206 22:59:55 310 Connect [EMAIL PROTECTED] on
> 310 Init DB topten
> 310 Query select car_no, drv_name from cars order
> by car_no + 0
> 310 Quit
>
>
--
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]