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

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

[PHP-DB] Re: regarding multiple joins

2002-11-22 Thread Bastian Vogt
hi, you could do this with a join, but i experienced single querys to be faster if you always have only one person_id to look for in person. if it was many person_ids and your query would end like "...person_id in (1,2,3, 9998)" a join would by faster, I guess. feal free to correct me, if I'm

[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

[PHP-DB] Re: regarding multiple joins

2002-11-22 Thread David Elliott
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings Jonathan On 22 November 2002 at 01:55:10 -0800 (which was 09:55 where I live) Jonathan Narong graced us with these comments > i have an table 'articles' which has multiple fields, such as author, > editor, photographer, etc.. each of these

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] S

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 10:04

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 it

[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: http://www.php.net/

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 q

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

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 pr

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

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 -Or

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 un

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] MySQL connectiviy

2002-11-22 Thread Jeremy Wood
- Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 22, 2002 1:27 PM Subject: Re: [PHP-DB] MySQL connectiviy > On Saturday 23 November 2002 02:34, Jeremy Wood wrote: > > Hello all, > > I'm new to PHP and would like to start using myS

Re: [PHP-DB] MySQL connectiviy

2002-11-22 Thread Jeremy Wood
Ok i found that package and I also got pgsql working so Ill just use that if I dont ahve any success. Thanks for all the help. 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 whi

[PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
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 auto_increment, title varchar(40) NOT NULL default '',

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 auto

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 -0