[PHP-DB] MySQL looks cached.

2001-01-17 Thread John Starkey
I admit my newbie status but this is really odd even for me. :} I'm returning an int from MySQL. No matter what that number is it's returning as 3 until I refresh, when it becomes two. And on each refresh after that it toggles between 2-3. I've checked my functions by redeclaring the var right

RE: [PHP-DB] MySQL looks cached.

2001-01-17 Thread John Starkey
s are zero indexed) as an > associative array. > > Steve > > > -Original Message- > > From: John Starkey [mailto:[EMAIL PROTECTED]] > > Sent: 17 January 2001 09:19 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] MySQL looks cached. > > >

[PHP-DB] Child tables in MySQL

2001-01-18 Thread John Starkey
Can anyone tell me how to create child tables in MySQL? I'm creating User Prefs and need to store bookmarks, and unlimited number. So adding columns is out of the question. Any other suggestions? Thank in advance, John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mai

RE: [PHP-DB] Child tables in MySQL

2001-01-18 Thread John Starkey
r ID. > > Sean > > -Original Message- > From: John Starkey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 18, 2001 11:54 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Child tables in MySQL > > > Can anyone tell me how to create child tables in MySQL?

[PHP-DB] daisy chaining includes

2001-01-23 Thread John Starkey
I'm trying to clean up about 2000 lines of whacked out newbie code i've created. Is there a way to daisy chain includes? I have about five includes in each header and I was thinking of making one include file and linking to that. And furthermore :} is there a way to include within a function if i

[PHP-DB] Sweeping Stale Users from DB

2001-01-23 Thread John Starkey
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 dep

Re: [PHP-DB] daisy chaining includes

2001-01-26 Thread John Starkey
Thanks for all the replies. I finally made things readable. A little easier to follow now. instead of scrolling for days :} John On Tue, 23 Jan 2001 [EMAIL PROTECTED] wrote: > Addressed to: John Starkey <[EMAIL PROTECTED]> > [EMAIL PROTECTED] > > ** Reply

[PHP-DB] Damn Cookie

2001-01-26 Thread John Starkey
I'm not sure if this is my problem but it's wigging me out. I've got a login page posting only the user_name and password vars. No matter what it's using the same name over again. http://.../page.html?user_name=name&password=password When i open page.html and do echo $user_name it still doe

[PHP-DB] DB_HOME

2001-02-01 Thread John Starkey
I just did a distro install of RH7 and like a moron I didn't back up some things I guess should have been :} I was just made aware that on this machine MySQL has lost it db path. Anyone know how to: 1) Find the db path I was using. It's not where I had originally intended to to be, as far as I c

Re: [PHP-DB] DB_HOME

2001-02-01 Thread John Starkey
Sorry. And thanks. I found it. did a locate for a db I knew was in there (after checking the php connect code) and used --datadir=path John On Thu, 1 Feb 2001, John Starkey wrote: > I just did a distro install of RH7 and like a moron I didn't back up some > things I guess shoul

Re: [PHP-DB] Virus alert

2001-02-13 Thread John Starkey
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.

2001-03-27 Thread John Starkey
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 ' .. '; I can't get $color[color_1] to return a value. It's in the db and color_1 is a valid tabl

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

2001-03-29 Thread John Starkey
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; And use the $some_number variable in that external.j

Re: [PHP-DB] OT - Domain Registrars

2001-04-04 Thread John Starkey
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 tr

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

2001-04-09 Thread John Starkey
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 backupi

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

2001-04-09 Thread John Starkey
estion...But, can u explain in more detail on how > those command works? thanks > > >From: John Starkey <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: E K L <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: [PHP-DB] Back up dat

[PHP-DB] Postgres auto increment.

2001-04-13 Thread John Starkey
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!!!

2001-05-01 Thread John Starkey
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

2001-05-16 Thread John Starkey
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 t

Re: [PHP-DB] Storing duplicate checkbox values

2001-05-16 Thread John Starkey
Thanks Ron and Miles, > First off, it sounds to me like you are doing this a non-expandable way. > Unless you never ever plan to set up a survey again I would not hard code > columns for each question. This is one of "those" gigs. Needed to be done a week ago, by the person that started it, a mo

Re: [PHP-DB] Storing duplicate checkbox values

2001-05-16 Thread John Starkey
> 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 > > if ( $HTTP_POST_VARS ) { > echo $cb_name['value']; > } > > It's not coming up with anything. (Yeah, the no

[PHP-DB] Find - n - replace

2001-05-22 Thread John Starkey
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 Can anyone tell me how I can back the fput up one line so it overwrites the result of the

[PHP-DB] Date Format.

2001-07-03 Thread John Starkey
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 contain

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

2001-07-13 Thread John Starkey
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 verif

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

2001-07-13 Thread John Starkey
Actually I hadn't noticed that several people were pitching their companies on this list. I noticed this one because of the alias. My apologies. John On Fri, 13 Jul 2001, John Starkey wrote: > Well that's mighty tacky of you. > > On Fri, 13 Jul 2001, [EMAIL PROTECTED]

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

2001-08-14 Thread John Starkey
as a matter of fact. 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

[PHP-DB] Postgres and php shell scripting

2001-08-27 Thread John Starkey
s to work. TIA, 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

2001-08-27 Thread John Starkey
gt; 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] > -- John Starkey ColoradoParks.net Advance Creations -- PHP Data