what eact parse error you are getting ? and what is that line ?
Is it giving an error like undefined variable $temprow["count"];
or some thing like that ?
You may try to change the mysql_fetch_row line to the following
$temprow = mysql_fetch_array($tempresult, MYSQL_ASSOC);
----- Original Message -----
From: "Erik Price" <[EMAIL PROTECTED]>
To: "PHP (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 4:28 PM
Subject: [PHP] does this work?
> It seems that I have a "parse error" somewhere in the following code
> (since that's the only code in my script, it's a test script):
>
> // arraytest.php
> $tempsql = "SELECT COUNT(*) AS count
> FROM divisions";
> $tempresult = mysql_query($tempsql, $db);
> $temprow = mysql_fetch_array($tempresult);
>
> echo $temprow["count"];
>
>
> Yet, it works fine in the mysql client. Thus, I am led to believe that
> PHP is not capable of constructing the same kinds of SQL statements that
> can be constructed in the mysql client. Is this the case?
>
>
> Erik
>
>
> PS: what I am -really- trying to do is dynamically fill in a <select>
> listbox with <options> that correspond to all of the records in a given
> table. Like so:
>
> <form>
> <select>
> <?php
> foreach
> ($record_id_and_record_name_pair_pulled_from_mysql_query) {
> print("<option
> value=\"${record_id}\">${record_name}</option>");
> }
> ?>
> </select>
> </form>
>
> but I am unsure of how to grab multiple values from the mysql_query()
> and load them into an array. Has anyone done this before?
>
>
> --
> PHP General 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 General 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]
