[PHP-DB] metabase support

I just want to make sure that I'm understanding what metabase supports. It does not support: - references - primary keys Does anyone find that this prevents you from using metabase? Or do you find that you have to hack your way around these deficiencies? I use MySQL most of the time, so I've le

Re: [PHP-DB] PEAR DB documentation?

"David Osborne" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Where can I find user-level documentation for the DB database > abstraction layer in PEAR? The stuff on www.php.net pointed to from > http://pear.php.net/ seems to be aimed at developers and I'm no

[PHP-DB] RE: Informix user wierdness

> This is more an Informix question rather than a PHP question but > I hope someone can help > I've installed the Linux-SE version and CSDK of Informix from > informix.com and installation has gone fine including createing > the demo DB. I can also start 'dbaccess' and browse/query the > tables s

Re: [PHP-DB] Oracle8i, PHP4, Apache

Hi Martin, Try something along these lines ... $query= "alter session set NLS_DATE_FORMAT = 'DD-MON-'"; $curs = ociparse($conn,$query) or die( "Unable to parse query" ); ociexecute($curs) or die( "Unable to execute query" ); You can also set this in you init.ora file i beleive HTH Ste

Re: [PHP-DB] Query with Access

I'd try adding: $conn = odbc_connect("pruebas_php", "", "") or die("cannot connect to pruebas_php"); $resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM Personas") or die ("cannot execute query"); -- Regards, Gary "SuperID" Huntress ==

Re: [PHP-DB] MySql Connect question

This works for me: Dim conn set conn=server.createobject("adodb.connection") conn.Open ("driver={mysql};server=192.168.0.1;uid=myUID;pwd=myPass;database=myDB") Hope it helps! -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free

Re: [PHP-DB] metabase support

Hello Dean, On 01-Apr-01 06:38:32, you wrote: >I just want to make sure that I'm understanding what metabase supports. >It does not support: >- references >- primary keys >Does anyone find that this prevents you from using metabase? Or do you find >that you have to hack your way around these d

Re: [PHP-DB] PEAR DB documentation?

Hello Dean, On 01-Apr-01 07:33:02, you wrote: >I've used DB in the past, but since I'm writing a public-use app, I thought >I'd use metabase, since it's DBMS-independent. DB seems to be the more >traditional way of using database abstraction layers (as in Perl DBI and >such); the interface is DB

[PHP-DB] Output parameters to stored procedures

Does anyone know how to bind output parameters when calling stored procedures via odbc_do? Thanks t -- 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: [EMAI

[PHP-DB] Search results

HI Can anyone tell me what is the best way to implement displaying multiple search results using next and previous buttons to cycle through all the results. I see this method done on a lot of sites but don't know how to do it in PHP. Thanks in advance, Dave

[PHP-DB] PHP an MySQL

Can someone recommend a book that shows how to use PHP and MySQL. I need to see how to pass parms from a form to a PHP so I can Update, Add and Delete records. Thanks for the help. Jim Ray -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

RE: [PHP-DB] CSS versus Includes

On 31 Mar 2001 13:19:45 -0800 AD in php.db, Michael Geier said: >this post is about apples and oranges... > >CSS (Cascading Style Sheets) have nothing to do with includes. >They only have to do with formatting elements on a web page. >They can be written inside the document, or can referenced >e

RE: [PHP-DB] PHP an MySQL

I would recommend the first two books listed on this page: http://www.webdesigns1.com/php/books.php I've read both. Jeff Oien > Can someone recommend a book that shows how to use PHP and MySQL. > > I need to see how to pass parms from a form to a PHP so I can Update, Add > and Delete records. >

Re: [PHP-DB] Search results

In article <001301c0bafa$34d15be0$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("David Drummond") wrote: > Can anyone tell me what is the best way to implement displaying multiple > search results using next and previous buttons to cycle through all the > results. I see this method done on a lot of

RE: [PHP-DB] CSS versus Includes

When I asked the question, what I meant was should I use the includes to hold page style details or a CSS file. And someone who understood that this was not an apples and oranges situation but one of approach answered that Netscape was not fully supportive of CSS and suggested includes may be the

Re: [PHP-DB] CSS versus Includes

"Matt Braynard" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | When I asked the question, what I meant was should I use the includes to | hold page style details or a CSS file. And someone who understood that this | was not an apples and oranges situation but

Re: [PHP-DB] retrieving images

Hello, I'm trying to retrieve and output all the binary images in my images table. This is what I have, $result = mysql_query("SELECT * FROM images",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { $filetype = ($myrow

Re: [PHP-DB] uploading files.

"olinux" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | here is the working script on my local windows machine. note that you will | need to change $the_path | Everything is pretty self explanatory. You can read the article that I took | this from at http://ph

[PHP-DB] select data from a drop down box in a form

I like to select data out of a drop down box in my form field from a mysql database. While I do that I also like that it reloads the page and put the relevant products of that drop down box in another field. Ex: Category 1 Category 2 Category 3 are in the drop down box and when I choose Category 1

Re: [PHP-DB] PHP on WIN32 with DB2 CLI

Actually, CLI is almost function-for-function the same as ODBC. The PHP implementation of ODBC is quite a simplified version, but it covers most of the basic function. Chris, what is it that you are trying to do, specifically? Dan Phil Jackson wrote: > Chris - I think to use DB2's CLI interf

[PHP-DB] multiple file uploads

Hi all, I am combining a couple of scripts to create one that handles multiple files... I am using these two scripts. So far the script WILL upload. but i am having some trouble getting it to work totally right. If you run it you will see that the form is printed twice... and a couple other thin

Re: [PHP-DB] select data from a drop down box in a form

There are probably a million ways to do this... here is one :) (note that the file should be named "fieldtest.php" -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://superid.dyndns.or

[PHP-DB] ecommerce - storing as an array or temporary record

I am developing a script that will eventually be a "pay-to-list your whatever" script. I am wondering if the best way to hold data throughout the four forms would be to hold these in an array - each form would array_push() the vars into the $listing array. Or would it be better to insert the rec

Re: [PHP-DB] retrieving images

Yes, exactly. What you want are image tags, as in http://www.fractal-vibes.com . "Stuart J. Browne" wrote: > Hello, > > I'm trying to retrieve and output all the binary images in my images table. > This is what I have, > > $result = mysql_query("SELECT * FROM images",$db); > > if ($myrow =

Re: [PHP-DB] Search results

I've not seen the limit function, but it sounds quite uselfull. Whatever method, you could pass the first or last keys related to the current page and an indication as to whether you are going forwards or backwards - I suppose that in PHP it could all be done in one file, self-referential-like, a

RE: [PHP-DB] CSS versus Includes

Matt, I recommend using separate style sheets. This is especially important when your users are browsing a record set, say 10 records at a time. There is no need to pass them the style sheet embedded in the PHP page for every page view. If the stylesheet is a file on the file system, it is more e

[PHP-DB] Boolean-Values from MSSQL 7.0 - /Linux/PHP404pl1/apache

An old question maybe? How can I get out the values of a yes/no-field of a MSSql70-table? I'm using Linux/PHP4.04pl1/Apache. Evertime I try to get this value the site cannot be loaded. Is there a documentation or a howto about this item? Thanks for answers Martin E. -- PHP Database Mailin

Re: [PHP-DB] metabase support

""Manuel Lemos"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > >I just want to make sure that I'm understanding what metabase supports. > > >It does not support: > >- references > >- primary keys > > >Does anyone find that this prevents you from using metabas

Re: [PHP-DB] ecommerce - storing as an array or temporary record

> I am developing a script that will eventually be a "pay-to-list your whatever" script. > I am wondering if the best way to hold data throughout the four forms would be to hold > these in an array - each form would array_push() the vars into the $listing array. > Or would it be better to insert

[PHP-DB] Character set?!

If i try to connect to MySQL from PHP i receive an error, that says that "character set #9 couldn't be initialized". PHP tries to look for a directory with charsets somewhere in /usr/local/..., but the charsets are installed in /usr/share/mysql/charsets - that's where they are installed from rpm.