[PHP-DB] Are you Interested to a PHP C.A.S.E.? (PHP codegenerator for DB Use)

Hi people of PHP ! First of all Excuse me if i use this channel to ask you an little market opinion but it could be very interesting ! I am a little PHP/Linux programmer but I've lot of years of experience in developing C.A.S.E. product for dBase and Sql in DOS/Windows Platform. With this, I am

[PHP-DB] Postgres Library problems

Sorry I am not replying to the thread. I deleted the message, not thinking. If you install PostgreSQL from source, and take the defaults, it puts its files in /usr/local/pgsql/... Each of theses subdirectories matches one in /usr/local/... What I do is create symlinks win /usr/local so I

[PHP-DB] DB Connection Time

Hi I am doing some script timing of a DB connection PHP/Linux to MSSQL thru FreeTDS based on this script timing article: http://www.phpbuilder.net/columns/akent2926.php3 I am getting a time of 200-250 milliseconds compared to sub-50 ms using ASP/W2K/MSSQL. Any idea on what is generally

[PHP-DB] DB Connection Time

Hi I am doing some script timing of a DB connection PHP/Linux to MSSQL thru FreeTDS based on this script timing article: http://www.phpbuilder.net/columns/akent2926.php3 I am getting a time of 200-250 milliseconds compared to sub-50 ms using ASP/W2K/MSSQL. Any idea on what is generally

[PHP-DB] Retrieving a PDF file from a MySQL Database

Hello, I'm having trouble with getting a PHP script to pull a file (a PDF file) out of a MySQL database. I don't know if the problem is the insertion or the retrieval, but I'll try to paste as much code as I can to hopefully reveal to someone more skilled in PHP than I what the problem is. The

[PHP-DB] Wrong solution!!!!

Hello, I really do appreciate your help. But, I found out that the solution scrip that you gave me was wrong script for my purpose. I guess I didn't describe my problem right. I didn't mean to get the total number of rows to compare. Let's say I have a table name inventory and contains two

RE: [PHP-DB] Wrong solution!!!!

I assume you want to do this instead..try it: ?php $itemx = 15109; $sql = SELECT quantity FROM inventory WHERE item = '$itemx'; $result = mysql_query($sql,$link); $row = mysql_fetch_array($result); // you have to fetch the result into an array to access the info in the db $num = $row[quantity];

Re: [PHP-DB] Wrong solution!!!!

T $itemx = 15109; T $num = mysql_query(SELECT quantity FROM inventory WHERE item = T '$itemx',$link); T if ($num 1) { T echo bfont color=\#FF\Out of Stock $result/font/b; T } else { T echo bfont color=\#FF\In Stock $result/font/b; T } T I want my inventory quantity with

[PHP-DB] Thank you all for your help!!!

I tried both Julie's and David's script, and David's script worked. But, I do appreciate both of you and Chris for great help. Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP-DB] Now, I have new problem!!

My server has a cgi-local bin, where all of my cgi scripts have to be stored in there. When I input the script into my regular html pages, it doesn't work. This is the script that I am using and saved as inventory.php, ?php $link = mysql_connect(,x,x) or die (Could not

[PHP-DB] Apache cant load libiodbc.so.2

Hello: I am trying to set-up odbc on my RedHat 7.1 Server. I want the PHP as a DSO for apache. Here is what I did: Logged in as root cd /usr/local Downloaded the file ftp://www.openlinksw.com/open40/l3ko.taz mkdir odbc cd odbc tar zxvf ../l3ko.taz cd /usr/local Downloaded the php