RE: [PHP-DB] Version Upgrade

2004-05-21 Thread Hutchins, Richard
The folks at PHP.NET have an excellent resource to help answer questions like these. Check out this link: http://www.php.net/releases.php#4.3.0 You're going to have to read the material and compare it against what you're doing in your scripts to see if the 4.3.0 release is going to do anything to

RE: [PHP-DB] Version Upgrade

2004-05-21 Thread Angelo Zanetti
I upgraded from mysql version 3.23.54 to version 4.1.1a-alpha and there have been no problems whatsoever, I suggest go to mysql.com for readup, I might not be using all the features and perhaps some of these features might be affected. hope this helps angelo -Original Message- From: Hutch

[PHP-DB] Printing Forms

2004-05-21 Thread Mike Koponick
I have a need to extract data from MySQL via PHP (which I can do easily) but I need to put that data into a form. The current form is a WORD doc, and we type in the information needed and print/PDF/E-Mail the form to the appropriate people. What I would like to do is use the WORD form and place th

[PHP-DB] Re: Printing Forms

2004-05-21 Thread Chris Berlioz
Quick work around: Dump the MySQL data into a comma delimited file and then pick it up with MS Word Document Form to be merged. Then with the MS Task Scheduler I would schedule to open the document to print automatically and/or research with MS to email automatically. CB. === "

[PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
Hi All, I'm looking for some advise/login on developing an Inventory Management system for an ecommerce store and what pitfalls one needs to be on the lookout for. Anything anyone would like to contribute would be greatly appreciated! Thanks in advance! Aaron

[PHP-DB] Re: Printing Forms

2004-05-21 Thread Torsten Roehr
Hi Mike, you could put placeholders into your Word document and then replace them with your MySQL data by opening the file contents and applying str_replace() to all placeholders. Regards, Torsten "Mike Koponick" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I have a need to extra

[PHP-DB] Fedora and php 4.3.6

2004-05-21 Thread Shane I. Hoffman
I'm running Fedora Core 2 release 3 on an ASUS SK8N mother board with the amd64 bit processor. I have apache 2.0.49 and MySQL 4.0.20 Everytime I run make test...it stalls out at the same point: *SNIP* PASS unset($_SESSION["name"]); should work with register_globals=off [ext/session/tests/009.php

Re: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Matt
> From: "Aaron Wolski" <[EMAIL PROTECTED]> Friday, May 21, 2004 10:52 AM > Subject: [PHP-DB] Inventory Management for ecommerce store > I'm looking for some advise/login on developing an Inventory Management > system for an ecommerce store and what pitfalls one needs to be on the > lookout for.

RE: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Hutchins, Richard
I have an e-commerce project coming up in the next quarter and I want to just piggyback (not hijack the thread) one question onto this thread. And that is, don't e-commerce packages come with the functionality to track inventory? I mean, most times when I shop online, I see whether an item is in st

RE: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
No problem on the piggy-back. I do actually have an Inventory Management component in place but it seems to be acting up a little bit here any there. This is what I do: 1) For each product; create an Inventory Record for the product SKU, product_id AND attributes 2) I have 2 "inventory" fields

RE: [PHP-DB] Inventory Management for ecommerce store

2004-05-21 Thread Aaron Wolski
> -Original Message- > From: Matt Schroebel [mailto:[EMAIL PROTECTED] > > What if I abandon my cart? Are you using transactions to make sure all > updates are atomic? All cart records are stored to the database with a timestamp. On each call to the cart_script, I check to see if any re

[PHP-DB] undefined function

2004-05-21 Thread Miguel Guirao
I'm receiving this error: Fatal error: Call to undefined function: mssql_connect() in e:\inetpub\wwwroot\sitio\TMP5w3gxy2pnf.php on line 9 This is line 9:if (!( $con = mssql_connect($maquina, $usuario, $password))) $maquina = "SERVIDOR"; $usuario = "sa"; $password

[PHP-DB] Informix and PHP

2004-05-21 Thread D. Sandmann
Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past on another machine and fixed it by setting the environment variables for INF

[PHP-DB] Re: Informix and PHP

2004-05-21 Thread Torsten Roehr
"D. Sandmann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Any help would be appreciated on this. I have already asked this question on > the regular PHP and Informix news groups and have not had any luck. Maybe > one of you can resolve my problem. > > I have had this problem in th

Re: [PHP-DB] undefined function

2004-05-21 Thread Bruno Ferreira
Miguel Guirao wrote: I'm receiving this error: Fatal error: Call to undefined function: mssql_connect() in e:\inetpub\wwwroot\sitio\TMP5w3gxy2pnf.php on line 9 This is line 9:if (!( $con = mssql_connect($maquina, $usuario, $password))) $maquina = "SERVIDOR"; $usuario = "sa";

RE: [PHP-DB] undefined function

2004-05-21 Thread Miguel Guirao
First, I do not have that line in my php.ini file. In what section should I add it? I forgot, I'm using Windows 2000 Server, SQL Server, PHP4 and coding in DreamweaverMX Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Bruno Ferreira [mailto:[EMAIL PROTECTED] Env

Re: [PHP-DB] undefined function

2004-05-21 Thread Bruno Ferreira
Miguel Guirao wrote: First, I do not have that line in my php.ini file. In what section should I add it? Anywhere, but best place as long as organization is concerned would be under the "Dynamic extensions" label. Bruno Ferreira PS - You should check the default php.ini that comes wit

[PHP-DB] How to select records if any of it's fields match the requirement?

2004-05-21 Thread Amanda
I would like to select the records where any of the fields LIKE '%abc%' Can I do that without knowing the table's column names? If table column names are required, how can I retrieve the column names from the table? Regards Amanda

[PHP-DB] Re: How to select records if any of it's fields match the requirement?

2004-05-21 Thread Justin Patrin
Amanda wrote: I would like to select the records where any of the fields LIKE '%abc%' Can I do that without knowing the table's column names? If table column names are required, how can I retrieve the column names from the table? Regards Amanda Many database engines will give them to you i