Re: [PHP-DB] Web Page Caching

2003-02-17 Thread Ignatius Reilly
You can append to the URL a dummy variable that is sure to change every time: http://.../mypage?nocache=?php echo time() ; ? This will force the refresh. Ignatius - Original Message - From: Philip Zee [EMAIL PROTECTED] To: [EMAIL PROTECTED]

[PHP-DB] DBA

2003-02-17 Thread TheGoodTheBadTheUgly
If anybody has a experience with DBA (CDB) please help me? I've compiled PHP4.0.3 with options ./configure' '--with-apache=../apache_1.3.27' '--with-pgsql' '--enable-dba=shared' '--with-cdb' and tried like : ?php if (!function_exists('dba_open')) { die('Error: DBA not supported'); }

[PHP-DB] Fwd: When to do free()?

2003-02-17 Thread Allens
From: Allens [EMAIL PROTECTED]David, I'm still very new to PHP and MySQL, but here is what I've found. Couldn't find any references to the free() function except for this at the www.mysql.com website. On How memory is used in MySQL, lmost all parsing and calculating is done in a local memory

[PHP-DB] array with two dimensions

2003-02-17 Thread Lars Rasmussen
Hi all, Got a little problem here, I have a mysql query that looks like this SELECT SUM(value) as value, YEAR(dileveret) as year FROM table GROUP BY YEAR(dileveret) It works just fine, but i need to make a array that can could do somthing like this (know it doesent work) $ALL_VALUES[$year]

[PHP-DB] Re: Fwd: When to do free()?

2003-02-17 Thread David Chamberlin
I use pearDB to abstract the databse. It has a free() call which says it frees the resources for that result set. It is a method on DB_Result (which is what you get back when you do a query()). http://pear.php.net/manual/en/core.db.free.php -Dave Allens wrote: From: Allens [EMAIL

RE: [PHP-DB] array with two dimensions

2003-02-17 Thread Kelly Protsko
There are really a few ways that you can solve this problem. I would use and associative array to do this. Making the array associative would work like this: $ALL_VALUES[$year] += $value; To retrieve the information back you would use the following loop: While($element = each($ALL_VALUES)) {

[PHP-DB] Suscribirse

2003-02-17 Thread Dimas Alberto Ayala Escobar
Espero poder suscribirme a su lista. Como lo hago.

[PHP-DB] Erro na passagem de parametros

2003-02-17 Thread Bruno Pereira
1º em portugues Boa tarde, Não consigo passar os valores de uma form para um ficheiro em php, em vex de mostrar só o valor da variavel, mostra o proprio código, penso que seja uma configuração no httpd.conf, mas não sei qual? Obrigado Then in english I can´t pass values from a form in html to a

[PHP-DB] Erro na passagem de parametros

2003-02-17 Thread Bruno Pereira
ERRO meu, my mistake 1º em portugues Boa tarde, Não consigo passar os valores de uma form para um ficheiro em php, em vex de mostrar só o valor da variavel, mostra o proprio código, penso que seja uma configuração no httpd.conf, mas não sei qual? Obrigado Then in english I can´t pass values from

[PHP-DB] mysql +php

2003-02-17 Thread G
Hi I was wonder if any knows how 2 display sound clips held in a mysql database using a php page ? I have stored the url’s of the clips in mysql database and I belive I need some like to (below) to display them but its not quite working. while ($row= mysql_fetch_row($result)) //retrieve a row

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
while ($row= mysql_fetch_array($result)) //retrieve a row and store in echo A HREF= .$row['UrlColumnName'].; That's how I'd do it. Ryan -Original Message- From: G [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 8:16 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql +php

RE: [PHP-DB] mysql +php

2003-02-17 Thread Ryan Jameson (USA)
BTW... you'll need something in the anchor: while ($row= mysql_fetch_array($result)) //retrieve a row and store in echo A HREF= .$row['UrlColumnName'].Something/a; -Original Message- From: Ryan Jameson (USA) Sent: Monday, February 17, 2003 12:16 PM To: [EMAIL PROTECTED] Subject:

[PHP-DB] ping

2003-02-17 Thread bo
Hi, This is not exactly fall in the category of php and mysql, but hopefully that you can shed a light for me. My question is how can we write a php ping script to ping some website and output the ip address of the website automatically on webpage? It's the same idea that ping www.google.com in

RE: [PHP-DB] ping

2003-02-17 Thread Ryan Jameson (USA)
see: http://www.php.net/manual/en/ref.exec.php -Original Message- From: bo [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 12:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ping Hi, This is not exactly fall in the category of php and mysql, but hopefully that you can shed a

RE: [PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-17 Thread Gary . Every
//Place your request into a variable: $result = odbc_do($connection,select * from events where id=$id); $var = odbc_fetch_row($result); // Now you have an array to work on foreach($var as $line){ //Do your formatting thusly: echo ' trtd' . $line[0] . '?td

[PHP-DB] Mac OS X.2.4 Upgrade Breaks PHP... need help !!!

2003-02-17 Thread Allens
Quick alert to all, upgraded to OS X.2.4 last Thursday evening. PHP no longer works when testing locally. Here is what is happening: 1. Installed the upgrade. Am using my Mac as a test server. 2. Before upgrade, was runnning Mac OS X.2.3, MySQL 3.23.47, PHP 4.3 3. Used http://localhost/... to

Re: [PHP-DB] mysql +php

2003-02-17 Thread G
Thanks got it working -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mac OS X.2.4 Upgrade Breaks PHP... need help !!!

2003-02-17 Thread Weston Houghton
The OS 10.2.4 upgrade merely adds a new httpd.conf file at /etc/httpd/httpd.conf, while archiving your old conf file in the same location. All you need to do is merge the 2 conf files, as there are additions in the new one installed. Once you do that and restart apache, you'll be fine.

Re: [PHP-DB] Mac OS X.2.4 Upgrade Breaks PHP... need help !!!

2003-02-17 Thread Allens
Weston, I feel absolutely ignorant, but again I'm still pretty new to Unix. I looked at httpd.conf and httpd.conf.applesaved. Upon upgrading to Mac OS X.2.4, the new httpd.conf file commented out the LoadModule php4_module and the AddModule mod_php4.c commands. Once I uncommented out

RE: [PHP-DB] Erro na passagem de parametros

2003-02-17 Thread Ruprecht Helms
Hi Bruno Pereira, Then in english I can´t pass values from a form in html to a php file. Be so kind and post the code of your html-page and your php-script. So we can try to test it and can say if there are some errors in the code or the problem must be in misconfiguration of the

Re: WG: [PHP-DB] Confirmation e-mail

2003-02-17 Thread Leo G. Divingracia III
you dont. your confirmation email will tell them once they are logged in with a random password your script made, then they can go into the profiles section and change the password. just have a boolean column that is set once they are confirmed. you can check that against another column that

[PHP-DB] consistently format large amounts of content

2003-02-17 Thread Brendon
I'm looking for an easy and efficient way to format lots of similar content in a database for easy retrieval and possible ways to alter formatting of all the content in the future using a template. Basically, the content is knowledgebase type information like articles on a topic, etc. The

Re: WG: [PHP-DB] Confirmation e-mail

2003-02-17 Thread Brendon
On Mon, 17 Feb 2003 13:57:35 -0800, Leo G. Divingracia III [EMAIL PROTECTED] wrote: you dont. your confirmation email will tell them once they are logged in with a random password your script made, then they can go into the profiles section and change the password. just have a boolean column

[PHP-DB] Recordsets and associative arrays

2003-02-17 Thread Don Briggs
Hello. I am having a problem with syntax. Here is what I am doing. I have the follwing table |Name|Address |City| = |Name 1 | Address1 | City1 | |Name 2 | Address2 | City2 | |Name 3 | Address3 | City3 | |Name 4 | Address4 | City4 | =

[PHP-DB] PHP and Oracle

2003-02-17 Thread Y Al Hinai
helloo Everyone... A new guest to the list needs your hlep!!. I am about to start working on a project in which im going to use Oralce with PHP4. I am new to PHP. I am looking for a good book about working with PHP4 and Oracle to help me pick up the basics as well as get the depth that i

[PHP-DB] Re: Recordsets and associative arrays

2003-02-17 Thread Adam Royle
Hi Don, Use this process: ?php // create an empty array to fill with data $data = array(); $row = 0; while ($r = mysql_fetch_assoc($result)){ foreach ($r as $key = $value){ $data[$row][$key] = $value; } $row++; } ? The array structure would be something like this:

[PHP-DB] ftp search script

2003-02-17 Thread Matt
Does anyone know of a script out there that allows a user to seach through an FTP site for files. Like a search engine for a site, but searching throught FTP instead. Let me know if you do. Thanks. Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] More help with mysql

2003-02-17 Thread Evan Morris
Hi all I have successfully managed to connect to the mysql database, using the following code: mysql_connect('localhost','php','***') || die (Unable to connect to MySQL server.); $db = mysql_select_db(DB_NAME) || die (Unable to select requested database.); I then issue the following