Re: [PHP-DB] Targeting frame in PHP

2001-04-06 Thread Renze Munnik
Bartek Pawlik wrote: Hi, I have two frames, say TOP, BOTTOM. In TOP frame I have a PHP script, and two buttons (must be). What I want is: BUTTON1 - after pressing, reload TOP frame BUTTON2 - after pressing, update BOTTOM frame, but it must pass variables entered by user in form in TOP

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

[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

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 on line 8

[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

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

[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

[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

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

2001-04-06 Thread Patrick Dunford
nd petition, 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/ -- P

[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

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

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 may

[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

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

2001-04-06 Thread Johannes Janson
Hi, ?php $dbhost = "yourhost"; $dbuser = "youruser"; $dbpass = "yourpassword"; $dbname = "name_of_DB"; $connection = mysql_connect("$dbhost, $dbuser, $dbpass") or die ("can't connect"); $database = myslq_select_db($dbname) or die ("can't select DB"); $result = mysql_query("SELECT * FROM

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

[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 if ($verify ==7){ $connection = mysql_connect("localhost", "user", "password") or die("Cannot connect"); $db = mysql_select_db("rating" ,

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 ?php DG if ($verify ==7){ DG $connection = mysql_connect("localhost", "user", "password") DG

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

[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

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

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 is

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