[PHP-DB] Re: [PHP] the opposite of a join?
[EMAIL PROTECTED] wrote: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose ID is NOT linked to in the contact table? Basically, the opposite of a join? SELECT * FROM company WHERE id NOT IN (SELECT companyID FROM contacts); -- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 - Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática| '@' || 'unl.edu.ar'; Universidad Nacional| DBA, Programador, del Litoral | Administrador - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] fetch row DISTINCT
On Fri, 9 Jul 2004, Peter Westergaard wrote: One idea that occurs to me, and it's a tradeoff from Torsten's idea (which is to read the whole database, and parse out the unique rows), is to first execute your SELECT DISTINCT distinct_col FROM table, and then walk through that, and for each one issue a SELECT * FROM table WHERE distinct_col = {value} LIMIT 1 (For some reason I can't remember the 'LIMIT' syntax right now, so it might be LIMIT 0,1). More transactions with the database, but less data actually retrieved from the database. And if it's indexed by distinct_col, you should be fine. It´s not to start a war, but after having to hear so much about how good MySQL is. What you need is a database with sub-select capability, or to have a feature like: SELECT DISTINT ON(col1), col2, col5 FROM table1 WHERE... People say that they don´t need sub-selects (transactions, procedural languages, etc.) just because the don´t have an idea of the power that the hold. Just a par of cents on my part. -- 19:55:02 up 8 days, 11:32, 2 users, load average: 0.12, 0.15, 0.10 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Informix and PHP
El Vie 21 May 2004 14:48, D. Sandmann escribió: 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 INFORMIXDIR and INFORMIXSERVER. When adding the same lines on the new machine I still get the following message: Warning: ifx_pconnect(): E [SQLSTATE=IX 001 SQLCODE=-1829] in C:\webroot\PHPinclude\db_vars.inc on line 7 Maybe it's becuase Informix has some problems. I don't know how it works on windows, but on UNIX I would run: $ finderr -1829 That would give me a discription of the error that Informix gave Apache. Try it. -- 09:20:02 up 7 days, 19:31, 1 user, load average: 0.60, 0.49, 0.37 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] From MySQL to PostgreSQL
El Vie 07 May 2004 22:49, Marcjon Louwersheimer escribió: Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on my computer, for version for myself and another for a school I volunteer at. I would like to move the forums to the school's server. Apperently they don't have MySQL, they have PostgreSQL. I was just wondering, how much like MySQL is PostgreSQL? Would it be possible to create general functions (MySQL style) that could also work for PostgreSQL, based on what a config file set? Right now I have a file that's specific to each forum, so I could specify PostgreSQL or MySQL and based on that the function would do the appropriate action. So how much like MySQL is PostgreSQL? I think you should check PEAR::DB to get some DB abstraction. -- 09:30:01 up 9 days, 14:52, 1 user, load average: 0.27, 0.39, 0.45 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PostgreSQL lib and character case
El Wednesday 28 April 2004 03:21, Tumurbaatar S. escribió: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? No. PHP is case-sensitive, so you have to use lower case (unless you made the relation name case-sensitive when you created the PG table). -- 19:21:02 up 43 min, 6 users, load average: 1.46, 0.73, 0.58 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Anybody using PostgreSQL?
El Mié 14 Abr 2004 07:39, Tumurbaatar S. escribió: In PHP5 manual, it says that when using large objects functions of PostgreSQL, a program should manually begin/end transaction. But what about other query/exec functions? Do I need to control transactions or every function call implicitly wrapped with transaction block? What if a command consists of several SQL statements or a command calls a user-defined function which also executes several statements within its body? Havn't checked out PHP5 yet, but in PEAR::DB (at least in the latest versions on PHP4) all transactions are enclosed between BEGIN and END individualy or in groups. -- 18:01:01 up 36 days, 22:28, 2 users, load average: 0.41, 0.54, 0.50 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] multi-language site
Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your help Martin, I am aware of the seperation stuff you are talking. There is a much more professional term for that 'Design Patterns' use in JAVA (I tell you as a JAVA professional).. I am also aware of need for code and design seperation.. Really looks like I've been reading the J2EE tutorial lately. :-) What I meant here is that NOT every project needs this! If you are on a small project it is much easier to write straight forward, without making this hard seperation.. By the way thanks for HTML_Template_IT advice.. I will check that out. If you have any other advice I am waiting.. What do you think guys how it is better to seperate PHP code from Design (HTML)? I personally put all the .html files (no PHP code in them) in a directory separated from the rest of the PHP files (there are other directories as well). Lately I'm using the same template (the .html file) for several pages, if the similarity is very high. As the different parts of the aplication are being finished, the html templates are passed to the person how does the design (look and feel), who knows exactly what parts of the HTML can't be touched. Puts them back and sees how they look. :-) P.D.: You forgot to add the list to the recipients of the last mail. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fw: informix problem
Mensaje citado por stefan bogdan [EMAIL PROTECTED]: i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client for nt ilogin demo works fine sql editor works fine but when i try to connect to informix via php i'get an error like Warning: ifx_connect(): E [SQLSTATE=S1 001 SQLCODE=-406] This is not a PHP problem. The problem is in the Informix server: [EMAIL PROTECTED]:~ finderr -406 -406Memory allocation failed. Something in the current statement required the allocation of memory for data storage, but the memory was not available. Several things can cause this error. For example, your application has a memory leak; you are asking for more resources than the system is configured to allow; or a problem with the UNIX system itself requires rebooting the system. Roll back the current transaction. Look for ways to make this statement simpler or move less data. Also, confer with your UNIX system administrator to solve memory problems or look for ways to make the operating system give this program more virtual memory in which to run. On DOS systems, exit to the operating-system command line, free some disk space, and resubmit your program. i have 256MB memory and 20 GB hard (6GB free) It doesn't matter how much you have, but how much you assign to Informix to use as virtual memory. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Subselect ?
Mensaje citado por Christine Clerc [EMAIL PROTECTED]: Well, I had tried this : SELECT DISTINCT id_script FROM readme WHERE id_language = $languageorignin; But then I have to do this with the selection : SELECT DISTINCT id_script FROM readme WHERE id_language != $languagetarget; but it cannot work since I get back the id_script from the first selection ! See a sample of the table : id_readme, id_script, id-language 1, 2, 4 2, 3, 1 3, 3, 4 4, 4, 4 All the scripts are in english, but one has been already translated into French. I want to say to the translator that works from english to french, 1) you have script 2 and 4 to translate 2) you can rewrite the translation of script 3 (this second question I have manage with creating a temporary table). I don't think the newest version of mysql will be on the server. I think the problem was the selection of the database server. If you need special features like sub-select you shouldn't have chossen MySQL. By the way, I think it may be posible to build a query that does what you want, but it would involve UNION and lots of quiery work. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] multi-language site
Mensaje citado por Muhammed Mamedov [EMAIL PROTECTED]: Thank you for your comments Ignatius. (just to note) : I do not agree that all projects SHOULD require CLEAR sepeartion of code and appearance. Let me disagree with you! :-) I a multi-tiered design yuo have a client layer, a server layer (this should be the PHP pages on the server), and the database layer (simply for storage). Now, the server layer is easier to maintain if you have it devided in a buissness layer and a presentation layer. The presentation layer should have programs that print the results. Now, to make it even easier to maintain your code, abstraction of HTML code from the PHP code is the best way to go. It make the PHP more readable, and the HTML easy to edit by non programmers. Further on this issue: Consider that there are lots of dynamic stuff like news, and there are thousands of users and all data is stored in a database. Currently data is stored as a simple text. And I want to provide users (or their graphic editors) to display these news on their page in the way they like. So, to achieve this task I need a nice seperation of code and design. We may not achieve a 100% seperate work, but at least a graphical designer (who doesn't know any PHP) has to be able to develop a new design for his customers (our user) with ease. I think you should point to HTML_Template_IT (pear.php.net) -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Solaris apache 2.0.47 + php 4.3.4 + oracle 9i ( oci8 support in php as shared module )
Mensaje citado por Daniel Sand [EMAIL PROTECTED]: Hi Folks, I have an generic question. first of all. The stuff runs fine. But ( the question ? ) If i make any DB connections from any Virtual Server that i configured in apache, PHP always takes the Main Ethernet Interface. Not The Virtual IP's of the card that are configure in the httpd.conf. This isn't a real problem, maybe it's allready solved. I'm not sure. But is their a way to declare over which ip PHP calls the Oracle Database ? I think no. By the way, Solaris has some obscure ways of working with multiple net interfaces. or even if this not exists, should their not be a way to delcare this. Im thinking of in a secure reason, i think it should. Why would you think that there's a risk? If you have control over your server you shouldn't have any trouble (always speeking as an unknowledged person to Oracle configuration). -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database abstraction
Mensaje citado por Malte Starostik [EMAIL PROTECTED]: Hi, I've read several posts touching this subject, but I didn't find one that asks a simple question I've been wondering about since I first used PHP and that is also one of the two really really bad things about PHP (the other being lack of OO): PHP5 deals with this. http://ar.php.net/manual/en/faq.general.php#faq.general.relation-versions Why isn't there a DB abstraction layer right in PHP, so people writing some web app for redistribution don't have to care about the different DBs themselves? Use PEAR::DB or PEAR::MDB. Why is there no modularization in this area, such that it'd be the _normal_ way not to write things like $dbh = ibase_pconnect( ... ), but $dbh = sql_connect( Firebird, ... ) With PEAR::DB all you have to do is build a string like this: $dsn = pgsql://username:[EMAIL PROTECTED]/database_name; And I will be running PostgreSQL so that later all I have to do is: $db = DB::Connect($dsn); $db-query(SELECT * FROM tabname); and that would internally check if a Firebird/InterBase driver is available and if so, use it. Surely there are some differences in SQL conformance and syntax extensions, but even that could be handled by such a layer to some extent. See this: http://pear.php.net/manual/en/package.database.db.intro-dsn.php -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Database abstraction
Mensaje citado por Jason Wong [EMAIL PROTECTED]: Whilst there isn't a builtin database abstraction layer in PHP itself there are a number of projects which fills the gap. There's the semi-official PEAR-DB, also ADODB and Metabase. Why is it you say it's semi-official? I have always felt PEAR as much official. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] EMERGENCY!!
You throw code to the list with no information about what errors or warnings you got. Why do you say it doesn't work? What happens when you run the script? El Mié 31 Dic 2003 12:46, John Greco escribió: I am trying to build a web site for our inventory. I have a mysql DB that i connect to. The following code is what I use. The array products wont go past I tried this first: $sql5 = select * from product where whseNum = '.$whseNumber.' order by prodNum; $result5 = mysql_query($sql5, $conn) or die (mysql_errno() . : . mysql_error(). \n); while ($row5 = mysql_fetch_array($result5)) { $products[] = $row5['prodNum']; } foreach ($products as $prodNum = $value) { $sql4 = UPDATE product SET physCount='.$_POST[$value].' WHERE prodNum='.$value.' AND whseNum='.$whseNumber.'; $result4 = mysql_query($sql4, $conn) or die(mysql_errno() . : . mysql_error(). \n); echo (In the loop: .$value); } Then I tried this: $sql5 = select * from product where whseNum = '.$whseNumber.' order by prodNum; $result5 = mysql_query($sql5, $conn) or die (mysql_errno() . : . mysql_error(). \n); while ($row5 = mysql_fetch_assoc($result5)) { $products[] = $row5['prodNum']; $sql4 = UPDATE product SET physCount='.$_POST[$value].' WHERE prodNum='.$row5['prodNum'].' AND whseNum='.$whseNumber.'; $result4 = mysql_query($sql4, $conn) or die(mysql_errno() . : . mysql_error(). \n); echo (In the loop: .$row5['prodNum'].br); } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] EMERGENCY!!
El Mié 31 Dic 2003 16:25, escribió: He surelly has problems with his DB server. Does the script die? I am outputting mysql_error() nothing is showing up. Hows the mysql logs? I don't know where these are. is there some kind of high load on the DB server? I am the only one on it right now. Please try to reply in a way that I can see what part of the message is from whom, and reply to the list also. 1) You defenetly need to read the Manuals of your database (MySQL in this case), and try to get help from a MySQL user-list.[1] 2) The load has nothing to do with who is or not on the server. If the MySQL server is on linux, put top on a shell from that server and see if any MySQL child loads up. You may have a lock or something that prevents the update from finishing. [1] I am a PostgreSQL user and in the PG lists there has been lots of disscution about how good the tutorials are for the newbies. I personally think that the big problem with newbies is that they just don't read. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Skipping a row
El Jue 18 Dic 2003 18:27, John Greco escribió: I have a select statement that goes to my mySQL db and selects some data from there. I thought it was working great BUT it is skipping the first row. Any ideas? I know it has to be somehting simple I am missing. Depends on how you are fetching your rows. I think you have to start with the row 0 on some databases. I personally don't have to think much of that since I use PEAR::DB. :-) -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Something ease... I guess
El Mar 16 Dic 2003 10:44, Nikos Gatsis escribió: Hello list I have 4 variables, $check1, $check2, $check3, $check4 How can i use a for loop to echo each one. (lets say echo $check($i)...) foreach(list($check1, $check2,...) AS $c){ echo $c; } -- 15:20:02 up 16 days, 21:36, 3 users, load average: 1.37, 0.91, 0.69 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Informix - help!
El Dom 14 Dic 2003 19:00, Daniel Crespo escribió: I have red hat linux with Apache web server and PHP. I want to connect, using PHP, to an Informix Database remotely. What is all I have to do on my side? Thanks a lot Install informix client libraries where php will go and compile using --with-informix. Remember to add the environment informix variables (can't remember which ones they were) before running configure. You will also have to give permission of access in the informix server to your web server. -- 15:20:02 up 16 days, 21:36, 3 users, load average: 1.37, 0.91, 0.69 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pg_result_error()
El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into - $sql = 'INSERT INTO .'; $result = pg_query($conn_id, $sql); if ($result === false) { var_dump( pg_result_error( $result ) ); I would use here this: die(pg_result_error( $result )); } According to the manual, pg_result_error takes the result resource. If that resource is boolean false for one reason or another, then pg_result_error isn't useful. Anyone has any other ideas, besides using pg_last_error()? Did you try it? -- 08:43:01 up 16 days, 14:59, 2 users, load average: 0.20, 0.37, 0.36 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pg_result_error()
El Vie 12 Dic 2003 11:19, Gerard Samuel escribió: Im going to CC this to the PostgreSQL list also. On Friday 12 December 2003 06:44 am, Martin Marques wrote: El Vie 12 Dic 2003 00:09, Gerard Samuel escribió: What good is this function? A quick example of the wall Im running into - $sql = 'INSERT INTO .'; $result = pg_query($conn_id, $sql); if ($result === false) { var_dump( pg_result_error( $result ) ); I would use here this: die(pg_result_error( $result )); That is fine and all, but my original example was just an example of the non functionality of pg_result_error(), not how to handle errors when a query fails. But for arguement sake, lets use your example in some dummy code[0]. $result is still boolean false, and pg_result_error() will still return an empty string, and using die, would just die, with no report of what happened. Then whats the use of pg_result_error(). Looks like you are totally right. Tried it and it works horrible. Any idea on why this is like this? P.D.: I had to pass my php4 in Debian to unstable to get a workable (with the newer capabilities) version. Very annoing, especially becuase I had to pass apache to unstable as well. :-( -- 12:13:01 up 16 days, 18:29, 3 users, load average: 1.32, 0.90, 0.67 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Very complex query
El Jue 11 Dic 2003 05:00, Muhammed Mamedov escribió: You can also DISTINCT command instead. UNIQUE command isnot supported by mySQL (at least at MySQL 3.23.41- I am using) UNIQUE is for table creation or index creation. It is relevent for insertion, not selects. DISTINCT and DISTINCT ON() are used in SELECT statements. -- 15:49:01 up 15 days, 22:05, 3 users, load average: 1.12, 0.79, 0.61 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Very complex query
El Jue 11 Dic 2003 05:17, Mike U. Petrov escribió: No, DISTINCT isn't match my purpose cause of it rerurns unique rows but I need ONE user_id per one object_id. GROUP BY is your answer. -- 15:51:02 up 15 days, 22:07, 3 users, load average: 0.90, 0.75, 0.61 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Very complex query
El Jue 11 Dic 2003 05:30, Mike U. Petrov escribió: I tried to use GROUP BY and it worked almost right but i need to return user_id and mysql generated an error that notes.user_id isn't used in GROUP BY... Add it to the GROUP BY. -- 16:33:02 up 15 days, 22:49, 4 users, load average: 0.03, 0.32, 0.46 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] RE: select inside a while loop
Sorry, just say the message. Your code looks well. But is the variable $db the name of your database or your link-identifier. When it is the name of your database i'm not really surpised your code wouldn't work. mysql_query requires as second argument a link identifier. Read what Rolf says. Very wise words here. :-) So with all that said here is what i have done that doesn't work, $result = mysql_query(SELECT artist_id FROM songs,$db) or die(mysql_error()); if ($row = mysql_fetch_row($result)){ do { $artist_name = $row[artist_id]; $result_1 = mysql_query(SELECT artist_id,artist_name FROM artists WHERE artist_name = '$artist_name',$db); $row_1 = mysql_fetch_array($result_1); Why don't you make one query with a union between the 2 tables and then pass through the results with a loop and maybe an if inside it? Ypou are making to many connections to the DB. P.D.: Any way, your problem will be solved with Rolfs advice. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] date function
1) Why do you send this to a DB list? 2) Try seeing the Date class of PEAR (PEAR::Date). El Dom 02 Nov 2003 19:13, OpenSource escribió: Hi guys, This might not be the best place for this but here goes. I want to create a dropdown list with a date range of -- SELECT name=bdate OPTION value=11/02/2003 SELECTEDToday OPTION value=11/01/2003Yesterday OPTION value=10/31/2003Fri 10/31 OPTION value=10/30/2003Thu 10/30 OPTION value=10/29/2003Wed 10/29 OPTION value=10/28/2003Tue 10/28 OPTION value=10/27/2003Mon 10/27 OPTION value=10/26/2003Sun 10/26 OPTION value=10/25/2003Sat 10/25 OPTION value=10/24/2003Fri 10/24 OPTION value=10/23/2003Thu 10/23 OPTION value=10/22/2003Wed 10/22 OPTION value=10/21/2003Tue 10/21 OPTION value=10/20/2003Mon 10/20 OPTION value=10/19/2003Sun 10/19 OPTION value=10/12/2003Sun 10/12 OPTION value=10/05/2003Sun 10/5 OPTION value=09/28/2003Sun 9/28 OPTION value=09/21/2003Sun 9/21 OPTION value=09/14/2003Sun 9/14 OPTION value=08/31/2003Sun 8/31 OPTION value=08/01/2003Fri 8/1 OPTION value=07/02/2003Wed 7/2 OPTION value=06/02/2003Mon 6/2 OPTION value=05/03/2003Sat 5/3 OPTION value=04/03/2003Thu 4/3 OPTION value=03/04/2003Tue 3/4 OPTION value=02/02/2003Sun 2/2 OPTION value=01/03/2003Fri 1/3 OPTION value=12/04/2002Wed 12/4 /SELECT -- I would like to know i can go about doing that. some examples, or if anyone has a function already the i could use. Thanks in advance, -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pg_connect() problem with postgresql 7.3.4
El Mié 29 Oct 2003 07:14, S.P.Vimala escribió: Hi, I have installed posgresql(serve/libs)-7.3.4 on my linux machine. It has httpd-2.0.40-8 php-4.2.2-8.0.8 php-pgsql-4.2.2-8.0.8 Now pg_connect on my code gives me an error undefined function call. I tried to upgrade to php4.3. But this gives me a lot of dependencies errors. phpinfo() gives me a message of database support for postgresql but there is no seperate row for postgreSQL Support as i used to get before. But php-pgsql is installed. I don't get it. Is there or isn't there messages for PostgreSQL in phpinfo()? I have php 4.1/apache in windows and the postgresql db on linux machines and so the application is running on windows. But the same if ported to linux gives me problem. I cannot downgrade my database. So can anybody help? Restarted apache? Checked that the line that loads pgsql.so in uncommented? -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PostgreSQL, Triggers
El Dom 19 Oct 2003 13:54, Ling escribió: Hello there. Can anybody help me with Postgresql triggers? what I need is a trigger which inrements value in field total_rows.rows if I insert new row in table zzz... CAREATE TABLE zzz ( ... ... ); CREATE TABLE total_rows ( table_name VARCHAR(32), total_rows BIGINT, CONSTRAINT pk_total_rows PRIMARY KEY(table_name, total_rows) ); A rule would be much easier: CREATE RULE rule_name AS ON INSERT TO zzz DO Write an update of total_rows query here; -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL File Insert???
El Dom 12 Oct 2003 17:36, John Ryan escribió: Ive a file on my server with SQL instructions to create a table and insert stuff. How do I get this to be run on the database? Once againg, somebody that doesn't specify which database server he is using Pleas, be more specific! -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Confused
El Dom 05 Oct 2003 12:44, Robin Kopetzky escribió: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it right. Specifically, I need the user to CONNECT, SELECT, INSERT, UPDATE, DELETE and that's all for privileges. You didn't give information on which database you're talking about, but any way, I'll give you the Standard SQL way: GRANT SELECT ON table_name TO commerce; This always if the user already exists. :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Confused
El Dom 05 Oct 2003 13:07, Jason Wong escribió: On Sunday 05 October 2003 23:44, Robin Kopetzky wrote: I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What GRANT statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it right. Specifically, I need the user to CONNECT, SELECT, INSERT, UPDATE, DELETE and that's all for privileges. Any help is appreciated. This has *nothing* to do with PHP, try asking on the MySQL list. ^ He never said it was on MySQL. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telemática Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] numeric in plpgsql function
El Mié 01 Oct 2003 22:45, Gezeala 'Eyah' Bacuño II escribió: Saw this in the Postgresql manual : Chapter 8. Data Types Some of the operators and functions (e.g., addition and multiplication) do not perform run-time error-checking in the interests of improving execution speed. On some systems, for example, the numeric operators for some data types may silently cause underflow or overflow. is this a bug or what?? If it's documented, then it's a feature. As you see, it's to gain speed. Remember that this is a database engine, not a scientific aplication. -- 09:29:01 up 41 days, 1:11, 3 users, load average: 2.44, 1.83, 1.08 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php and MySQL and PostgresSQL at the same time
El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió: Is it possible to use PHP under one Apache WEB application in order to access MySQL and at the same time PostgreSQL? different databases ? Depends on how the question was made. Yes you can access diferent database engines from the same PHP (if you have the modules loaded (or built-in support)). What you can't do is access simultanously both databases in one query. -- 09:31:01 up 41 days, 1:13, 3 users, load average: 1.77, 1.75, 1.13 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
El Lun 15 Sep 2003 17:47, Jonathan Villa escribió: I believe this would need php to installed as a cgi, which I prefer not to do... If you don't want to because of security resons, please install it and don't leave it in the hands of the web server. If you don't want to go through the problem of compiling, then you might think about finding on the net a binary PHP for you operating system. -- 08:55:02 up 25 days, 45 min, 4 users, load average: 0.71, 0.51, 0.50 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connect to Oracle DB
El Vie 12 Sep 2003 18:36, Frederico Madeia escribi: Martin, In some doc that i've read when i compile the php i must put yhe $ORACEL_HOME path, so if oracle isn't instaled on same machine ??? Lets see. I don't use, or ever used Oracle, but I guess my experience with Informix and PostgreSQL can enlight a bit. All you need, and yes you need it, is the client, or libraries to be able to conect to the Oracle server on the other side. I don't know how Oracle packages it's product, but on Informix you have quite distinguish where the client is, with it's libraries, and the server. On PostgreSQL, specially on sistems like RedHat or Debian, it even more simplier. Look at this out put form my RedHat machine at home: $ apt-cache search postgresql | grep postgresql postgresql - PostgreSQL client programs and libraries. postgresql-contrib - Contributed source and binaries distributed with PostgreSQL postgresql-devel - PostgreSQL development header files and libraries. postgresql-docs - Extra documentation for PostgreSQL postgresql-jdbc - Files needed for Java programs to access a PostgreSQL database. postgresql-libs - The shared libraries required for any PostgreSQL clients. postgresql-odbc - PostgreSQL ODBC driver. postgresql-pl - The PL procedural languages for PostgreSQL. postgresql-python - Development module for Python code to access a PostgreSQL DB. postgresql-server - The programs needed to create and run a PostgreSQL server. postgresql-tcl - A Tcl client library for PostgreSQL. postgresql-test - The test suite distributed with PostgreSQL. As you can see, the server is in postgresql-server. It needs postgresql and postgresql-libs to run. But on the client (where you have PHP installed) all you need is postgresql-libs (PHP compiles and links against the libraries of that package). I hope I didn't get much out of the road on you, but I guess it was the closest example I could find. Hope it helps you, and if you still have problems, I would suggest you ask some Oracle expert (or even better, read the docs) what you have to have installed to have a Oracle client that will conect to a remote Oracle server. -- Porqu usar una base de datos relacional cualquiera, si pods usar PostgreSQL? - Martn Marqus |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connect to Oracle DB
El Sb 13 Sep 2003 03:56, Jack van Zanen escribi: Hi I don't know how this shared library works, but to the best of my knowledge you'll always need oracle client software (SQL*Net) installed on the php server to connect to an oracle database . Please correct me if I'm wrong and point me to the docs. As I stated before I now little about Oracle. You surely need the client software, but that is exacly where the Oracle libraries should be. To compile PHP with support for any database (not onlt Oracle or PostgreSQL), you need the header files, and the libraries to link PHP against. What you don't need is the server aplication. That can be in another machine, which would be the DB server. -- 09:57:01 up 22 days, 1:47, 3 users, load average: 0.45, 0.68, 0.53 - Martn Marqus |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connect to Oracle DB
El Vie 12 Sep 2003 15:52, Frederico Madeia escribi: Dear friends, How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). In php.net describe some functions to connect to oracle,. but how i make to do work ??? I must install oracle on same server that runing php ?? 1) Oracle and PHP can be on different servers (in some cases it's better to have them separeted). 2) they don't even have to be on the same OS, even though it's a good idea. 3) Your erro is due to the fact that you don't have an oracle-featured PHP installed, so you have to recompile PHP with the --with-oracle option, or try to get a shared library for oracle support for your PHP version. -- Porqu usar una base de datos relacional cualquiera, si pods usar PostgreSQL? - Martn Marqus |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How to exclude the result of union of two tables from the result of union of other two tables
This can be done in one query using subselects. El Vie 05 Sep 2003 15:49, John W. Holmes escribi: Oz wrote: I have a php page where I would like to list a numer of companies as below: 1- retrieve all distinct company names from TableA (SELECT company_name FROM TableA) CREATE TEMPORARY TABLE temp1 SELECT DISTINCT(company_name) FROM TableA 2- retrieve all distinct company names from TableB 3- combine the two lists as list1 INSERT INTO temp1 SELECT DISTINCT(company_name) FROM TableB 4- retrieve all distinct company names from TableC CREATE TEMPORARY TABLE temp2 SELECT DISTINCT(company_name) FROM TableC 5- retrieve all distinct company names from TableD 6- combine the two lists as list2 INSERT INTO temp2 SELECT DISTINCT(company_name) FROM TableD 7- display company names in list1 that don't exist in list2 SELECT t1.company_name FROM temp1 t1 LEFT JOIN temp2 t2 ON t1.company_name = t2.company_name WHERE t2.company_name IS NULL MySql version is 3.23.56 3.23.56 , so I cannot use UNION. I would like to accomplish this with as little php code as possible, using mostly SQL. How about using all SQL? :) All of this is in the MySQL manual, btw... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- Porqu usar una base de datos relacional cualquiera, si pods usar PostgreSQL? - Martn Marqus |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Set autocommit to off/on from PHP
El Mar 02 Sep 2003 08:05, Joanna Owczarzak escribió: PHP 4.1.2, postgreSQL 7.1.3. How to change autcommit property of postgreSQL database from php script? $db = DB::Connect($dbn); $db-autocommit(false); Saludos... :-) P.D.: They should document this. -- 18:26:01 up 12 days, 10:16, 4 users, load average: 0.48, 0.46, 0.34 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP, MySQL and Apache 2 ?
El Mar 02 Sep 2003 16:11, David Haines escribió: This is maybe a bit Off-topic, and yet I could think of no better place to ask: How many of you are using PHP with MySQL and Apache 2 ? I know there _were_ some problems, but do the current (stable) PHP and MySQL work fine with Apache 2 ? Have a client machine with Redhat 9, and Apache 2 gets installed... There is a lot on there I'd really rather not have to do again from scratch (as in: wipe and start over and manually install Apache 1.3) It's not my production server, just my home machine, but I sometimes give it a bit of a load :-) and I have RH9 with the httpd that comes with it, but using PostgreSQL. No problems so far. -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Beta 2 of plPHP released.
El Vie 29 Ago 2003 06:15, Ford, Mike [LSS] escribió: On 29 August 2003 05:27, Joshua D. Drake wrote: Hello, Beta 2 of plPHP has been released. This version contains many bug fixes. For example, if you write bad plphp code and try to execute it, the code will no longer crash PostgreSQL ;). It would be nice if you told us what plPHP actually is as part of this message -- save those of us who have no interest in whatever it is having to make an unnecessary click through to your Web site. plPHP is the PHP Procedural Language for PostgreSQL. So now I can write PHP code inside my database as Procedural Language, which takes a lot of load out of my aplication, and suites me great, because I don't have to write my PL code in perl or plsql Saludos... :-) -- 08:38:02 up 7 days, 28 min, 4 users, load average: 0.94, 0.81, 0.55 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Failure Notices When Posting to List
El Vie 29 Ago 2003 11:51, Hutchins, Richard escribió: Is anybody else getting returned mail notices from the qmail-send program at pb1.pair.com? I seem to get one with each post I send to the list and I don't know what's happening with my posts. Not that they're pure gold or anything, but could somebody just confirm that my posts are getting through to others on this list? Yes, I already sent a mail to the postmaster, but without any answer. Hope they fix it. Any way, mails get to the list, so I really don't understand it. -- 11:52:01 up 7 days, 3:42, 5 users, load average: 0.82, 0.86, 0.61 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL, PHP or ghost?
El Mié 27 Ago 2003 11:34, Ignatius Reilly escribió: Hmmm... You have a point; the doc is not quite clear. Illegal YEAR values are converted to My understanding is that any illegal value will be first converted into '', then into the corresponding year inside the 1901-2155 interval, ie 2000 Well, all this is quite logical. I have no quarrel with this behaviour. Not at all. This is totally ilogical. Wrong date values should give error messages. See what happens when you try to bend a bad input value: http://archives.postgresql.org/pgsql-general/2003-07/msg00599.php Please don't use MySQL in monetary aplications!! -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL, PHP or ghost?
El Jue 28 Ago 2003 11:25, Ignatius Reilly escribió: Well, it IS logical provided one is aware of the rules of the game, meaning, as you rightly point out, that MySQL does not reject SQL statements for incorrect values, but attempts at converting them at any price. I have no clue whether it is or not a shortcoming of the implementation (I do not know what SQL-92 says about this). Therefore data validation should be done outside MySQL. The thing that IS ilogical is the way MySQL plays the game. What would you think if all of a sudden the date command in linux did something like that (try to add some strange date when the given date isn't a valid date)? Now lets suppose this is a good idea, and one would have to program to get the data integrity (data integrity isn't only when the database server fails). Then why do I have to put different data types? Let's use text everywhere! Or if I do use different data types, what if I have a bug? I could have people loading erronous data in the database and not getting an error, and after loading lots of information I find the bug, but see that all the data is bogus (like the numeric example I gave earlier). To state it more clearly, I havn't seen Oracle, Informix or PostgreSQL do things like this, which reminds me of what someone told me once: MySQL is just a FS with an lousy SQL language (and pretty incomplete). Maybe the problem is that most people never read Codd's 12 rules for a RDBMS: http://www.byte.com/art/9406/sec8/art11.htm -- 16:23:01 up 6 days, 8:13, 4 users, load average: 0.16, 0.31, 0.18 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL, PHP or ghost?
El Jue 28 Ago 2003 17:20, Ignatius Reilly escribió: Well, you're certainly right (except I didn't get the meaning of 'FS' - anything obscene?). However: File System. 1. The job of this ML is to help people get things done 2. For criticisms concerning the design of MySQL, you may get better results posting directly at the MySQL dev team. 3. You may decide that another RDBMS may suit your needs better. Someone told me that Oracle is quite nice. Except for (2), I have the same opinion as you have. My mail was because I got really disturbed while reading the mail, and I think people should know about other was of designing an SQL application (or even better was of designing your PHP app). Hopfully I will be giving a 2 hour course at the Linux meeting here at my local city (Santa Fe, Argentina) about using PEAR (or other tools of abstraction) to get better, and easier to maintain PHP programs. And to finish, I don't have the same opinion as you have on (2) because I have read to much junk from the MySQL dev team (things like primary keys are useless). Just my 2 cents. P.D.: Yes, Oracle is pretty nice. -- 17:57:01 up 6 days, 9:47, 4 users, load average: 0.96, 0.75, 0.57 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] INFORMIX PROBLEM
El Mié 27 Ago 2003 16:01, Luigi Vellucci escribió: Hi I'm trying to compile php 4.1.2 from the source RPM in RedHat 7.3 but I wasn't succesfully. Please does anybody know what it means the following error: *** Warning: Linking the shared library libphp4.la against the non-libtool *** objects /opt/informix/lib/esql/checkapi.o is not portable! /bin/sh /usr/src/redhat/BUILD/php-4.1.2/build-cgi/libtool --silent --mode=link gcc -I. -I/usr/src/redhat/BUILD/php-4.1.2/ -I/usr/src/redhat/BUILD/php-4.1.2/build-cgi/main -I/usr/src/redhat/BUILD/php-4.1.2 -I/usr/src/redhat/BUILD/php-4.1.2/build-cgi/Zend -I/usr/include/libxml2 -I/usr/include/freetype2/freetype -I/usr/include/imap -I/opt/informix/incl/esql -I/usr/include/mysql -I/usr/local/include -I/usr/include/pspell -I/usr/include/ucd-snmp -I/usr/local/freetds/include/include -I/usr/src/redhat/BUILD/php-4.1.2/main -I/usr/src/redhat/BUILD/php-4.1.2/Zend -I/usr/src/redhat/BUILD/php-4.1.2/TSRM -I/usr/src/redhat/BUILD/php-4.1.2/build-cgi/TSRM -O2 -march=i386 -mcpu=i686 -fPIC -L/usr/kerberos/lib -o php -export-dynamicstub.lo libphp4.la /usr/bin/ld: cannot find -lifsql Add this line to /etc/ld.so.conf /opt/informix/lib and run ldconfig. Then try to compile again. -- 17:33:02 up 5 days, 9:23, 3 users, load average: 0.85, 0.76, 0.63 - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php