[PHP-DB] HELP PLEASE: PHP - Sybase

Hello, I have got a problem, When i try to connect to Sybase from PHP script, I have an error that I am calling undefined function sybase_connect. Does it meen that I have to load some extra module to get this function to work? Or what should I do to resolve this problem ? Thank you. -- PHP

[PHP-DB] Interbase double select

With Interbase functions I have to make 2 select. "SELECT count(*).. to count valid record and "SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. Someone sau to me: just make the "SELECT * .. to extrac

[PHP-DB] Sybase-ct Bug 7609 New Connections?

Hi http://www.php.net/bugs.php?id=7609 This bug report (7609) concerned new connections being made when calling sybase_connect(). The last reponse was [2001-02-11 15:09:51][EMAIL PROTECTED] I guess this should not happen, anyone with sybase should verify this.. I'm using PHP 4.0.5 on Apache 1

[PHP-DB] Re: HELP PLEASE: PHP - Sybase

Did you specifiy either --with-sybase or --with-sybase-ct when perfomring the php configuration at compile time? "Veniamin Goldin" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > I have got a problem, When i try to connect to Sybase from PHP script, I

[PHP-DB] Re: HELP PLEASE: PHP - Sybase

Thank you. compile was done by my slackware instaliation. What could i do now ? Also my Sybase is runnig on other server in local network. "David Clark" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Did you specifiy either --with-sybase or --with-sybase-ct w

[PHP-DB] long or LOBs in oracle ???

Hi everybody, I have a little question. What is the best datatype to put large character data into (more than 5.000-20.000 letters). Maybe a CLOB or a long ? I am quiet new to oracle so I don't know so much about the LOBs and how Oracle handles it. On thing is, that I have to use more than one

[PHP-DB] Interbase & Blob

This is my page to extract image (from blob) in a interbase table. I call it with :echo "src=\"blob2img.php?id_product=".$id_product."\" "; My problem is that the images are too slow. Solutions ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] long or LOBs in oracle ???

Andy: Go with the CLOB. As you stated, you can have more than one CLOB defined in a table. Also, you can pull out data randomly instead of sequentially. Plus, the data can reside inline (for less than 4KB) or out of line for bigger values. The key to making it work is using the DBMS_LOB package.

[PHP-DB] suscribe

  Cordialement / Regards Christophe ChassagneuxIngénieur / Développeur ProgressTel : 0144 641 300Fax : 0144 641 301Mail : [EMAIL PROTECTED]

RE: [PHP-DB] ODBC and PHP

The error message is: - Cadastro de Fornecedor Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact (TransactNamedPipe())., SQL state 01000 in SQLExecDirect in c:\inetpub\inventario\cadastro\forneced

[PHP-DB] Re: dba_open

"Patrick Callihan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I don't seem to have the *.so modules available. When I added the line > 'extension=php_dba.so' to php.ini, nothing changed. When I tried to use the > dl() function, I just got an error messag

[PHP-DB] Problem importing large db to mysql in windows

I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the database starting getting greater than 1mb I remember the mysql > filename.sql wouldn't work

Re: [PHP-DB] Problem importing large db to mysql in windows

It sounds like the problem you are having is the same one I had. There is a variable in the php.ini called upload_max_filesize that the default max size in here is 2Mb, so when importing or exporting a dump file that is over 2Mb, it will not work. Try changing this in your php.ini file and see i

RE: [PHP-DB] Problem importing large db to mysql in windows

It works great! However, even though my .sql file was only 2.4 mb, it took nearly 15 minutes to import it all. I expect to be working with 20mb files in the not too distant future. Will it really take over two hours? Is this mysql's fault or the fault of my POS 500mhz WinME machine? Anyone know?

RE: [PHP-DB] Problem importing large db to mysql in windows

I have several files I import daily using phpMyAdmin, the biggest of which is over 4Mb and it only takes 5-10 seconds, but both machines (my pc-750Mhz Win98 and the server) are on the same network. If you are using dialup to access it, that could be why it is taking longer. Otherwise, I would lo

[PHP-DB] Multiple Entry

I have some data in a table like this: ++--+ | services | machine_name | ++--+ | MS Exchange Server and BDC | MAIL | | Microsoft Exchange for UA | UAMAIL1 | | Microsoft Exchange for UA

Re: [PHP-DB] Multiple Entry

If I understand you correctly you might try a query like: select services from tabl where machine_name="UAMAIL3"; That should only return one result based on the data you gave... My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASI

Re: [PHP-DB] Multiple Entry

Ya, I understand that. But when I want to view all services then I get three output for Microsoft Exchange. I want only one at that time. And click that service and I can get the machine name. On Wed, 1 Aug 2001, John Pickett wrote: > If I understand you correctly you might try a query like: >

RE: [PHP-DB] ODBC and PHP

Ariadne, This appears to be an error in the driver itself, but without a trace I cannot be sure. Best regards, Andrew > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 10:52 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subje

RE: [PHP-DB] Multiple Entry

I don't see how you would do it unless you changed your Services field to better associate it with the machine name. Perhaps something like Microsoft Exchange for UA1 Microsoft Exchange for UA2 Microsoft Exchange for UA3 Even if you do a "select distinct" on services with your table in its cur

Re: [PHP-DB] Multiple Entry

Try GROUP BY in the select statement: select services, machine_name from table GROUP BY services order by machine_name; I believe it should return: MS Exchange Server and BDC MAIL Microsoft Exchange for UA UAMAIL1 UAMAIL2

[PHP-DB] Re: Linux, Oracle 8.1.5, configure: libclntsh.so: Don't use llseek; slpmprodstab undefined

Installing a current libtools rpm seems to have corrected the situation. Rick Rick Hickerson wrote: > > I'm at wit's end. > > ../php-4.0.6/configure gives an error, and debug.log says libclntsh.so: don't > use llseek, use lseek64, and slpmprodstab is undefined. > > I've looked everywhere. A

[PHP-DB] Re: Multiple Entry

"Sharif Islam" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Is there any way, I can get only one output.But somehow I have to > incorpate it with the other data in that column, which doesn't have > multiple entry. Any hint? thanks in advance. Sample c

[PHP-DB] INSERT Won't Insert

This should be a simple insert. I must be missing something because I keep getting: Couldn't execute query. What am I missing? -- 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

RE: [PHP-DB] INSERT Won't Insert

If you simplify the query you'll see your error...all those escaped " were giving me a headache hehe *modified* $add_co_sql = "INSERT INTO $table_name (CompanyID, CompanyName, Address, City, StateorProvince, PostalCode,Region,Country,WebSite)VALUES ('','$CompanyName','$Address','$City','$Stateor

RE: [PHP-DB] Problem importing large db to mysql in windows

> I'm running a local web server for development on my Win ME machine > using apache, mysql 3.23.38, and php4. I've been copying my mysql > database that is online to my local one every once in a while. When the Since you're using relatively recent version of MySQL might I suggest you setting up

Re: [PHP-DB] INSERT Won't Insert

Steve I believe you're missing the closing bracket ) after $Website. I think it's clearer if you use single quotes (') rather than double quotes and then having to escape them. Something like: "INSERT INTO $table_name (CompanyID, CompanyName, Address, City, StateorProvince, PostalCode,Region,

[PHP-DB] Re: dba_open

Well, I have made it a little further. I could not get it to configure using the --with-db2 switch even after installing the sleepycat software. I did succeed in compiling php using the --with-gdbm switch. After that I had a module called dba.so. I put that in the proper place and changed the

[PHP-DB] Re: dba_open

With the help of another friend, I now have it working. The problem was I needed to make the directory and file group apache and then give them both group write permission. It works! I thought I would post this in case someone else ran across the same problem. Patrick "Patrick Callihan" <[EM

[PHP-DB] Avoiding Multiple IDs

What is the best method for avoiding multiple ids for the same information. For example: I have a table name company that has unique ids. The CompanyID are tied to a table name contacts which have unique ids (ContactID). The problem seems to be that if I add a contact with an existing CompanyName

[PHP-DB] UPDATE Not Updating

I belive this UPDATE should work, but it isn't. I get no errors. I have also tried using FieldName= '$Fieldname', but that does not seem to work either. $table_name = "contacts"; $update_contact_sql = "UPDATE $table_name SET FirstName =\"$FirstName\", LastName = \"$LastName\", Title = \"$Titl

RE: [PHP-DB] UPDATE Not Updating

Isn't PHP/MySQL case sensitive? Are all the column names the correct case? You could also try changing your die bit to or die (mysql_error()); that will echo the MySQL error message. HTH! Dave -Original Message- From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: 01 August 2001

Re: [PHP-DB] UPDATE Not Updating

At 5:24 PM -0400 8/1/01, Steve Fitzgerald wrote: >I belive this UPDATE should work, but it isn't. I get no errors. I have also >tried using FieldName= '$Fieldname', but that does not seem to work either. Try your WHERE clause with a SELECT statement and see if it's actually matching any rows. >

[PHP-DB] [Q] PHP on Linux, Oracle on Win32

G'Day All, I need to establish connectivity between a Debain Linux box running PHP 4.06 and Oracle 8i running on a Win32 box. Can someone point me at some FAQ's or other help. At present I have managed to get MS-SQL 2K going using TDS (Tabular Data Stream). Could TDS also be used for Oracle?

[PHP-DB] Limit Select Field Characters?

I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PR

RE: [PHP-DB] Limit Select Field Characters?

$fulldate = date("dmy"); echo $fulldate; -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: 01 August 2001 23:34 To: PHP-DB Subject: [PHP-DB] Limit Select Field Characters? I have a timestamp field that looks like this 0109011754 but I only want to com

[PHP-DB] InterBase -> selecting from a non existing id value?

Hello, is it possible with InterBase to fire a select statement against an empty table witout getting in trouble. if the table "X" looks like this: id -> integer dummy -> varchar and if I do now a select like "select * from x where id='$id'"; I will get the error Warning: InterBase: conv

Re: [PHP-DB] Limit Select Field Characters?

left(timestamp,6) - Original Message - From: "Jeff Oien" <[EMAIL PROTECTED]> To: "PHP-DB" <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 11:33 PM Subject: [PHP-DB] Limit Select Field Characters? > I have a timestamp field that looks like this > 0109011754 > but I only want to comp

[PHP-DB] REG_EMPTY

What exactly does the error 'REG_EMPTY' mean in PHP? -- -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED]

[PHP-DB] isset() for objects?

Does isset() work for objects? If not, is there a similar function for objects? 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]

[PHP-DB] Re: Limit Select Field Characters?

select * from table where date_format(timestamp, '%y%m%d') = '010801' "Jeff Oien" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a timestamp field that looks like this > 0109011754 > but I only want to compare > 010801 > when doing a SELECT. Is there a

[PHP-DB] Re: Avoiding Multiple IDs

"Steve Fitzgerald" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > What is the best method for avoiding multiple ids for the same information. > > For example: I have a table name company that has unique ids. The CompanyID > are tied to a table name contacts wh

[PHP-DB] Re: [Q] PHP on Linux, Oracle on Win32

"Donovan J. Edye" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > G'Day All, > > I need to establish connectivity between a Debain Linux box running PHP > 4.06 and Oracle 8i running on a Win32 box. Can someone point me at some > FAQ's or other help. At present

[PHP-DB] PHP redirect?

I have a form and based off of this form if my user selects option a then I want them to be redirected to another page. If they select option B then I want to continue with my php scrips as it does now. Does any one have any ideas on how I can accomplish this? -- PHP Database Mailing List (

Re: [PHP-DB] PHP redirect?

Hello!!! Here try this if ($DATABASE===Custom) { $table=Table1; } if ($DATABASE===Return_Log) { $table=table=3; $DATABASE=Return_Log; echo (""); echo (""); echo (" $us On Linux Using Apache"); echo (""); echo ("Please wait while l

Fw: [PHP-DB] PHP redirect?

OPPS WRONG SENDER HAHAHAHAHA! I'm a little absent minded Hello!!! Here try this if ($DATABASE===Custom) { $table=Table1; } if ($DATABASE===Return_Log) { $table=table=3; $DATABASE=Return_Log; echo (""); echo (""); echo (" $us On Linux

RE: [PHP-DB] PHP redirect?

that's all you need - make sure the form on the previous page has two radiobuttons, each with the same name of option_button and each has a value - one is 1 and the other is 2. HTH :-) Dave -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: 02 August 2001 04:4

[PHP-DB] Re: [Q] PHP on Linux, Oracle on Win32

ora_logon and friends are the old way to connect to Oracle. With Oracle 8, we should use the OCI functions (ocilogon, ...) Philippe "Hugh Bothwell" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > > "Donovan J. Edye" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">