[PHP-DB] Scheduling php task

Does anyone know if is it possible to run a php script periodically (for example every night)? My system is Apache, LinuxPPC, php4 Thanks == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED]

RE: [PHP-DB] Scheduling php task

You can compile it as an executable (not an apache module), then schedule it with cron. Run ./configure without the -with-apache= switch. It should reconfigure for "cgi mode" (I think that's what it's called). After you 'make' it you'll get an executable called 'php'. Use can use this to proces

[PHP-DB] mysql_fetch_array problem...!

I want to run a query to my db, fetching different fields from three different tables. In order to recognise the individual fields I give them names: select portal.portal as portal, portal.portalid as id... etc etc How can I refer to one specific row in this query..? What I mean is, how can i r

RE: [PHP-DB] mysql_fetch_array problem...!

Trond, What is your table structure? I'm guessing you need a different query. Also, be aware that mysql_fetch_array returns an array with the field name as value, so: $sql="select fields from table where id = $id"; $connection_handle=(mysql_connect($user, $pass, $host); mysql_select_db($databa

Re: [PHP-DB] mysql_fetch_array problem...!

> How can I refer to one specific row in this query..? > What I mean is, how can i refer to result row number 4...? > > If I only selected rows from one table I could do something like this: > > $i = mysql_fetch_array($sql) ; > echo "$i[4]" ; Actually, no. mysql_fetch_array return the _current r

[PHP-DB] Re: [PHP] Problem getting PostgreSQL to compile

On Mon, 5 Mar 2001, K Old wrote: > Yes, I've checked phpinfo() and not it is not compiled in. That is the > problem. I have recompiled PHP with pgsql support and there is some > problem. I'm not sure why it isn't compiling it in. I've tried everything > I knowthe installation goes fine...

[PHP-DB] Problem with odbc_field_type?

Is there a problem with odbc_field_type? I always receive a null back. I dont have a problem with odbc_field_len. Is it perhaps that some db types don't respond correctly. Thanks Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional co

[PHP-DB] Sybase-ct in Linux and MS SQL 2000

I just installed a Sybase_CT module in php 4.0 on a linux machine. I'm trying to move a web site from a buggy and crashy NT box but I'm having trouble with the mssql_result call. This is what I get. Warning: 2 is not a valid Sybase result resource in /var/www/html/crap.php on line 54 Line 54 r

[PHP-DB] Display random image within loop problem

I want to display a random image on a web page every 30 seconds. The problem I am having is that I get multiple images on the same web page all at once. It's not clearing the previous image and then displaying the new image. Must have something to do with the loop its in: There were no reco

Re: [PHP-DB] MySQL - Problem with multiple INSERTs?

Addressed to: Chris <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from Chris <[EMAIL PROTECTED]> Mon, 05 Mar 2001 02:04:28 -0600 The first thing that jumps out is using tinyint for keys. Are you sure there will never be more than 127 entries in the table? I usually use b

Re: [PHP-DB] mysql_fetch_array problem...!

You must use a loop to show each row of your query. "mysql_fetch_array($result)" only get the current row. while($row = mysql_fetch_array($result) ){ // do something } The "mysql_fetch_array" function returns an associative array where you can use the field names to have access to its val

Re: [PHP-DB] MySQL - Problem with multiple INSERTs?

Have you put an echo with mysql_error() after performing each query ? Jayme. -Mensagem Original- De: Chris <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: segunda-feira, 5 de março de 2001 05:04 Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs? > Howdy, > > I'm gettin

Re: [PHP-DB] Insert a file in a mysql database!

check in the manual under the features section, a part called Handling file uploads. you need to use a multipart/form-data html form, which then posts the contents of the file to the server. once it is there, you can parse it into a single variable and save that into the db just like you would

RE: [PHP-DB] Scheduling php task

or alternatively, if you don't have access to recompiling or anything like that, set up a cron job to use lynx to hit a page (which is your php script) when required. you can even set event times in a db and have that script check the db for anything that needs to be run and then perform that

[PHP-DB] Oracle functions and procedures via OCIParse and OCIExecute

Hi! I wonder if you have had the same problems with invoking oracle functions and procedures via OCIParse, OCIExecute functions? When I am trying to invoke a function or execute a procedure I receive an OCIStmtExecute error. The same statements works perfrectly direct in sqlplus. It't waird!