RE: [PHP-DB] Convertion Types

2001-04-06 Thread Fernando Buitrago
Thanks, Just tha I need. Regards. Fer -- 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] Code bombs connecting to MSSQL 7

2001-04-06 Thread Andrew Hill
John, The quotes are throwing it. Try single or no quotes. Best regards, Andrew --- Andrew Hill - Director Technology Evangelism OpenLink Software - http://www.openlinksw.com Internet Data Integration Technology On 4/6/01 4:30 PM, "John A DAVIS" <[EMAIL PR

Re: [PHP-DB] PostgreSQL versus MySQL

2001-04-06 Thread The Hermit Hacker
Check out: http://openacs.org/philosophy/why-not-mysql.html and: http://www.phpbuilder.com/columns/tim20001112.php3 On Fri, 6 Apr 2001, Matt Braynard wrote: > Can someone outline the differences between the two? I am partial to MySQL > from experience but want to get a good view of why one i

[PHP-DB] PostgreSQL versus MySQL

2001-04-06 Thread Matt Braynard
Can someone outline the differences between the two? I am partial to MySQL from experience but want to get a good view of why one is better than the other. Also, I've heard that you will lose data with MySQL if a system failure should occur. Thanks. Matt -- PHP Database Mailing List (http://

Re: [PHP-DB] insert binary file into MSSQL

2001-04-06 Thread Phil Jackson
Hi, Check out http://www.zdnet.com/devhead/stories/articles/0,4413,2643888,00.html for a good workable example of using PHP/MySql to do this - the principles should be the same. Also, search www.asptoday.com for the word "blob" to find some good articles on the topic. Phil J. Marcel Liberda w

[PHP-DB] Code bombs connecting to MSSQL 7

2001-04-06 Thread John A DAVIS
THE SQL STATEMENT: $data = odbc_do($connection, "Select Distinct [ActivityStatus], [WaterSystemStateCode], [WaterSystemName], [PopulationServed], [SeasonBegins], [SeasonEnds], [SystemType], Contact, Phone, County, Connections, Address, CityStateZip From viewInventory Where [WaterSystemStateCod

Re: [PHP-DB] Error in non existing line

2001-04-06 Thread Julio Cuz, Jr.
Dan, I think you're missing the end quotes (") here: ... where image='$arr_Images[$randID]' " ; ... At 10:57 PM 4/6/2001 +0300, Dan Guja wrote: >Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 > >And I have just 89 lines > >Here are the last linse from i

Re: [PHP-DB] Error in non existing line

2001-04-06 Thread kuk
Hello, Dan You did not close { } statement. DG> Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 DG> And I have just 89 lines DG> Here are the last linse from index.html: DG> if ($verify ==7){ DG> $connection = mysql_connect("localhost", "user", "password") DG>

[PHP-DB] Error in non existing line

2001-04-06 Thread Dan Guja
Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90 And I have just 89 lines Here are the last linse from index.html: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

[PHP-DB] connecting to sybase

2001-04-06 Thread shaun
Fiesta does anybody know how to connect to a sybase database thats using the adaptive server anywere driver??? i tried $hostname = "host"; $username = "user"; $password = "pass"; $dbName = "database name"; $table = "table name"; Sybase_CONNECT($hostname, $username, $password) OR DIE( "Unable

Re: [PHP-DB] msql_numrows HELP please !!!

2001-04-06 Thread Johannes Janson
Hi, schrieb im Newsbeitrag 9aket9$i1t$[EMAIL PROTECTED]">news:9aket9$i1t$[EMAIL PROTECTED]... Hi, I'm a beginner in PHP dev, and i have find how to connect a DB and select a TABLE. But i search a example to ahve the numbre of ligne in a rows on my table. my table is : date author subject con

[PHP-DB] html examples for display of database

2001-04-06 Thread Marvin Horst
I'm looking for some html example code for displaying database records and navigation. My html code is functional but rather plain, like phpMyAdmin :-) A graphically challenged programmer! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additio

RE: [PHP-DB] oracle and php

2001-04-06 Thread Brian S. Dunworth
At 09:05 AM 4/6/01 -0500, Brian.J.Mauter wrote: >If you're using Linux or Unix, then you're going to have to compile Oracle >into PHP. right... >This is quite troublesome. not really. >For this to work, you first must install Oracle8i (maybe just the client >will work?). Yes, you m

RE: [PHP-DB] Header() order

2001-04-06 Thread Boget, Chris
> Do you know the header() order? > For example: header("Set-Cookie") should come before/after > header("Location")? > Cause IE seems to be sensitive about this. Cookies need to come first. Chris

[PHP-DB] Header() order

2001-04-06 Thread Lisa Elita
Hi all, Do you know the header() order? For example: header("Set-Cookie") should come before/after header("Location")? Cause IE seems to be sensitive about this. Thanks, Lisa E. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional command

RE: [PHP-DB] oracle and php

2001-04-06 Thread Brian.J.Mauter
If you're having troubles with unrecognized functions concerning Oracle, then you need to include it. As mentioned in the previous posts, you must include something in php.ini if you're using Windows. If you're not, then simply adding something to php.ini won't work. If you're using Linux or Un

[PHP-DB] [BUG] DEFINITIVE: Postgresql Field Names with Underscores

2001-04-06 Thread Patrick Dunford
=== Patrick Dunford, Christchurch, NZ - http://pdunford.godzone.net.nz/ Do not be anxious about anything, but in everything, by prayer and petition, with thanksgiving, present your requests to God. -- Philippians 4:6 http://www.hea

[PHP-DB] [BUG] Associative arrays and Postgresql

2001-04-06 Thread Patrick Dunford
ition, with thanksgiving, present your requests to God. -- Philippians 4:6 http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010406 === Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/ --

[PHP-DB] msql_numrows HELP please !!!

2001-04-06 Thread Bigbosss
Hi, I'm a beginner in PHP dev, and i have find how to connect a DB and select a TABLE. But i search a example to ahve the numbre of ligne in a rows on my table. my table is : date author subject contents i want to print each rows with HTML tag like this : dateauthor subject c

[PHP-DB] insert binary file into MSSQL

2001-04-06 Thread Marcel Liberda
Anybody got a sample script for store/retrieve binary data (images, wav files, mp3) to/from a MSSQL database (7.0)? -- 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 administrato

Re: [PHP-DB] IBM DB2 connectction problems

2001-04-06 Thread Dan Scott
I think it's more likely that you haven't sourced the /home/db2inst1/sqllib/db2profile script in whatever wrapper script starts up Apache for you. Add the following line to the top of 'apachectl' or '/etc/rc.d/init.d/httpd' to set up the DB2 environment variable before you start your webserver

[PHP-DB] using LIMIT

2001-04-06 Thread Sharmad Naik
Hi, Thanks for firstly helping me out with the prevoius query. I have a database with mem_id(int) and name(text) as its fields. In the first form (HTML) ,I take mem_id,name and count(used for LIMIT) from the browser. In the second query i write a query wher

RE: [PHP-DB] how many queries?

2001-04-06 Thread Steve Brett
AFAIK all resources are freed when the script ends so there's no real reason to free up the memory. Unless of course you have loads of queries on a long script ... Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you

[PHP-DB] how many queries?

2001-04-06 Thread Mauricio Junqueira
Hi, I was wondering what would be the main concern about doing several queries using different variables without freeing the result... just wast of memory or any more serious damage on the way? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For add

Re: [PHP-DB] error code = -504 Cursor unknow

2001-04-06 Thread Mauricio Junqueira
Mauricio Junqueira wrote: > Mauricio Junqueira wrote: > >> >> Hello, this is my first attempt to query and print a result coming from a >> database, in this case interbase6. >> >> I got the following error: InterBase: Dynamic SQL Error SQL error code = >> -504 Cursor unknown in maingeral.htm o

[PHP-DB] Timestamps VS Date/Time Types

2001-04-06 Thread Jordan Elver
Hi, I'm getting a bit confused about what date types to use in my applications and MySQL db. I have used timestamps and I know how to format them, convert them and compare them etc but now I am about to build a calender type script and I'm not sure what to use. For example, if I insert a load

Odp: [PHP-DB] Targeting frame in PHP

2001-04-06 Thread Bartek Pawlik
Thanks a lot, target= works fine. Bartek Pawlik Poland - Original Message - From: Steve Brett <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; Bartek Pawlik <[EMAIL PROTECTED]> Sent: Friday, April 06, 2001 10:12 AM Subject: RE: [PHP-DB] Targeting frame in PHP > have a

RE: [PHP-DB] Targeting frame in PHP

2001-04-06 Thread Steve Brett
have a look at target= Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or del

Re: [PHP-DB] DIferents types in SQL

2001-04-06 Thread Renze Munnik
Fernando Buitrago wrote: > > I need to know if the Query is possible with differents types of fields and > variables to insert or update statements. > > PHP sad me that error parse. > > Regards. > > Note: I need the reference of convertions type's funcions. > > -- > PHP Database Mailing List