Re: [PHP-DB] any extra work need to make php mysql function available?

uncomment the line that enables the extension in your php.ini: extension=mysql.so if it don't work verify the line extension_dir = /usr/lib/php4 and if the file mysql.so is in this directory. Bruno Gimenes Pereti. - Original Message - From: JIM [EMAIL PROTECTED] To: [EMAIL PROTECTED]

[PHP-DB] PHP and Informix under Linux

HI. I have PHP4, Linux Red Hat 7.1, Inofrmix Dynamic Server 7.31 UD1 and Apache. I would like to communicate with Informix from PHP via an ODBC driver. I have the Merant 3.7, but I am not sure that it supports the version of Informoix mentionned above. Do you know if I can use this driver ? If

RE: [PHP-DB] PHP and Informix under Linux

Domonique, To use ODBC from Linux under PHP, you will need to link PHP with a Driver Manager. iODBC is a free, Open Source Driver Manager available at www.iodbc.org. Your configure will have to include --with-iodbc=/path/to/odbcsdk More information is available in the PHP HOWTOs at

Re: [PHP-DB] TREE in a database

Actually relational databases are set-based. The answer to your tree structures question is that it is possible. It is quite complicated though, so have a look at this phphoo tutorial: http://www.webreference.com/perl/xhoo/php1/ Rick Emery [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] What's wrong with my function? :(

Tx. Yep I have read it now and understood it better than the first time I read this part of the manual (it's amazing how things make more sense when you can apply them to what you are doing). Jesse Goerz [EMAIL PROTECTED] wrote in message

Re: [PHP-DB] Learning PHP Sessions

This is really off-topic for this list, but... From my understanding of sessions, you really don't want session_start() in an if{} block. Every time you hit this script, it will have no memory of any session variables until you call session_start(). -Steve On Tuesday, October 30, 2001, at

Re: [PHP-DB] Learning PHP Sessions

* session_register('myvar'); creates a session var called $myvar * session_start(); needs to be called from the top of each script that will need the session var $myvar * session_destroy('myvar'); rids you of $myvar completely. * session_destroy('HTTP_SESSION_VARS'); rids you off *all*

[PHP-DB] HTML Entities and $HTTP_POST_VARS

I'm experiencing a strange problem with HTML entities in form input using PHP v. 4.0.4pl1. My form consists of three fields: - A select pulldown menu (generated from database) to enable users to select an existing record; - A text field in which users enter a headline; - A textarea

Re: [PHP-DB] Learning PHP Sessions

one problem I see, you are trying to populate the variable after you register it. session_start(); $myvar = something; session_register('myvar'); echo $myvar; Jim Lucas - Original Message - From: Russ Michell [EMAIL PROTECTED] To: Steve Cayford [EMAIL PROTECTED] Cc: Matthew Tedder

Re: [PHP-DB] PHP query on date field

Thanks alot... right now I cannot really work on it but I am going to setup a test table to work with so I make sure I get the correct results on the test before I impliment it on our main tables. Thanks again, all of you guys on this newsgroup have been a great help to a newbie like myself. =)

Re: [PHP-DB] any extra work need to make php mysql function available?

Hi, PHP and MySQL are not talking to each other. Numerous tutorials available on the web for getting MySQL, PHP, and Apache to work together... depending on how you installed PHP and MySQL, the method varies. If PHP is compiled with support for MySQL, it may be as simple as uncommenting or

[PHP-DB] Alternative for Union in MYSQL

I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join

RE: [PHP-DB] Alternative for Union in MYSQL

union available in version 4.0 (alpha) now -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 11:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Alternative for Union in MYSQL I had a view on sqlserver which i am trying to convert to work with

[PHP-DB] Re: very strange problem for mysql query

Hello Jim, The problem isn't with the query. It's in the last two printf statements: printf(%s %s $sbr, $row-name, $row-room_num, $row-update_time); printf(%s %s $sbr, $row-name, $row-update_time, $row-room_num); In each line you have two occurrences of '%s' in the format string, while there

[PHP-DB] MySQL: Alphabetizing title results in library format

Back when I was working with MSSQL I need to alphabetize movie titles in the proper library format where 'A' 'An and 'The are ignored. For MSSQL I was told to use: select * from Titles order by case when Title like 'The %' then substring (Title, 5, 255) when Title like 'A %' then substring

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

Petr Tuma wrote: select *,(case when Title like 'The %' then substring (Title, 5, 255) ETC. Alas, MySQL doesn't like that syntax either. :( -- Ian Evans Digital Hit Entertainment - News and Information http://www.digitalhit.com -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] retrieve data from more db

HI, I have data on more than 1 db to separate in year name like these: cust2000-- contain customer infomation in year 2000 cust2001-- contain customer infomation in year 2001 all db have the same field name. I have put db name and table

[PHP-DB] Why do 95% of internet business fail only 5% succeed

Dear Entrepreneur: Can you honestly say that you're earning the type of income you thought you would when you first began your networking career? Unfortunately, the history of networking says that there's a 95% chance you are not earning what you would like to earn. How many different