Re: [PHP-DB] Multiple Image Display Problem

2001-12-20 Thread Dobromir Velev
Hi, your code seems fine except for the $result_array["speaker_id"] variable used when calling the image files. Shouldn't this be $result_array3["speaker_id"] and $result_array4["speaker_id"] respectively? Did you try to call the second image separately to see what is coming out of the database

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Beau Lebens
it's better to do something like 0,10,20,30,40,50* * * * /usr/bin/php -q /home/you/yourscript.php > /dev/null since crontab actually stores the result of it's operations in a file (/home/you/Mailbox?) so you will bloat your server if you don't clear the output. a

[PHP-DB] New Object Oriented Programming (OOP) mailing list for PHP programmers

2001-12-20 Thread Manuel Lemos
Hello, Despite I already created this list a long time ago, only now I am announcing it as a general purpose forum for discussing matters related with Object Oriented Programming done in PHP. Everybody is invited and to join all you need to do is to send a message to [EMAIL PROTECTED] or go to t

RE: [PHP-DB] Mysql result resource error

2001-12-20 Thread Shannon Doyle
Hi Jim, Ahh yes of courseI have corrected this. I am still getting the error on the first query...not sure why. And now I am getting a whole bunch of empty lines being output to the screen. Like there is supposed to be data in those lines, but nothing happening. Plus I am getting repeats of

RE: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Marco Eyzaguirre
task manager -Mensaje original- De: George Loch [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 05:56 PM Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically What if you are on win2K? - Origin

[PHP-DB] Re: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread George Loch
What if you are on win2K? - Original Message - From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 12:22 PM Subject: [mysql-support] RE: [PHP-DB] Run php page automatically > I usually just cre

Re: [PHP-DB] mysql table layout help needed

2001-12-20 Thread Bogdan Stancescu
A sample of what you were trying would have been helpful... If I understood your problem right, the solution is a piece of code like this: \n\n"); while ($myrow=mysql_fetch_row($result)) { $colcount++; if ($colcount==$desiredcolcount) { $colcount=0; } if (!$colcount

[PHP-DB] RE: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
In my opinion, PHP works fine with small scripts like this. True, it could be more efficient with Perl, but when you don't know Perl, or don't have DB perl modules installed, PHP scriptlets are a nice way to take care of small tasks. And PHP can just as easily run a system command and append text

[PHP-DB] RE: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread NiteHaqr
I would probably recommend AGAINST running this php script from cron. I have a similar script but I use a PERL version for auto-updates. PHP should only (IMHO) be used where someone will see some output on a webpage. Other advantage of using PERL is that you could easily create a log file by re

[PHP-DB] mysql table layout help needed

2001-12-20 Thread Chris Payne
Hi there everyone, This is probably a really simple problem but for the life of me I can't figure out what i'm doing wrong. My problem is I am getting 20+ results from a DB to display without any problems with the images etc . but they display one ontop of another (Of course with spacing

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Marco Eyzaguirre
do this (crontab file) 35 23 * * * root lynx http://www.host.com/dir/file.php -accept_all_cookies it's work! marco -Mensaje original- De: Harpreet [mailto:[EMAIL PROTECTED]] Enviado el: Jueves, 20 de Diciembre de 2001 02:21 p.m. Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [PHP-DB

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL

[PHP-DB] Run php page automatically

2001-12-20 Thread Harpreet
I would like to create a php page that would automatically run every 10 minutes or so to delete records from a table. This table has an expiration field and records r tested by comparing current date with the expiration date and record is deleted if expired. Is this possible. Help is greatly app

[PHP-DB] Re: Problem with PHP4 and dba_open

2001-12-20 Thread Juffe Ã…berg
> If you are using PostgreSQL module, do not use PostgreSQL for now. > I'll work on conflict issue later, but I don't think it will be > fixed any time soon No, I don't use PostgreSQL module.. so what's wrong? Sometimes, when I reboot machine, it works for a while..? -- PHP Database Maili

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rick Emery
Try in PHP. This should take "12/25/2001" in $input_date and convert it to "20011225" in $db_date. Then write $db_date to mySQL database. Perform similar conversion when extracting from database. Or instruct your users to use MMDD. $thedate = explode("/",$input_date); //$thedate[0]=DD, $

Re: [PHP-DB] MySQL date formats

2001-12-20 Thread Jim Lucas
in your select statement that you pull the date out with. wrap that column with SELECT UNIX_TIMESTAMP() FROM table; this will return the unix timestamp now with this format use the date() function and format the date how ever you would like. Jim - Original Message - From: "Rosser, Chr

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rosser, Chris
Sorry, correction: > -Original Message- > From: Rosser, Chris > Sent: Thursday, December 20, 2001 5:37 PM > To: [EMAIL PROTECTED] > Cc: 'nautilis' > Subject: RE: [PHP-DB] MySQL date formats > > nautilis, > > Leave the date in the database in MySQL format (/MM/D

RE: [PHP-DB] MySQL date formats

2001-12-20 Thread Rosser, Chris
nautilis, Leave the date in the database in MySQL format (/MM/DD) and when you need to display the date on your page, just do this: That just splits up the three numbers, and rearranges them. Easy :) Chris }:) > -Original Message- > From: nautilis [SMTP:[EMAIL PROTECTED]] > Sent:

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jim Lucas
Try this > Jim - Original Message - From: "SpyProductions Support Team" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 8:40 AM Subject: [PHP-DB] Checkboxes, PHP, and MySQL > > I've looked around in a few of the PHP lists for an answer to this, but > can't

Re: [PHP-DB] Mysql result resource error

2001-12-20 Thread Jim Lucas
which one was giving you the problem? the first or second mysql try. if it was the second, try wrapping the $cattyname with single quotes like this Minor_Category = '$cattyname'. if the $cattyname var has anything but numbers, the statement won't work. Jim - Original Message - From: "S

[PHP-DB] MySQL date formats

2001-12-20 Thread nautilis
Hi everyone! I have a little problem with my MySQL database in the way it stores dates. The only format i can have is /MM/DD, and when i request this date from my php page, this date is insertes in this format. As my website is going to be for spanish users, the correct format would be DD/MM/

[PHP-DB] Multiple Image Display Problem

2001-12-20 Thread Christopher Martin
I am having problems displaying two different images on the same page. (stored as binary files in two different db tables) Instead of getting two different images, I am getting the first image twice, although the scripts are going to two different database tables to get the two images. Is there

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Pierre-Alain Joye
Only one link should solve your problem :) http://www.w3.org/TR/html401/interact/forms.html#h-17.4 HTH pa -- Pierre-Alain Joye Freelance Developpements et Services web/intranet [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
Or a better, more-visual way might be: "; ?> - Jonathan -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 8:45 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Checkboxes, PHP, and MySQL the value doesn't determine wh

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jason Wong
On Friday 21 December 2001 00:40, SpyProductions Support Team wrote: > I've looked around in a few of the PHP lists for an answer to this, but > can't come up with one. > > Here's what I am doing: > > I have a form with a few checkboxes. > > When the information as to whether the checkboxes are ch

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread matt stewart
the value doesn't determine whether it's checked or not - it determines the value passed WHEN it's checked. try the lines below: echo""; }else{ echo">"; } or something along these lines. -Original Message- From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]] Sent: 20 Decem

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
It's not the checkbox's VALUE attribute that determines whether it is checked or not. If you add the empty attribute CHECKED, then the checkbox will be checked. Example: VarCheck1 will be checked, and VarCheck2 will not be checked. A checkbox will only have a value on submission IF IT IS CHEC

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Paul DuBois
On Thu, Dec 20, 2001 at 11:40:14AM -0500, SpyProductions Support Team wrote: > I've looked around in a few of the PHP lists for an answer to this, but > can't come up with one. On this question, you'd be better off just reading an HTML reference. It doesn't matter what the value of a checkbox is.

[PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread SpyProductions Support Team
I've looked around in a few of the PHP lists for an answer to this, but can't come up with one. Here's what I am doing: I have a form with a few checkboxes. When the information as to whether the checkboxes are checked or not is 'saved' into the MySQL table, they are represented by a value of

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread matt stewart
good point well made. this system has pretty much everything we need - thanks! -Original Message- From: Ryan Marrs [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 16:17 To: 'Zach Curtis'; matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Decrypting PASSWORD() from MySQL Or what

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread Ryan Marrs
Or what may be even better at that point (to keep someone from pestering another user and changing their password. Email them a randomly generated string based on their username, store that in a database, then send them to a page to enter the string (or pass it through the url.) IE. I'm Joe, I

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread Yasuo Ohgaki
[EMAIL PROTECTED] wrote: > Thanks to reply my message. > I need dbase.so I don`t have it. I download php`s .tgz to compile > > how i can to compile dbase module? > > i do next > > cd php-4.0.4 > cd ext > cd dbase > phpize > ./configure > make > make install > > and i have dbase.so, but in the

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread Zach Curtis
This is how I'm going to work things. Store the password using PASSWORD() in the table. Allow user to request their forgotten username and/or password. If the password is requested, I will reset the password to a random value and store this in the table using PASSWORD(). The username and/or passw

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread pcastillo
Well, only i need open .dbf files from linux, .dbf files are Visual fox pro files [EMAIL PROTECTED] wrote: > Hi, > > > I need dbase.so I don`t have it. I download php`s .tgz to compile > > Is dbase actional supported and produced for it? > I know this as an old database. > > Regards, > Ruprecht

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread rhelms
Hi, > I need dbase.so I don`t have it. I download php`s .tgz to compile Is dbase actional supported and produced for it? I know this as an old database. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

Re: [PHP-DB] Re: PHP Extensions

2001-12-20 Thread pcastillo
Thanks to reply my message. I need dbase.so I don`t have it. I download php`s .tgz to compile how i can to compile dbase module? i do next cd php-4.0.4 cd ext cd dbase phpize ./configure make make install and i have dbase.so, but in the momento to run my program i have next error "Warning: In

[PHP-DB] Function OCILogon().

2001-12-20 Thread Somsak RAKTHAI
Dear all, I used PHP 4.1.0 and Oracle 9i running on RedHat-7.2. I have question about Oracle function OCILogon(). I have problem about my source below. When run this source on browser, it has messages below. Warning: _oci_open_server: Error while trying to retrieve text for er

RE: [PHP-DB] Decrypting PASSWORD() from MySQL

2001-12-20 Thread matt stewart
I would go for the "generate new random password" approach - email the new random password to the registered email address, then they can log in using it and reset it to whatever they want. probably easier than using lots of code encrypting and decrypting things? Let me know what you decide on, an

[PHP-DB] Nedd urgent help with PHP 4.1.0, IIS5 Windows 2000, Oracle 8.1.6, OCIPlogon

2001-12-20 Thread Jozsef Szilagyi
Hello, I have a strange problem, i nedd to use php under IIS for accessing Oracle database I'm using OCIPlogon to connect to Oracle because i need the fastest possible response. When i use a small script with OCIPLogon OCIParse OCIexecute OCIFetchStatement OCIFreeStatement (OCILogoff) - i underst