I tried that... I get the same error (same line and everything).
As a side note, I haven't ever had to quote the first argument in
mysql_query() before...
This is quite a conundrum, eh?
Erik
On Friday, January 11, 2002, at 04:25 AM, Kevin Stone wrote:
> Hmm I believe that the mysql_query() function requires quotes around the
> query statement even it it is being passed as a variable..
>
> mysql_query("$tempsql", $db);
>
> -Kevin
>
>> 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: php-list-
>> [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]
