[PHP-DB] FW: sql bind parameter problem

2004-02-23 Thread Angelo Zanetti
HI, I have this error after my database crashed (power failure) but have already repaired the database. sql bind parameter not used for all parameters. not sure what the error is. cant find much on the net about this error. if anyone can give me some info or links, ill appreciate it. ps:

[PHP-DB] Strange behaviour of Mysql_fetch_array + Submit button

2004-02-23 Thread Bob Gervais
Hi, Hopefully I submit this to the correct list. I'm completely new to PHP and am trying to get some sort of shopping cart working based on an example I found on the WWW. I have an include page which contains all cart functions (add to cart function displayed below), and a main page in which I

[PHP-DB] Re: Help with SQLite and ADOdb

2004-02-23 Thread user
@domain.invalid hmmm??? HMMM indeed Many hosts there days offer mysql and PHP on default. I could point you in the write direction if your willing to pay around $5 - $10 a month on hosting. Which is quite reasonable for the kind of service you get and services (more importantly). Yes, I know but

[PHP-DB] RE: Connect to MSDE using PHP

2004-02-23 Thread Colin Williams
It might be worth running netstat on the server to check if SQL Server is listening on a TCP port. If not, check the config. I think the full version of SQL Server defaults to using named pipes only, TCP has to be explicitly enabled. My textbook also says that SQL Server runs under the 'Local

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Ricardo Lopes
The libmysqld is meant to be used as a database server embeded into application, not a replace or a lighter version of a database server, it can´t be used with php to provide a web page to the internet in the way i tink you want. The way of using libmysql is for what i read the same way you would

Re: [PHP-DB] Connect to MSDE using PHP

2004-02-23 Thread Adam Voigt
I have connected to MSDE from PHP and it does work, what I would suggest, is ignore trying to do hostnames, and use IP's, so change the connect line to the IP of the MSDE machine. I know some will say it's not necessary, but I'm just telling you what I did, and it worked fine using the standard

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread user
Ricardo Lopes wrote: The libmysqld is meant to be used as a database server embeded into application, not a replace or a lighter version of a database server, it can´t be used with php to provide a web page to the internet in the way i tink you want. The way of using libmysql is for what i read

[PHP-DB] mail() and sendmail configuration

2004-02-23 Thread dpgirago
Good Morning, This post is somewhat OT -- please forgive me. I've spent over 3 days trying to get sendmail configured and I've lost some patience and reasoning ability in the process. I have a Linux (RH9), Apache 2.0.48, PHP 4.3.4, MySQL GUI that creates a PDF document on the server for web

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Ricardo Lopes
You can use: - txtSQL http://txtsql.sourceforge.net/ Is not provided in php, you have to install it to the folder were you have your scripts or reachable by it. The sintax is not exactly as sql but is similar, the documentation included seems to be very good. I dont know if it does everything

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread user
Ricardo Lopes wrote: You can use: - txtSQL http://txtsql.sourceforge.net/ Is not provided in php, you have to install it to the folder were you have your scripts or reachable by it. The sintax is not exactly as sql but is similar, the documentation included seems to be very good. I dont know if

Re: [PHP-DB] mail() and sendmail configuration

2004-02-23 Thread Jason Wong
On Tuesday 24 February 2004 00:18, [EMAIL PROTECTED] wrote: This post is somewhat OT -- please forgive me. I've spent over 3 days trying to get sendmail configured and I've lost some patience and reasoning ability in the process. I have a Linux (RH9), Apache 2.0.48, PHP 4.3.4, MySQL GUI that

Re: [PHP-DB] mail() and sendmail configuration

2004-02-23 Thread dpgirago
Jason, Thanks for the suggestions. In regard to your question, no. A simple mail() invocation without the attachment does not work, hence my sense that the problem is the sendmail config. I'm in the process of checking the logs and will repost if anything looks promising. David Jason

[PHP-DB] html in mysql

2004-02-23 Thread Cory Hicks
Hello to all! I am a bit confused :-) I have html in mysql for a content management system. I am working on a search function, and have this working fine, however, when my results get returned, there is html code in the results like img src=../images/img.gif..how do I get php to not try and load

Re: [PHP-DB] html in mysql

2004-02-23 Thread Stuart
Cory Hicks wrote: how do I get php to not try and load the image and just give me text in my results only? I have been looking at html special chars...but that's not it.. http://php.net/strip_tags -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] html in mysql

2004-02-23 Thread Cory Hicks
I just found it...strip_tags doh!~ Thanks to all who answered! Cory On Mon, 2004-02-23 at 12:07, Stuart wrote: Cory Hicks wrote: how do I get php to not try and load the image and just give me text in my results only? I have been looking at html special chars...but that's not it..

[PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread user
Howdy -- Would someone point or provide me with an example of PHP + libMysqld (Embedded MySQL server)? My problem is my churchs web site doesn't provide a MySQL database as a default package (add $15.95/mo)for a MySQL Db. TIA, David -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Re: [PEAR] Re: PEAR DB 1.6.0 has been released

2004-02-23 Thread Justin Patrin
Lukas Smith wrote: Justin Patrin wrote: I think you're confusing the issue. PEAR DB does support many databases, but it only loads the code for the ones that you are currently using. So if you're using one database it is effectively a one database API. Jakes wrote: What is performance like

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Voigt
Check these guys out: http://spenix.com/WebHostingPlans.aspx Very cheap, very reliable, great features, and support is second to none I've ever experienced, and before you ask, no I'm not now nor have I ever been an employee or shareholder. =) Just a satisfied customer. On Mon, 2004-02-23 at

[PHP-DB] Re: [PHP] Re: [PEAR] Re: PEAR DB 1.6.0 has been released

2004-02-23 Thread Richard Davey
Hello Justin, Monday, February 23, 2004, 4:11:40 PM, you wrote: JP3) A unified architecture for mysql and Oracle. You don't have to JP remember different functions for use with different databases. That abstraction only abstracts the functions to connect to, select and query the database,

Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread user
Adam Voigt wrote: Check these guys out: http://spenix.com/WebHostingPlans.aspx Very cheap, very reliable, great features, and support is second to none I've ever experienced, and before you ask, no I'm not now nor have I ever been an employee or shareholder. =) Just a satisfied customer. Admin

[PHP-DB] Re: [PHP] Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Voigt
Alright, well with any txt based system, your probably going to run into problems with multi-users (multiple browsers) updating the DB. Reguardless, if you must use txtbased, I recommend SQL-Lite, it supports SQL statements, and is very small and very fast. http://www.sqlite.com On Mon,

[PHP-DB] Re: [PHP] Re: [PEAR] Re: PEAR DB 1.6.0 has been released

2004-02-23 Thread Justin Patrin
Richard Davey wrote: Hello Justin, Monday, February 23, 2004, 4:11:40 PM, you wrote: JP3) A unified architecture for mysql and Oracle. You don't have to JP remember different functions for use with different databases. That abstraction only abstracts the functions to connect to, select and

[PHP-DB] Re[2]: [PHP] Re: [PEAR] Re: PEAR DB 1.6.0 has been released

2004-02-23 Thread Richard Davey
Hello Justin, Monday, February 23, 2004, 5:30:16 PM, you wrote: JP The real hairy part is dealing with joins as the syntax is very JP different across the DBs. This can be solved by simply not doing them or I wish :) JP using a syntax that most use. Or you can try to use DB_DataObject, but JP

[PHP-DB] Re: mail() and sendmail configuration

2004-02-23 Thread Manuel Lemos
Hello, On 02/23/2004 01:18 PM, [EMAIL PROTECTED] wrote: This post is somewhat OT -- please forgive me. I've spent over 3 days trying to get sendmail configured and I've lost some patience and reasoning ability in the process. I have a Linux (RH9), Apache 2.0.48, PHP 4.3.4, MySQL GUI that

[PHP-DB] MySQL-4.x.x and md5 password?

2004-02-23 Thread user
Howdy -- The following code bite, works with MySQL-2.x.x but not with MySQL4.x.x. Any suggestions. One other note, I'm using the DBal (database layer) from phpBB forum. TIA, David - login.php - if ( $_SERVER['QUERY_STRING'] == 'logout' ) { setcookie('lb_user', NULL, time(),

[PHP-DB] how to do query on partial field contents ???

2004-02-23 Thread -{ Rene Brehmer }-
hi gang I've mentioned this project before a couple of weeks ago ... just been busy with school, so haven't had time to work on it that much But anyways ... the test version is running here: http://metalbunny.net/computers/cpudb.php it's running with debug code, which should be obvious if

[PHP-DB] Re: [PHP] Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread user
Adam Voigt wrote: Alright, well with any txt based system, your probably going to run into problems with multi-users (multiple browsers) updating the DB. Reguardless, if you must use txtbased, I recommend SQL-Lite, it supports SQL statements, and is very small and very fast. http://www.sqlite.com

[PHP-DB] Re: [PHP] Re: [PHP-DB] Embedded MySQL server (libmysqld)?

2004-02-23 Thread Adam Bregenzer
On Mon, 2004-02-23 at 23:02, [EMAIL PROTECTED] wrote: Adam, Thanks for your repsone(s) now back the root of the problem. As stated above I need to be able to run the database from with the home direcory/document root? I hesitate to answer this so as to not create a naming confusion but I can