[PHP-DB] eregi and ereg??

2001-09-13 Thread Jason Caldwell
www.php.net shows the proper format for EREG and EREGI is: int ereg (string pattern, string string [, array regs]) My question is this; I want to be able to compare 2 or more strings to the EREG(I) STRING PATTERN... without having to create two separate EREG(I) IF...THEN statements... If I und

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
> its not working because it's not a variable (url) > it's a text field 'url' is the name of the field which contains "http://something.com/";. Replace it with the name of the field in *your* table which contains "http://something.com/";. BTW as Terry pointed out (I misread your question) the

[PHP-DB] mysqlimport

2001-09-13 Thread Keith Spiller
Hello, I'm trying to use: passthru("mysqlimport --replace --fields-terminated-by=\| --user=testuser --password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt", $output); The mysqlimport command works perfectly at the telnet command prompt, but never through Php. When I e

[PHP-DB] Compiled dBase Extension for Win32?

2001-09-13 Thread Thomas Kaeser
Hi! I am trying to find a compiled dBase library (php_dbase.dll) for PHP4; found many hints, but nothing useful. Thanks for your help! Thomas -- Thomas Kaeser [EMAIL PROTECTED] *** Courage is not the absence of fear, but rather the judgement that something else is more important than fear.

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Nagasea
its not working because it's not a variable (url) it's a text field --- "Jason Wong" <[EMAIL PROTECTED]> > wrote: >> Is it possible to find and replace a data in the table using phpMyAdmin ? >> If yes, how to do that ? >> >> I want to change "http://something.com/"; to >"http://www.something.com/

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
> Is it possible to find and replace a data in the table using phpMyAdmin ? > If yes, how to do that ? > > I want to change "http://something.com/"; to "http://www.something.com/target"; Run an UPDATE query? UPDATE table SET url='http://something.com/' WHERE url='http://www.something.com/target

Re: [PHP-DB] Backups, best practices

2001-09-13 Thread leo g. divinagracia iii
Beau Lebens wrote: > > // err.. please correct me if I'm wrong, but isn't pkzip > // exactly that? or more > // exactly, winzip is a windows interface to it? it certainly > // uses the same > // compression > > nope - you're right, i forgot about pkzip, but i was just saying that it's > p

Re: [PHP-DB] moving uploaded files

2001-09-13 Thread Sean Swehla
How about: copy("path1","path2"); unlink("path1"); On Thu, 13 Sep 2001 16:07:14 -0400 "Jon Mormino" <[EMAIL PROTECTED]> wrote: > Does anyone have a solution for the following problem. > > I use dbwired.com for hosting (great service). They do not, however, > for obviously reasons allow the sy

Re: [PHP-DB] Problems inserting large blob

2001-09-13 Thread Nagasea
I also facing this problem yesterday. Do you want to know what i did ? I open the file with notepad then copy & paste it. And it's works --- Justin Buist <[EMAIL PROTECTED]> > wrote: >You might want to check php.ini - if memory serves the maximum filesize >you can upload over HTTP by default i

[PHP-DB] Re: reading arrays within a field from mysql and separating the values

2001-09-13 Thread bill
You need to split the value into an array using php, then list it out. Lots of ways to do that, here's one. $result4 = mysql_query( "SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'"); $DCD = mysql_fetch_array ( $result4 ); print " \n \n \n None\n

[PHP-DB] PHP/Access and Quickbooks

2001-09-13 Thread Brian Grayless
Does any one have any ideas how Quickbooks data can be synced with an Access database? I want to use PHP to post some account information live from my accounting system and can't seem to figure out a way. If anyone else also has a need to extract information from Quickbooks and has any ideas as t

[PHP-DB] moving uploaded files

2001-09-13 Thread Jon Mormino
Does anyone have a solution for the following problem. I use dbwired.com for hosting (great service). They do not, however, for obviously reasons allow the system() command from a php script. So, when I switched to this server I had to switch from a system("mv file1 file2"); command to a move_u

Re: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Jason Wong
> The whole block is wraped in a while ($db->next_record()) { ...} loop > actually. Now, I'm not sure if the next_record() method is setting an > internal member to the current record and returning TRUE/FALSE for > success, or if it's actually supposed to be returning a row. It should be the for

Re: [PHP-DB] Problems inserting large blob

2001-09-13 Thread Justin Buist
You might want to check php.ini - if memory serves the maximum filesize you can upload over HTTP by default is 2MB. Bump that number up and restart Apache (or whatever webserver you use) and see if that fixes the problem. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Ra

Re: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Justin Buist
> Looking at your code for the first row (I've cleaned it up a bit to make it > readable!): > > $numcols = 5; >for ($l = 1; $l <= $numcols; ++$l) { > ?> > > echo $db->f("product_sku"); > ?> > > } > ?> > > > It should be pretty clear why you're getting the

[PHP-DB] Problems inserting large blob

2001-09-13 Thread Joao Barreto
Hello all ... I'm having a problem uploading large files (3MBytes for examples) and inserting it onto a MySQL database. No problem with smaller files. The code is basically this: When the files are the mentioned size (I checked the whole file got there on /tmp/something) I get an error messa

Re: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Jason Wong
- Original Message - From: Adv. Systems Design <[EMAIL PROTECTED]> To: PHP List <[EMAIL PROTECTED]> Sent: Friday, September 14, 2001 12:09 AM Subject: [PHP-DB] Table display Driving me Crazy! > Hello * > trying to output mysql content into a table, but the > table is designed to use 3 Tr

[PHP-DB] How to Replace the table data

2001-09-13 Thread Nagasea
Is it possible to find and replace a data in the table using phpMyAdmin ? If yes, how to do that ? I want to change "http://something.com/"; to "http://www.something.com/target"; thanks folks _ www.kaskus.com - FREE EMAIL SERVICE --

RE: [PHP-DB] NEED HELP WITH ORACLE & PHP PLZ.

2001-09-13 Thread Andrew Hill
Not sure, but possibly it's an ORACLE_HOME not being set issue. Best regards, Andrew > -Original Message- > From: Brian Ofsthus [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 13, 2001 2:17 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] NEED HELP WITH ORACLE & PHP PLZ. > > > I

[PHP-DB] NEED HELP WITH ORACLE & PHP PLZ.

2001-09-13 Thread Brian Ofsthus
I have The following A Sun Ultra2 Running the Oracle Client talking to a Oracle Instance 8.1.7 on another server. sqlplus scott@rhinodb works greate. I do have to be in $ORACLE_HOME for some reason. When I issue the following command I get an error Untitled Error in the Browse

[PHP-DB] Trouble connecting to MSSQL 2k DB

2001-09-13 Thread Sean Swehla
I'm running Win2k server, with MSSQL 2k, & PHP 4.0.6. Every time I try to connect to the SQL sesrver within the script I get the following output: X-Powered-By: PHP/4.0.6 Content-type: text/html Warning: MS SQL message: Login failed for user 'tu'. Reason: Not associated with a trusted SQL Se

SV: [PHP-DB] Straightforward authentication?

2001-09-13 Thread Torgil Zechel
A common way to identify a client is to use the challange-response algorithm. It works like this: Ps is the password stored on the server Pc is the password entered by the client H is a hash-function (md5 for example) V is a 'random' value Server calculates H(V + Ps) and save this in a session v

RE: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Rick Emery
What does you mysql table look like? What does your SELECT statements look like? What does function p() do? What does function f() do? Need more info -Original Message- From: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 11:09 AM To: PHP List Subje

[PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Adv. Systems Design
Hello * trying to output mysql content into a table, but the table is designed to use 3 Trows to display info for ONE product (table also has to have 5 columns): row1 sku1|sku2|sku3|sku4|sku5 row2 img1|img2|img3|img4|img5 row3 nam1|nam2|nam3|nam4|nam5 -

[PHP-DB] prepared statements under load with pconnect

2001-09-13 Thread John Espey
When I use pconnect to connect to a db2 back end, I get the expected faster connection times. However, when the site is under any sort of load (6 or more concurrent accesses), we have noted that the time spent preparing statements increases greatly (execution time remains fairly consistent howeve

[PHP-DB] Straightforward authentication?

2001-09-13 Thread Russ Michell
Hi all: The few php/MySQL apps I've developed that required username/password access, have simply been a means of comparing usernames and hashes of passwords in a DB. My next application needs to be slightly more secure but nothing like the needs of protecting online banking or vulnerable pr

RE: [PHP-DB] CHAR(0) retrival

2001-09-13 Thread Rick Emery
CHAR(0) allocates no space to the variable, ther than house-keeping space. Why are you dong that? You say you can SELECT but cannot retrieve. SELECTing is retrieving. Please elaborate. -Original Message- From: Krishnakumar S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001

Re[2]: [PHP-DB] Selecting twice from the same table

2001-09-13 Thread Jacob Singh
Hello Justin, Thursday, September 13, 2001, 11:07:26 AM, you wrote: JB> On Thu, 13 Sep 2001, Jacob Singh wrote: >> Hello, >> main >> -- >> ID autonumber >> content_ID enum('artist','song','album',user function','genre', etc.) >> name char >> img char >> des char >> etc.

[PHP-DB] Selecting twice from the same table

2001-09-13 Thread Jacob Singh
Hello, Okay this will probably be confusing, but I'll do my best. Please don't try and question my database structure, I have my reasons and at this point it is deffinately not going to change. I have many different types of data stored in a main table the structure of main is as foll

[PHP-DB] Re: NCLOB storage

2001-09-13 Thread kljh
Oops, damn profile : please reply to group or [EMAIL PROTECTED] Many thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Passing parameters to a PHP file.

2001-09-13 Thread Victor Espina
Thanks Leo, i solved the problem using $HTTP_GET_VARS[]. -- == Victor Espina Caracas, Venezuela http://mitrompo.com/vespina [EMAIL PROTECTED] (Quite el 'nospam' para responder) (Remove 'nospam' to reply) "Leo G. Divinagracia III" <[EMAIL PROTECTED]> wrote in message [

[PHP-DB] NCLOB storage

2001-09-13 Thread kljh
Hi, I have a perfectly fine piece of code that takes a form input and stores it as a CLOB, but when I try to store it in an NCLOB with the same piece of code I get an error: Warning: OCILobWrite: ORA-24806: LOB form mismatch in c:\apache\htdocs\working_clob.php on line 24 $sql = "insert into jt

Re: [PHP-DB] array in db field -> actual array

2001-09-13 Thread brendan
scratch that, i had a syntax error in the array.. you were completely right dobromir eval() works perfectly.. thanks! Brendan wrote: > thanks dobromir, > unfortunately that doesnt seem to work ... > although looking at the php manual you seem to be on the right track.. > could the way the

[PHP-DB] Re:[PHP-DB] array in db field -> actual array

2001-09-13 Thread brendan
thanks dobromir, unfortunately that doesnt seem to work ... although looking at the php manual you seem to be on the right track.. could the way the textfield is parsed & passed back affect the array? cheers! brendan Dobromir Velev wrote: > Hi, > I think you can use the eval() function to exec

Re: [PHP-DB] array in db field -> actual array

2001-09-13 Thread Dobromir Velev
Hi, I think you can use the eval() function to execute the stored info. The code will look something like this $res=mysql_query(...) eval($row_from_query); If you want to change the name of the array you could use eval(str_replace("$array","$newarray",$row_from_query)); HTH Dobromir Velev -

[PHP-DB] array in db field -> actual array

2001-09-13 Thread brendan
hi, i am currently scouring the web for a solution to this but thought i would try here as well .. i have a text field in a mysql database the textfield contains an array written out as // $array[0][1]="one"; $array[0][2]="two"; $array[0][3]="thre"; $array[1][1]="four"; $arra

[PHP-DB] MSSQL Views and Multiples selects on Mysql

2001-09-13 Thread Jorge Giménez Mayorgas
Hi. I am migrating part of a big database of MSSQL to MySQL . The tables are migrated and data is ok but I need the views that I used on MSSQL . I tried this , I replaced the name of the view used with the sql statement , a very big select statement. I have checked SQL syntax with MySQL docume

[PHP-DB] CHAR(0) retrival

2001-09-13 Thread Krishnakumar S
I am having a problem using CHAR(0) fields. I am not able to differenciate between NULL and NOT NULL while retriving these fields although I can SELECT these fields if I mention it in my query to MySQL. Krishnakumar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EM