Re: [PHP-DB] MySQL_connect

2002-03-06 Thread Jason Wong
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 MyS

Re: [PHP-DB] how to make multiple in a coloum in mysql DB

2002-03-06 Thread Markus Lervik
On Wed, 2002-03-06 at 10:02, Yoga Anak Medan wrote: > salam, > i'm make a database in mysql, example : > namescore Ascore A Total > john 7890 > mike 9070 > etc... > ask me is: > how to make multiple or total in coulum "Total" > oto

Re: [PHP-DB] how to make multiple in a coloum in mysql DB

2002-03-06 Thread DL Neil
Yoga, wa aleikum as-salaam (tr: greetings returned to you) > salam, > i'm make a database in mysql, example : > namescore Ascore A Total > john 7890 > mike 9070 > etc... > ask me is: > how to make multiple or total in coulum "Total"

[PHP-DB] Re: [PHP] timestamp iin MySQL not compatible to the one in PHP???

2002-03-06 Thread DL Neil
Hi Andy I apologise. The way I wrote the suggestion looks very much like a SQL query doesn't it? It wasn't! It would have been better expressed if I had said: retrieve the MySQL timestamp field as a UNIX (epoch) timestamp, by using the UNIX_TIMESTAMP function within the SELECT statement > I trye

RE: [PHP-DB] MSSQL2000

2002-03-06 Thread Andrew Hill
Mike, You can certainly use ODBC. The drivers are already present on your system; just configure a System DSN. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server > -Original Message---

Re: [PHP-DB] addslashes needed for db security? Hack proving webapps

2002-03-06 Thread Aron Pilhofer
> Paul > > while ($self != "asleep") { > $sheep_count++; > } > ?> I have nothing useful to add, except that I nearly spit up my morning coffee laughing at your signature. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: multiple select statements

2002-03-06 Thread Aron Pilhofer
There are even easier ways to do it than that... using if statements. so, start with something like this: $query.="select "; then let's say you have a buch of clickboxes which your user can check which will construct your select statements, so, if ($clickbox1="") { $query.=""; } if ($clickbox

[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

[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 woul

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 fir

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 rig

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 - whic

[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 ser

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 nam

[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 usin

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 l

[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 da

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 se

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. text:\n"; printf(mysql_result($result,"wel_area")); ?> Thanks in advance, Jas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

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

2002-03-06 Thread Bill Morrow
I haven't actually tried this, but if you use frames, could you submit from the first dropdown and refresh the second if they are in seperate frames? Not that I'd like to support that code. On Wed, Mar 06, 2002 at 10:14:59AM -0800, fls wrote: > I've got a dynamic dropdown on http://www.northjers

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 h

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 "texta

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

2002-03-06 Thread Shrock, Court
do you mean something like: \n"; ?> of course, the output above would need to be inside an html form. > -Original Message- > From: jas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 11:35 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] records into an editable box > > > How

[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 th

[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
Hi Andy, The little snippet you showed from the text file made me think that the data layout for each country is not consistent. For example: For Algeria there is the country name and right underneath goes the info about yellow fever and malaria as opposed to American Samoa where underneath the c

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

2002-03-06 Thread Andy
Hello Gurhan, thanx for your help. You are right, the file is not consistent. But some things are. For example that every line contains one data set and that every line begins with the name of the column I would like to have followed by a : I could yous win32, linux rh72 and osx to do this. 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 w

RE: [PHP-DB] Dynamic Drop Down Box

2002-03-06 Thread Boaz Yahav
There are several examples on http://www.weberdev.com. Look in the Java Script area. Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002

[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 \ --prefix

[PHP-DB] Re: php-db Digest 6 Mar 2002 16:43:13 -0000 Issue 1086

2002-03-06 Thread Robin L. Small
RE the Dynamic Dropdown.. the javascript I've done, and I've also played with a page that resubmits to itself if certain default dropdowns aren't populated and have a target page if they are populated.. so.. if car_mfg is undefined then submit_target=$PHP_SELF or if car_mfg is defined (and al

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

2002-03-06 Thread Beau Lebens
try using echo htmlspecialchars($name); that wya the " will convert to a " and should display properly in the HTML (check your source before doing this, it is probably all there, but the " is causing HTML rendering problems or something) HTH Beau // -Original Message- // From: Dave