I think it will really help if you post more of your code. It is obvious
that the parse error is not contained within the lines of code that you
pasted :) I think more of your code will reveal the answer rather quickly
:)
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 X289
[EMAIL PROTECTED]
----- Original Message -----
From: "Erik Price" <[EMAIL PROTECTED]>
To: "Kevin Stone" <[EMAIL PROTECTED]>
Cc: "PHP (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 4:43 PM
Subject: Re: [PHP] does this work?
> 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]
>
--
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]
