RE: [PHP] does this work?

quotes are not needed -----Original Message----- From: Kevin Stone [mailto:kevin@helpelf.com] Sent: Friday, January 11, 2002 3:26 AM To: Erik Price; PHP (E-mail) Subject: Re: [PHP] does this work? 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net