[PHP-DB] Sweeping Stale Users from DB

What's the best or recommended way of sweeping users from MySQL on the hour or half hour or other? To keep things portable i was thinking about having each login sweep the db, so every is sweeping for everyone else? But that's kinda dumb. Then i came up with a cron job, but that will be admin

Re: [PHP-DB] Virus alert

This was just forwarded to me by another admin friend regarding the virus. http://www.internetnews.com/wd-news/article/0,,10_586321,00.html A new worm, dubbed "Onthefly" by Helsinki-based security provider F-Secure Corp., began making its rounds on the Net Monday and appeared to be vying

[PHP-DB] fetch array problems.

Hello all. Can someone tell me what I'm doing wrong here? $sql = "SELECT * FROM user_prefs WHERE u_id='$UserID'"; $result = mysql_db_query($sql); $color = mysql_fetch_array($result); echo ' table bgcolor="'.$color[color_1].'" class="nav" .. '; I can't get $color[color_1] to return a

[PHP-DB] $vars to JS in a linked js page.

I've got 2000 pages that are dependent on one include and I don't wanna alter it too much and I'd like to use some JS in a linked file. I don't wanna include it in and have it displayed. Is there a way to do: $some_number = $mysql_num_rows; link lanuguage="JavaScript" type="text/javascript"

Re: [PHP-DB] OT - Domain Registrars

I'd have to definately agree. Avoid NS at all costs. If you want to be able to change your records in about ten minutes go with register.com or I use urlbuyers.com (and register.com but am in the process of moving everything of mine over to consolidate. A client registered with NS spent a week

Re: [PHP-DB] Back up database.....

I'm on Linux and Unix and I just run a cron job each night to tar and gzip the datadirs. Then I use rsync tunneled thru ssh to sync the remote and local files. I couldn't tell you how to do it one Windoze though. Hope this helps. E K L wrote: Hi all, I'm having this problem in backuping

[PHP-DB] Postgres auto increment.

I've been using mysql too much lately. Can anyone tell me how to set up an auto increment in postgres? I need to select a row based on a user's menu selection. Requiring them to type in a text entry and get it right would obviously be pretty inefficient. Thanks, John -- PHP Database Mailing

Re: [PHP-DB] PHP5 is coming out!!!

You know. I get this strange feeling that, in order to keep the correct balance, people should reply to your question under a different subject line. Have you missed any replies to this? P.S. I don't know when php 5 is coming out. aHaHaHa hehehe hohoho merry christmas thanks

[PHP-DB] Storing duplicate checkbox values

Ok This one has me stumped. I'm working on a survey for an author. There is already a total of 35 questions and their corresponding columns in the main table. She has three other questions that have identical checkboxes, 30 each. I want to put them in the second table and just make reference to

Re: [PHP-DB] Storing duplicate checkbox values

Yeah. I'm gonna have to go with this one. Thanks. But one other question: what should the variable be echoing. .input type=checkbox name=cb_name['value']this here option/input if ( $HTTP_POST_VARS ) { echo $cb_name['value']; } It's not coming up with anything. (Yeah, the norm

[PHP-DB] Find - n - replace

Hello all. I'm trying to set up a quick find and replace script. It's finding, and it's pasting what I want, but on the following line, I can't get it to replace. Can anyone help? #!/usr/local/bin/php -q ?php $fp = fopen( ./somefile.html,r+); while ( !feof( $fp ) ) { $line = fgets( $fp,

[PHP-DB] Date Format.

Hello all, I'm on the last leg of a project I'm doing, and maybe I'm just too fried but I've tried several things. Can anyone help: I've created an Event Listing form. The script pulls the table names from the DB and preg's them to create the field names for the form. Any field name that

RE: [PHP-DB] PHP Mysql apache economy hosting

Well that's mighty tacky of you. On Fri, 13 Jul 2001, [EMAIL PROTECTED] wrote: I recommend MissoulaWeb for $10/month. http://www.missoulaweb.com/testimonials.phtml http://www.missoulaweb.com/allfeatures.phtml http://www.missoulaweb.com/compare.phtml (a chart) As for verifying

[PHP-DB] mcrypt, postgres, only returning half the data

. But coming out of the DB, the same data is trashed. Is there any special way to send (or abstract) encrypted data into (from) the DB? I've been through the archives and it doesn't look like anyone has posted a problem like this. Am I the only one :} Thanks, John -- John Starkey ColoradoParks.net

[PHP-DB] Postgres and php shell scripting

, John -- John Starkey ColoradoParks.net Advance Creations -- 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]

Re: [PHP-DB] Postgres and php shell scripting

: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- John Starkey ColoradoParks.net Advance Creations -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact