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
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.
> >
>
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
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
> _
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
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
> 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
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
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
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
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]
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
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]
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
28 matches
Mail list logo