[PHP-DB] Re: Get Last ID Inserted

2002-11-22 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings Adam On 21 November 2002 at 11:12:46 -0500 (which was 16:12 where I live) Adam Voigt emanated these words of wisdom But if there are heavy operations on the site, will this not also pick up a different last inserted id, if in the split

[PHP-DB] regarding multiple joins

2002-11-22 Thread Jonathan Narong
this is a problem i've been struggling with for a little while. any attempt to find help online has not produced any useful information. this is regarding joins, which i'm not an expert in, but hopefully one of you can help me out. i have an table 'articles' which has multiple fields, such as

[PHP-DB] RE: inserting html into mysql tables

2002-11-22 Thread Jonathan Narong
5k of data is way too much for varchar, so i would use a field of type TEXT. i do this as well (storing html data in mysql) and it works great. some say to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes automatically - not sure exactly why that is though. -Original

[PHP-DB] Dbase module won't work

2002-11-22 Thread J Veenhuijsen
IIS 5 Won't load php_dbase.dll php.ini ; ; Paths and Directories ; ; include_path = ; UNIX: /path1:/path2 Windows: \path1;\path2 doc_root = ; the root of the php pages, used only if nonempty user_dir = ; the directory

RE: [PHP-DB] Dbase module won't work

2002-11-22 Thread Griffiths, Daniel
might sound like a silly question but you do have php_dbase.dll under c:\php\ , when I installed php on a windows machine it put all the extentions in c:\php\extentions\ -Original Message- From: J Veenhuijsen [mailto:[EMAIL PROTECTED]] Sent: 22 November 2002 10:04 To: [EMAIL PROTECTED]

Re: [PHP-DB] Dbase module won't work

2002-11-22 Thread J Veenhuijsen
I dont' hope it does matter where to put the dll files. I put php_dbase.dll in several other directories but is still does not work. www.classic-showroom.nl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Dbase module won't work

2002-11-22 Thread J Veenhuijsen
Daniel Griffiths wrote: might sound like a silly question but you do have php_dbase.dll under c:\php\ , when I installed php on a windows machine it put all the extentions in c:\php\extentions\ -Original Message- From: J Veenhuijsen [mailto:[EMAIL PROTECTED]] Sent: 22 November 2002

Re: [Fwd: Re: [PHP-DB] how to update a text BLOB in ODBC?]

2002-11-22 Thread Nick Gorham
Jeff Stern wrote: it turns out it is probably a bug -- firebird does not have this behavior, but interbase does. they do not think it is an easysoft issue. they think if we juse use firebird here we will be fine. but we cannot risk switching to firebird, here. my IP dept would never go for

[PHP-DB] Forums?

2002-11-22 Thread Paul Ihrig
hey guys. a friend want help setting up a forum. what are some good easy to use ones out there? thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Forums?

2002-11-22 Thread Neil Lathwood
Paul Ihrig wrote: hey guys. a friend want help setting up a forum. what are some good easy to use ones out there? I have used http://www.phpbb.com/ b4 and it is very good for free ;) Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] INSERT question. 2 pointers.

2002-11-22 Thread Hutchins, Richard
Actually, according to the MySQL manual and experience, if you don't want to insert data into each column in a table, you can specify the columns you DO want to insert data into. See below: $sql = INSERT INTO myTable (col1,col3,col4) VALUES ('$val1','$val2','$val3'); As you can see, the above

[PHP-DB] autoupload

2002-11-22 Thread Edward Peloke
I am currently creating a php/mysql site for a client. Many of the customers who will be using this site also use a vb/access program to store a lot of the same data. The client asked me last night if we could write an app that would run on the customers machine that would routinely take data

Re: [PHP-DB] autoupload

2002-11-22 Thread 1LT John W. Holmes
I am currently creating a php/mysql site for a client. Many of the customers who will be using this site also use a vb/access program to store a lot of the same data. The client asked me last night if we could write an app that would run on the customers machine that would routinely take

[PHP-DB] Re: Access Violation in ISAPI version

2002-11-22 Thread quest
Hi, there... I had seen that error message in my PC (with windows 2000 Server + php4.2.3 + Oracle9i) if you are using PHP on IIS(, I recommend that you should check session.save_path = c:/temp in your php.ini. (this file normally located in c:\winnt directory) some developers discussed this

[PHP-DB] MySQL connectiviy

2002-11-22 Thread Jeremy Wood
Hello all, I'm new to PHP and would like to start using mySQL (or postgresql) but I keep having one problem. In a php file i have a simple call to the function mysql_connect() but i constantly get the error Fatal error: Call to undefined function: mysql_connect() MySQL support was installed

RE: [PHP-DB] MySQL connectiviy

2002-11-22 Thread Pedro M. S. Oliveira
Hi Jeremy, Probably you don't have all of php installed; you can pick it up in php.net and install the full php libs. Or in your php ini file, the php lib path can be incorrect, well these are just thoughts as I don't use red hat for some time (SuSE Forever). Hope you figure it out, Pedro

Re: [PHP-DB] MySQL connectiviy

2002-11-22 Thread Jason Wong
On Saturday 23 November 2002 02:34, Jeremy Wood wrote: Hello all, I'm new to PHP and would like to start using mySQL (or postgresql) but I keep having one problem. In a php file i have a simple call to the function mysql_connect() but i constantly get the error Fatal error: Call to

Re: [PHP-DB] MySQL connectiviy

2002-11-22 Thread Jeremy Wood
No, I was unable to find a new version of it. Is there a version for php 4.2 ? Jeremy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] autoupload

2002-11-22 Thread Peter Lovatt
A little more detail Install MyODBC - you will need it on all machines In Access File - Get external data - Link tables -ODBC data sources - MyODBC data source You now have a direct link from Access to MySql and can run an Access query to load the data straight into MySql. I did this a while

Re: [PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Rick Widmer
At 05:26 PM 11/22/02 -0800, Jonathan Narong wrote: sorry for my confusing email... i'll try to clarify what i was asking: i have two tables (i shortened them to only show the parts relating to what i'm trying to do now) ... CREATE TABLE articles ( id smallint(4) unsigned zerofill NOT NULL

RE: [PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
that worked perfectly! thank you so much! -jon -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:08 PM To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB Subject: Re: [PHP-DB] RE: regarding multiple joins At 05:26 PM 11/22/02