[PHP-DB] One quick favor!!!!!!

When I get the data from the database and put it into the a href=/a code and use it in the post form, form ... . /fom. And so on. When I click the hyperlink to go to the next page, I saw the ugly code in the URL address section of the web browser's window. It said,

[PHP-DB] Search in a MySQL TEXT field

Hello, What is the better method for doing searchs in a TEXT field ? I have news in a web, but I think that use field LIKE '%foo%' can overload my server if the traffic grows up. Have you any reference about this? (urls, scripts, methods, documents...) Thanks -- Antonio Mármol Albert (

[PHP-DB] Any word in how to connect to PPROGRESS db using PHP.

Hi all, Does any body have any information about how to access a PROGRESS database using PHP? I know this has been asked before and I just want to be upto date. Thanks, -- === Hector M Banda Fax: (425) 790-6379 Irvine Ca, 92618

[PHP-DB] how to email article to a friend

I'm a newbie and have only worked with php to send email from webform input. I now want to add a new feature to my website: Email article to a friend and I don't know where to start. I want to add this feature to webpages that are dynamically created from a mysql database. How do I pull this

[PHP-DB] db abstraction: sql design

Hi! I'm new to this mailing list. So if this post is off-topic, please tell me and I will try to post it in other lists. I'm currently developing an intranet solutions targeted to run with several different SQL database system such as MySQL, PostgreSQL, Oracle, Microsoft SQL Server and so on.

Re: [PHP-DB] db abstraction: sql design

Hello Michael, On 19-Jun-01 23:57:31, you wrote: I'm new to this mailing list. So if this post is off-topic, please tell me and I will try to post it in other lists. I'm currently developing an intranet solutions targeted to run with several different SQL database system such as MySQL,

[PHP-DB] mssql_connect() function not found when I load the page...

Hi, I am running PHP with apache as server at Windows 98 platform. When I open a page I write that will connect to Microsoft SQL Server 7.0 in my intranet, I get the error : mssql_connect( ) function not found. Could someone tell me how to solve this problem? Thanks. lwneo. -- PHP

[PHP-DB] charts

Hi All! Is it possible to create charts/ histograms using PHP ? Can somebody lead me to a resource where I can find some information on this Thanks Pankaj Ahuja -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[PHP-DB] mssql_fetch_array problem

Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database.

Re: [PHP-DB] mssql_fetch_array problem

Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database.

Re: [PHP-DB] php accessing oracle

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll in your php.ini file, and copy php_oracle.dll to winnt\system32. If you have installed Oracle8 client, you can also use php_oci8.dll (even with a 7.3 database), with the OCILogon functions, etc... I don't know what to do

Re: [PHP-DB] php accessing oracle

If you use PHP on Windows NT, you have to uncomment extension=php_oracle.dll in your php.ini file, and copy php_oracle.dll to winnt\system32. If you have installed Oracle8 client, you can also use php_oci8.dll (even with a 7.3 database), with the OCILogon functions, etc... I don't know what to do

[PHP-DB] mssql_fetch_array - still not working fine

Thanks for all your answers, but, they still seem not to work. In my query, the value of countryname is retrieved as expected but the value of countryid is not. There seems to be no value retrieved for countryid. I am using PHP4 on IIS4 on an NT machine with SQL Server 7 as the database.

Re: [PHP-DB] how to email article to a friend

You can query your database to extract those info, compose your email and use mail( ) function to send it. At 02:22 PM 6/19/01 -0400, [EMAIL PROTECTED] wrote: I'm a newbie and have only worked with php to send email from webform input. I now want to add a new feature to my website: Email

[PHP-DB] newbie: Trying to select a database in php

Im using win2k and php to retrieve and dipslay database records, however whenever the page is loaded in a browser I get the following error (the line in question is in bold) Fatal error: Call to undefined function: msql_select_db() in D:\ASP\test\php\default.php on line 18 The code I am using

RE: [PHP-DB] db abstraction: sql design

Hi Michael, …since U R using an abstraction-layer, most of Ur problems should be solved. U should have no problems if U reduce Ur SQL-statements to SQL92-standard. Greetinx, Mike Michael Rudel - Web-Development, Systemadministration -

[PHP-DB] Your Internet Education!

Take our course in computers and the Internet; and then we'll show you how to build a business with your new skills. Just hit: mailto:[EMAIL PROTECTED]?Subject=Education To be removed from this list, hit: mailto:[EMAIL PROTECTED]?Subject=Remove -- PHP Database Mailing List

RE: [PHP-DB] mssql_connect() function not found when I load the page...

snip mssql_connect( ) function not found. Could someone tell me how to solve this problem? /snip You need to recompile PHP to include MSSQL support Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

AW: [PHP-DB] mssql_connect() function not found when I load the page...

You need to uncomment the mssql.dll (or something called like this) in your php.ini (In the section Windows DLL's). Greetings, Stefan -Ursprüngliche Nachricht- Von: lwneo [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 20. Juni 2001 06:21 An: [EMAIL PROTECTED] Betreff: [PHP-DB]

Re: [PHP-DB] mssql_fetch_array problem

Ok lets start from the beginning, apologies if this these have been mentioned previousely I haven't seent the rest of the thread: * Make sure 'countryid' is spelled the same in your script as it is in your DB table (I've done this and spent hours banging my head against a brick wall) *

[PHP-DB] Query through two tables

Hi! I've got two tables: CREATE TABLE users ( user_id bigint(20) unsigned DEFAULT '0' NOT NULL, contact_id bigint(20) unsigned DEFAULT '0', user_login varchar(100) NOT NULL, PRIMARY KEY (user_id), UNIQUE UC_user_id (user_id)

AW: [PHP-DB] newbie: Trying to select a database in php

Try it with mysql_select_db($database,$connect) instead of msql_select_db($database,$connect) :-) msql is a different Database System (in general, it is a lot older than mysql I think) Stefan -Ursprüngliche Nachricht- Von: Paul Lockyer [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 20.

Re: [PHP-DB] how to email article to a friend

At 20.06.2001 08:52, you wrote: You can query your database to extract those info, compose your email and use mail( ) function to send it. that is _not_ a wise way to do it, you should include some form of restrictions on how many emails can be sent to a single account within X minutes for

Re: [PHP-DB] newbie: Trying to select a database in php

At 20.06.2001 09:06, you wrote: Im using win2k and php to retrieve and dipslay database records, however whenever the page is loaded in a browser I get the following error (the line in question is in bold) Fatal error: Call to undefined function: msql_select_db() in

[PHP-DB] A L'AIDE !!!!

Bonjour, je suis un tout nouveau programmeur PHP. Mais aujourd'hui je bloque sur ce problème : print(option value=\Choisissez\Choisissez/option); while ($ligne = mysql_fetch_array($resultat)) { echo option name=\ville\ value=\; echo $ligne[ville]; echo \; echo

Re: [PHP-DB] Any word in how to connect to PPROGRESS db usingPHP.

Hi there, We are currently getting PHP to talk to Progress. How you do it is thru ODBC. You have to get a ODBC driver for Progress which you can get straight from Progress (Merant driver) for $100 or you can get one from www.openlinksw.com for $500 with multitier capabilities. I will warn

Re: [PHP-DB] mssql_fetch_array problem

Jennifer, Try this code..I am using the same stuff as you with the exception of mysql instead of sql..but it may still work: ? $country_sql = select countryname co_name_val, countryid co_id_val from TBL_COUNTRY; if ($country_query = mssql_query($country_sql)) { while ($myrow =

[PHP-DB] MSSQL limit capability

Hi, Having used to the wonderful features in MySQL on the limit, how could I do the same on MSSQL? The table I'm trying to retrieve is kinda big - like 500,000 records - and would like to read them in chunks. Thanks. Dreamvale -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Date field

Hi, Can someone tell me how do stote date field in MySQL DB ? Thanks, Rosen M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] flush privileges

Hello php-db, what kind of privileges i should have if i want to run 'flush privileges' ? ,,, (@-@) +==---o00(_)00o-==+ It is better to be defeated on principle than to win on lies. --Arthur Calwell -- Best regards, andRie

[PHP-DB] PHP insert into Access autonumber, get inserted value back?

I have an Access database that PHP will be accessing. (I'm assuming I have to do this via ODBC and the Unified ODBC functions in PHP, but correct me if I'm wrong.) The PHP script will be inserting new records into the Access database. The primary key in many of the tables in the Access

[PHP-DB] imap problem

Hi, I am developing an email reader for IMAP/POP3. But I am getting the following error when trying to excute the file. I have removed the comment from the IMAP extensions in the php.ini. Fatal error: Call to undefined function: imap_open() in conn.inc on line 6 Contents of conn.inc is as

Re: [PHP-DB] php accessing oracle

Hi! did you compile php with oci or ora functions? this is a really good tutorial... http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html here are the commands I use .. you need to adjust for versions... php config ./configure --with-apache=../apache_1.3.19

[PHP-DB] Search in many tables an many fields,

Hello I'm from Argentina, and I'm new on php news, I have a question: How can i search some word or number in all database, like find word Example on all tables, an all fields on each tables, if i cant do automatic I must to do SELECT Fields FROM TABLE1, Table2, TableEtc, Where Field1 = Example

Re: [PHP-DB] MSSQL limit capability

Hello Dreamvale, On 20-Jun-01 12:15:14, you wrote: Having used to the wonderful features in MySQL on the limit, how could I do the same on MSSQL? The table I'm trying to retrieve is kinda big - like 500,000 records - and would like to read them in chunks. Use server side cursors. You may

[PHP-DB] Informix Question how to put data from query into variables

Hi All, What I want to do is create another query from some of the data from another one. The question is how do I take the data I get back from my first query and put that into variables so I can build my second query. The example I have in mind is: I a do a select

[PHP-DB] Too many Connections error

Hi, I'm using PHP to connect to a MySQL server, and occasionally I get the following error: Warning: Too many connections in /usr/sites/www/gamewardens_forum/forumadmin.php on line 243 Unable to connect to Database Server I'm using a persistant connection with the function mysql_pconnect,

RE: [PHP-DB] how to email article to a friend

I would suggest that you send the link to the page that you want them to visit rather then the entire article. The reason being is that you put a lot of work in to getting people to your site to just give them the content, and if you have banners as a revenue source and you send the entire

Re: [PHP-DB] MSSQL limit capability

MSSQL does not have complete the same functions. You can use SELECT TOP 10. You could also define mssql.batchsize in php.ini. This way php only reads the specified number of rows. You can the use mssql_fetch_batch() to read batches of data on the same query. - Frank Hi, Having used to

Re: [PHP-DB] PHP insert into Access autonumber, get inserted value back?

Access should also accept standard SQL commands. If not, you can juggle the data by shooting it from Access to a temp table in MySQL and reading the autonumbered values. If Access will accept your SQL commands (I don't use Access but maybe someone else here can offer better information), then