[PHP-DB] passing parameter to function

2004-02-26 Thread Robbie Staufer
x27; on to another script as a hidden value in a form using the POST method. The other script is not receiving the value of $codename. Thanks for any help. Robbie -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Robbie Staufer NCAR/SCD 1850 Table Mesa Dr. Rm. 42 Boulder, CO. 80305 (303

Re: [PHP-DB] passing parameter to function

2004-02-26 Thread Robbie Staufer
hins, Richard wrote: Script 1: ...other form stuff as necessary... Submit the form. Script 2: Access the data passed in the hidden field as $_POST["codename"]. For example, echo $_POST["codename"]; Rich -Original Message- From: Robbie Staufer [mailto:[EMAIL

[PHP-DB] looking for a variable

2004-05-06 Thread Robbie Staufer
Hi, In a statement like: $result = mysql_query ("SELECT * FROM testdb WHERE Code_Name IN ('CLM', 'CAM', 'CSIM', 'cpl5', 'POP')",$connection) is there a php variable that holds the number of elements in the () after IN? Thanks, Robbie --

Re: [PHP-DB] looking for a variable

2004-05-06 Thread Robbie Staufer
I'm formatting the display in a browser window. I need the second and consecutive elements to be indented below the first one. Something like this: echo "element 0" foreach additional element echo "tab","element" Thanks, Robbie Bruno Ferreira wr

Re: [PHP-DB] looking for a variable

2004-05-06 Thread Robbie Staufer
I supply those values. Data associated with them gets pulled out of the database and I need to format them so that the first one is displayed differently than the following ones. thanks, Robbie John W. Holmes wrote: From: "Robbie Staufer" <[EMAIL PROTECTED]> $result = mysq

Re: [PHP-DB] looking for a variable

2004-05-06 Thread Robbie Staufer
Thanks, Robbie John W. Holmes wrote: From: Robbie Staufer I supply those values. Data associated with them gets pulled out of the database and I need to format them so that the first one is displayed differently than the following ones. Oh... echo "CLM, CAM, CSIM, cpl5, POP"

[PHP-DB] variable within regular expression

2003-04-04 Thread Robbie Staufer
$_GET['usr-input']; $var = '%$var%'; SELECT * FROM table WHERE field LIKE $var. I can't find the right syntax to make this work. Does anyone know? Thanks, Robbie Staufer -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Robbie Staufer NCAR/SCD 1850 Table Mesa

[PHP-DB] update db with variables

2003-09-24 Thread Robbie Staufer
ek. Does anyone have any suggestions? Many thanks, Robbie -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Robbie Staufer NCAR/SCD 1850 Table Mesa Dr. Rm. 42 Boulder, CO. 80305 (303) 497-1836 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] update db with variables

2003-09-24 Thread Robbie Staufer
Thanks to all. Single quotes around '$value' did the trick. Robbie CPT John W. Holmes wrote: From: "Robbie Staufer" <[EMAIL PROTECTED]> I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number.

[PHP-DB] query for multiple values

2003-10-15 Thread Robbie Staufer
Hi, Is there a way to construct a mysql query that will select * for multiple values in the same column? For example: "SELECT * FROM table WHERE column = 'this' and 'that' and 'theother'" Thanks, Robbie -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-