[PHP-DB] Re: Firebird and PHP

2004-11-19 Thread Lester Caine
Mario Lacunza wrote: Is possible work with Firebird ? and how? Perfectly possible. Just use the ibase_* functions. Windows or Linux Old windows getting started is at http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_beginners_php Help with linux can be found on the firebird-php list

Re: [PHP-DB] password encryption

2004-11-19 Thread php_user
Han, You can try installing mcrypt, it gives you encryption/decryption capabilities in PHP. It's fairly easy to install in you're running a Windows system; I think you have to recompile php if your on a Linux system, and I have never been able to successfully do that. You might look into it

Re: [PHP-DB] password encryption

2004-11-19 Thread Han
Thanks to evryone for their help. Haven't done it yet as I'm working on someone else's server and they won't do certain things. I've got all the info I was lacking now, so I'm sure I can work something out. Han. - Original Message - From: php_user [EMAIL PROTECTED] To: Han [EMAIL

[PHP-DB] Updating count on record results

2004-11-19 Thread Stuart Felenstein
I am setting up a table to log a count on individual records for every time they are returned in a results return. Just so to illustrate Record1 First search brings up Record1 (counter is set too 1) Second search brings up Record1 (counter is set too 2) Third search brings up Record1 (counter

RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Bastien Koert
this is how I did it for a client's site // update the number of times the vehicle has been viewed mysql_db_query($dbname, UPDATE vehicle_inventory SET viewed=viewed+1 WHERE ccode='$ccode', $link); bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Updating

RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Stuart Felenstein
--- Bastien Koert [EMAIL PROTECTED] wrote: this is how I did it for a client's site // update the number of times the vehicle has been viewed mysql_db_query($dbname, UPDATE vehicle_inventory SET viewed=viewed+1 WHERE ccode='$ccode', $link); Where did this code go though ? Meaning, was

RE: [PHP-DB] Updating count on record results

2004-11-19 Thread Bastien Koert
its a separate query on the same page, its activated after the data retreival query runs. ? ... // get the information for this vehicle $result = mysql_db_query($dbname, SELECT * FROM vehicle_inventory WHERE ccode='$ccode', $link); $data = mysql_fetch_array($result); $data[comments] =

[PHP-DB] Cisco UBR interface with PHP

2004-11-19 Thread Doug Finch
I have an idea that I wanted to throw out there. I have a cable ISP plant that I am trying to help with a project. They are using Cisco 7114 UBRs to connect their cable modems with their Internet backbone - this device assigns it a dhcp address and associates it with the modems MAC address. It

[PHP-DB] Question on FilesSessions

2004-11-19 Thread Kathy_A_Wright
Can you hold a file in a session? I am trying to send a file to a third page and it won't seem to work sending it in a session. Does anyone know how to do this? Thanks Kathy A Wright | Keane Inc. | Suite: Outside: 617-517-1706 | E-mail: [EMAIL PROTECTED] [ Mailing: 100 City Sq.

RE: [PHP-DB] Question on FilesSessions

2004-11-19 Thread Gryffyn, Trevor
How are you storing the file in your PHP code? If it'll fit in a variable, it should be able to be stored in $_SESSION. This might mean using serialize() and unserialize(). Although someone may have a better way of doing this. It seems to me that storing an entire file in a variable is going

[PHP-DB] array messing up

2004-11-19 Thread Rainer Bendig aka Ny
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i don't know if this is the right list to post it, or php-general... I am posting here because i think its database related. so here we go: I want to build an array containing two arrays $navm[] and $navs[], $navs[] should go to $navm[items].

[PHP-DB] Currency and number types...

2004-11-19 Thread Mark Benson
I'm trying to display data calculated by my script as a currency. The problem I have is that PHP is treating the results of the math as a 'float' number (or 'double') so I am getting results like: 12.0594393 in my table. I have tried using: print round($foobar,2) but that cuts off the

RE: [PHP-DB] Currency and number types...

2004-11-19 Thread Gryffyn, Trevor
You might try this: http://us2.php.net/manual/en/function.money-format.php Money_format() In your database query, you can probably format the number how you want there too... Before you even get to PHP and round()ing it inside PHP. But do your math and using the money_format() function to

RE: [PHP-DB] Currency and number types...

2004-11-19 Thread Gryffyn, Trevor
Either way. :) -Original Message- From: Joseph Crawford [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 12:48 PM To: Gryffyn, Trevor; [PHP-DB] Mailing List Subject: Re: [PHP-DB] Currency and number types... how about good old number_format() -- Joseph Crawford

RE: [PHP-DB] Currency and number types...

2004-11-19 Thread Bastien Koert
number_format() is what you need look it up bastien From: Mark Benson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Currency and number types... Date: Fri, 19 Nov 2004 17:35:53 + I'm trying to display data calculated by my script as a currency. The problem I have is that PHP is

RE: [PHP-DB] Question on FilesSessions

2004-11-19 Thread Bastien Koert
Better to save the file locally, the pass the name in a session variable. otherwise the overhead of holding a multi Kb or Mb file will be killer on the system. What are you trying to do with the file? Bastien From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Question on

Re: [PHP-DB] password encryption

2004-11-19 Thread Bastien Koert
You need to understand how the htaccess file and its passwords are created. using mcrypt will likely lead to problems. htaccess passwords are encrypted with DES algorithm [quote http://www.edevcafe.com/viewdoc.php?eid=97] If you wanted to write a CGI script to help you add/delete users from

[PHP-DB] Optimize Query Output

2004-11-19 Thread GH
I have the following query: SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present` FROM `Attendance` A, Sessions S, Participants P WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant` GROUP BY P.LastName, P.FirstName, A.Present, A.AttID I would like to have the