Re: [PHP-DB] mysqlimport

Just incase anyone else is looking for the answer, the problem was solved thus: exec(/usr/local/mysql/bin/mysqlimport --replace --fields-terminated-by=\| - -user=testuser --password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt); It just needed a path to the mysqlimport

[PHP-DB] ODBC DataBase Paging Solution

Hi ! Do somebody has a paging solution for ODBC connection ? Thanks. Regards, Veniamin

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

Try put the php dlls on %systemroot%/system. I have IIS 5.0 + PhP 4.0.6 + MSSQL on a W2k server working perfectly. Later, Jorge Giménez - Original Message - From: Sean Swehla [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 8:10 PM Subject:

[PHP-DB] Not so relative but important...

Hello everyone... This is not a very relative question to DB and php but would mean a lot if someone helped me out.. It involves html headers... What i want to do is when i have a pdf or doc file ... using a special header, when clicking the file the page to download the file and not opening

[PHP-DB] Sybase CT with/without Sybase ASE

Dear All, In the past I had installed an Apache server with PHP 4.0.6 and Sybase CT extension on Mandrake Linux 8, all ok. On the Mandrake machine, I had installed Sybase ASE 11.9.2, that was only used for test; most of the time the php code used sybase ct lib to refer to another database server

[PHP-DB] oracle 8 database error 12154 using apache server on windows NT

Hi, I'm trying to connect to an oracle 8 database using php 4.0.6 In my php.ini file I deleted the ; in front of extension php_oci8.dll. I've set the format of tnsnames.ora and sqlnet.ora to the unix format. In the beginning of my php code I type: putenv('ORACLE_HOME = c:\oracle\ora81');

Re: [PHP-DB] eregi and ereg??

Hi, You cannot put multiple variables in ereg(). This is taken from http://www.php.net/manual/en/function.ereg.php i think it will explain it better If matches are found for parenthesized substrings of pattern and the function is called with the third argument regs, the matches will be stored in

Re: [PHP-DB] moving uploaded files

Hi, PHP has its own filesystem functions which you can use. If you want to move a file from one location to another you could use something like this ? copy($old_file,$new_file); unlink($old_file); ? The $old_file and the $new_file variables should contain the absolute path e.g.

Re: [PHP-DB] Not so relative but important...

Hi, try ? $fp = fopen(file.doc,r); Header(Content-Type: application/x-octet-stream); Header( Content-Disposition: attachment; filename=file.doc); passthru($fp); ? HTH Dobromir Velev -Original Message- From: Koutsogiannopoulos Karolos [EMAIL PROTECTED] To: 'Php-Db (E-mail) [EMAIL

RE: [PHP-DB] eregi and ereg??

You cannot specify multiple strings. However, you CAN concatenate strings and perform ereg()/eregi(): if( eregi(x, $string1.$string2.$string3, $regs ) -Original Message- From: Jason Caldwell [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 12:14 AM To: [EMAIL PROTECTED]

[PHP-DB] Looking for alternative to phpMyAdmin for data entry

Dear Newsgroup I am looking for an alternative to phpmyAdmin thatwill generate clumsy entry screens that allows you to select data type for each field (makes litle sence to me). Database it - table san_port Field Type Function Value san varchar(20)

[PHP-DB] Student Suspended Over Suspected Use of PHP

http://www.bbspot.com/News/2000/6/php_suspend.html -- 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]

[PHP-DB] Looking for alternative to phpMyAdmin for data entry II (Yellow background)

Dear Group Sorry about the missing grafics (is was so nice when I posted it). Now my friend says there was a online demo of a data entry page with YELLOW backgound color doing just this! Any ideas? Rgds Henrik Henrik Lassen [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

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

I don;t know why it's still not working. I tried it with smaller table and it works. but when I tried with my real table, it's not working I use this : UPDATE posts SET post_text='IMG SRC=IMG SRC=/serv2/big/forum/images/smiles' WHERE post_text='IMG SRC=/gmns/BB/images/smiles' FYI : posts_text

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

FYI : POST_TXT = text field Not null = YES --- Nagasea [EMAIL PROTECTED] wrote: I don;t know why it's still not working. I tried it with smaller table and it works. but when I tried with my real table, it's not working I use this : UPDATE posts SET post_text='IMG SRC=IMG

Re: [PHP-DB] Sybase CT with/without Sybase ASE

You don't need the Sybase dataserver but you still need the Sybase shared libraries that PHP is linked against. So restore all the .so's in $SYBASE/lib, and apache should start. Offhand, I'm not sure if 12.5 came with a different version of the open client libraries than 11.9.2 did, but if

[PHP-DB] string problem

scenario: Win.nt 4.0 pach6a Workstation, IE 5.5, Apache/1.3.20, php 4.0.6 wath goes wrong: when I set a string variable containing by example : hello jack on my html page php convert it to hello \jack\ and I get no errors on another machine with same configuration I get hello jack without

[PHP-DB] Replace into

Hi! In mySql you can do: replace into tbl_name values(value_1, value_2) does it work for Oracle aswell? Can anybody provide me with a link to a GOOD Oracle syntax reference. Oracle needs serious help with their documentation...:-( Regards /Robert -- PHP Database Mailing List

[PHP-DB] currency out of postgresql

I am trying to get two currency values from out of the database, add them together and print the to the screen. I am using the following code. $money = $myrow[6] + $myrow[7]; $formatted = sprintf(%01.2f, $money); printf (td align=\center\%01.2f/td/tr\n, $formatted); $myrow[] is the array that I

Re: [PHP-DB] currency out of postgresql

$formatted = sprintf(%01.2f, $money); printf (td align=\center\%01.2f/td/tr\n, $formatted); maybe twice, try: $formatted = sprintf(%01.2f, $money); echo td align=\center\$formatted/td/tr\n; - Original Message - From: Rick Eicher II [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: [PHP-DB] string problem

Don't know why you're getting problem. However, you can use stripslashes() to avoid the problem. -Original Message- From: Bruno Franx [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 10:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] string problem scenario: Win.nt 4.0 pach6a

RE: [PHP-DB] string problem

There's an option in php.ini: magic_quotes_gpc = On/Off; If on, any GET, POST, and Cookie data will come back with \ marks before ' and marks. Guesing one server has it set to Off, and one set to On. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512

[PHP-DB] Another Image prob

I'm new at this and i'm sure that this has been answered before, but anyway... I am trying to retrieve images from a MySQL database. They are stored as BLOBs with the following table format: Database metonym_metonym - table imgs Field TypeAttributes NullDefault Extra fk_proj_id

RE: [PHP-DB] Another Image prob

The consensus is that it is best if you DO NOT store the images as blobs in a database. Rather, store the images in separate files and store the names of those files in the database. Then retrieve the file names for the database, open the image files, and then send the images to the client's

[PHP-DB] currency out of postgresql

After I do the add $money comes out to be 0. The data comes out as $0 and $5,217.00, I need to add these two to get $5,217.00. How do you add money with the dollor sign in the data? rick -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 7:24

Re: [PHP-DB] currency out of postgresql

While the proposed solution below may very well indeed work for this situation it's a far better practice to strip the variable down to known to be good values rather than known to be bad ones. Rather than strip $ and , marks from the variable it's far better to strip out anything other than 0-9

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

no it's working (successed), but nothing was updated. I tried to make a fake table. when i tried to make a fake table its working. i tried to change ABC from the table to XXX but if i got data called ABCD , it didnt change to XXXD why ? --- Jason Wong [EMAIL PROTECTED] wrote: I don;t know

RE: [PHP-DB] Another Image prob

Don't think that was the answer he was looking for =]. Here's how I retrieve images stored as blobs. $query = select File, Type from Pictures_Data where id=$id; $result = mysql_query($query); $data = mysql_result($result, 0, File); $type = mysql_result($result, 0, Type);

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

no it's working (successed), but nothing was updated. I tried to make a fake table. when i tried to make a fake table its working. i tried to change ABC from the table to XXX but if i got data called ABCD , it didnt change to XXXD why ? *Now* I know what you're trying to do. The UPDATE

[PHP-DB] Persistent Links and Temporary Tables

Hi, Is anyone able to briefly explain to me how the use of temporary tables by MySQL is affected by PHPs persistent connections? From my reading of MySQL temp tables are deleted when the current connection is closed, but that might not be for quite a long time with a persistent