[PHP-DB] Re: Dynamic Drop Down Box

2002-03-06 Thread Aron Pilhofer
So, if the user selects mercedes, then the next box is 500Sl, 300Sc and so forth. If they select ford, then the second box has completely different values? You'll either have to reload the page after the first select, or use javascript or some other kind of client script. I don't think there is

[PHP-DB] Re: RC4 encryption with PHP

2002-03-06 Thread bill
Might be late, but here's what I have working. Troy A. Delagardelle wrote: I am trying to encrypt a credit card number using rc4 and php and then dump it into a mySql database. Does anyone have any sample code that allows me to do this?? I found the Class.RC4Crypt algorithm and would like

Re: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Edward Marczak
On 3/5/02 3:34 PM, Leotta, Natalie (NCI/IMS) [EMAIL PROTECTED] wrote: This can be done with JavaScript - I don't know if you can do it in PHP. ...unless the drop-downs are on separate pages. E.g.: page 1 just asks for make, once selected, load up page 2 with choices appropriate to the first

RE: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Leotta, Natalie (NCI/IMS)
If they want two pages they wouldn't need JS though - just submit and use that in your second query to populate drop-down #2. I had assumed that they wanted it on the same page - which is definitely cooler :-) Good point though - I should have asked which way they wanted to do it. I suppose if

Re: [PHP-DB] MySQL_connect

2002-03-06 Thread Josh Trutwin
On Wednesday 06 March 2002 15:53, [EMAIL PROTECTED] wrote: Hi, I'm new to MySql, when I try to connect my PHP-script with mysql_connect($host, $user, $pass) my script returns the error Fatal error: Call to undefined function: mysql_connect() I have given the user all rights in MySQL,

Re: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Paul Burney
on 3/6/02 10:31 AM, Leotta, Natalie (NCI/IMS) at [EMAIL PROTECTED] appended the following bits to my mbox: If they want two pages they wouldn't need JS though - just submit and use that in your second query to populate drop-down #2. I had assumed that they wanted it on the same page - which

[PHP-DB] php mssql* functions

2002-03-06 Thread Jeremy Reed
Because of the limitations of MS SQL Server and the inability to limit result sets as you are in MySQL, I am having to finesse/brute force a method to peruse through large result sets. My question is this: How exactly does the mssql_fetch_array() function work? Does it make a call to the db

Re: [PHP-DB] 2 mysql connections to same server?

2002-03-06 Thread William Fong
I've never tried this before, but couldn't you use $db1 = mysql_connect(); and $db2 = mysql_connect();? -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED] - Original Message - From: Tom

[PHP-DB] I have a in my db ?

2002-03-06 Thread Dave carrera
Hi All I think this has something to do with either Stripslashes or Addslashes but which one. And where do I use it. I have a product that has a in the name and I have created a drop down list from the names. I cant get it to reg the name. all it reg is 15 instead of th full name

[PHP-DB] Secure PHP to remote Sybase server

2002-03-06 Thread Dennis Khaw
Hi Everyone, This is the setup: A front-end Sun Solaris 8 server running Apache and mod php. A second server running Solaris 8 and Sybase. Clients with a web browser connects to the front-end server and submit a query. Apache/php then opens a remote connection to Sybase on the second server

Re: [PHP-DB] Secure PHP to remote Sybase server

2002-03-06 Thread William Fong
We were discussing this issue over in #php at irc.openprojects.net. I wasn't there for the whole conversation, but what was discussed was that there was no built-in encryption and that the only way to achieve this was with an SSL tunnel What I have done with MySQL is setup a user that can only

[PHP-DB] Bindbyname error in solaris

2002-03-06 Thread Mohammad Saad
Hello I have PHP4.10 on solaris with oci8 support. everything seems to work well. Oracle support is working fine. but I am getting an error when I am trying OCIBindByName to bind a variable to an out variable of a stored procedure. I have checked this code on php4.10 on windows 2k with same

Re: [PHP-DB] Re: Dynamic Drop Down Box

2002-03-06 Thread fls
I've got a dynamic dropdown on http://www.northjerseydirectories.com I generate the js using php and a MySQL database. The dropdown does what you're looking for. Since the dropdown is client side you either need to go with javascript, an applet, or have the person submit a form that loads the

RE: [PHP-DB] I have a in my db ?

2002-03-06 Thread Gurhan Ozen
Hi, Can u please give us more information?? Are you trying to insert data into database or pull data out of database.. Also can you show the queries you are using??? Thanks, Gurhan -Original Message- From: Dave carrera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:38 PM

[PHP-DB] records into an editable box

2002-03-06 Thread jas
How would I change this sql statement to pull the db table and display it within an editable box within a form? Any help or tutorials would be great. ?php $result = mysql_query(SELECT $table FROM $field,$dbh) or die(Could not execute query, please try again later); echo Btext:/Bbr\n;

Re: [PHP-DB] records into an editable box

2002-03-06 Thread Dan Brunner
Hello!! Do you mean a textarea?? And you want to populate the textarea with the data, right? Dan On Wednesday, March 6, 2002, at 01:34 AM, [EMAIL PROTECTED] wrote: How would I change this sql statement to pull the db table and display it within an editable box within a form? Any help

Re: [PHP-DB] records into an editable box

2002-03-06 Thread jas
No dan I mean textbox... but I am assuming you dont have any idea where a good tutorial would be then. Thanks anyways. Jas Dan Brunner [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello!! Do you mean a textarea?? And you want to populate the textarea with

RE: [PHP-DB] records into an editable box

2002-03-06 Thread Shrock, Court
do you mean something like: ?php $record = mysql_fetch_array(mysql_query(SELECT $table FROM $field,$dbh)); echo Text: input type='text' name='some_name' value=\{$record['wel_area']}\br\n; ? of course, the output above would need to be inside an html form. -Original Message- From: jas

[PHP-DB] Difficulty on how to extract data out of a text with string functions.

2002-03-06 Thread Andy
Hi there, I want to include some data into my website which covers malaria and yellow feewer related to each country. On the WHO website are all the infos I need. Their webmaster told me that unfortunatelly there is no db behind that and everything gos with html files. But I am free to extract

[PHP-DB] Re: [PHP] Difficulty on how to extract data out of a text with string functions.

2002-03-06 Thread Erik Price
On Wednesday, March 6, 2002, at 01:49 PM, Andy wrote: I want to include some data into my website which covers malaria and yellow feewer related to each country. To each his own, I suppose... Now I have a table in a MySQL db naming all those countries. The goal is to extract the

RE: [PHP-DB] Difficulty on how to extract data out of a text withstring functions.

2002-03-06 Thread Gurhan Ozen
Yeah it is getting really off the topic i will email you in private.. :) Gurhan -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:28 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Difficulty on how to extract data out of a text

[PHP-DB] OCI8 issue (and some apc too): configure bugs?

2002-03-06 Thread Diego Francisco de Gastal Morales
Hello all, I've read several messages and articles about php/oci8 combination, but I still have some issues not resolved. On this system: Debian (stable), PHP 4.0.6, Oracle 8.1.7, Apache 1.3.9-14, I compile php like this: #Begin ORACLE_HOME=/oracle/product/8.1.7 ./configure \