[PHP-DB] ODBC Query max()

2003-03-12 Thread Squirrel User
I'm trying to extract one record that has largest sequence ID number for an employee, so I've tried below but doesn't work. Help. $mQuery = EmployeeID = '$user'; $mCur = odbc_exec( $mCnx, select ID=max(ID),Date,TimeIn,TimeOut,StationIP from Clocks where $mQuery );

[PHP-DB] Receiving ARRAY from Forms

2003-02-20 Thread Squirrel User
I tried the following code but all I get back is Array. I'm trying to pass a huge array. ? if( isset( $submit ) ) { echo array list:br; print_r( $eList ); $submit = ; } else { $mList = array(); $mList[0] = 1. hello; $mList[1] = 2. there;

Re: [PHP-DB] Help with ADDUSER from linux

2003-02-18 Thread Squirrel User
adduser script is written in perl. You can easily disect it. Quoting Bruno Pereira [EMAIL PROTECTED]: How can i create a new user, with linux, apache and php? Like this, in a form i ask for the username and password, than somehow use the 'adduser' username password confirm password. Can

[PHP-DB] Passing ARRAY through URL

2003-02-07 Thread Squirrel User
Help. I've tried to pass large array through URL but it keep telling me page can not be displayed: ? // page1.php $mList = arrary(); ...// fill array with values $mList = urlencode( serialize( $mList ) ); header( location: page2.php?mL=$mList ); ? ? // page2.php $mList = stripslashes(

Re: [PHP-DB] $_FILES missing path

2003-02-06 Thread Squirrel User
I searched for PHP script for selecting a file, but couldn't find small simple ones. Well, I could write a script using opendir() and link a url to each. Geez, but I was hoping that someone has already done that... Quoting Squirrel User [EMAIL PROTECTED]: form method=POST action=$PHP_SELF

RE: [PHP-DB] odbc query with single quote in string

2003-02-05 Thread Squirrel User
The 1st one didn't work, but the 2nd one did work. Fantastic! Thanks alot, you saved me from frustrations. Quoting John W. Holmes [EMAIL PROTECTED]: I'm having problem querying a table with a field value containing an appostropy, please help. Using ODBC to connect MSAcess database.

[PHP-DB] odbc query with single quote in string

2003-02-04 Thread Squirrel User
I'm having problem querying a table with a field value containing an appostropy, please help. Using ODBC to connect MSAcess database. $mQuery = CustomerID='$mCust'; $mCur2 = odbc_do( $mCnx, select Login from Emails where $mQuery ); When it hits O'Donald, James, I get error in