On Monday 08 April 2002 19:15, Michael Andersson wrote:
What happens to a blob field with lets say a image when dumping a mysql
table to a file?
I don't use BLOB fields. You try it and let me know ;-)
3) Install phpMyAdmin on both machines.
How do i replicate 2 mysql db:s with
The only answer I know is in the php config, which you may not have acces
to. php can be configured to run as the owner of the script that calls it.
This means only your scripts can read your files. This is not the default
option, and most ISPs just run the default, so your password is available
guessing here, but have you tried to use include'filename.txt' in your if
statement?
Eat Pasta Type Fasta [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Not 100% DB related but soon
I am processing a text file by looking for strings which later depending
on
Sorry, That's not right. This is what I really meant to say.
SELECT COUNT(column) as somename FROM table;
or
Select count(ID) name from $table;
Mike
- Original Message -
From: Allen, Ronald L CIV [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 6:52 AM
I know how to get the results for the total number of records
select count(*) from $table
but how do I put them into a variable for me to use later???
David Robley [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
In article [EMAIL PROTECTED],
[EMAIL PROTECTED]
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I know how to get the results for the total number of records
select count(*) from $table
but how do I put them into a variable for me to use later???
David Robley [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
What is the Aliases used for???
Aliases. SELECT COUNT(*) AS howmany FROM table
Then use the variable $howmany
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there,
I would like to copy data from one table to another. My code just inserts
one record. Not all 20. Why?
This is my try:
insert into parks_new (country, province, park)
select * from national_parks_us_imported
Thanx for any help
Andy
--
PHP Database Mailing List
Hi there,
I am wondering if it would be possible to set up a php application like
this:
If the mysql server is down notify by e-mail, but only once.
Right now I am getting an e-mail per view if the server is down (might be
lots of e-mails :-)
thanx for any hint,
Andy
--
PHP Database
When the user post a message, proccess the queries on temp page and then
redirect to a page where you display message to user. In this case if he
hits reload button, php don't repeat queries.
I thing it should work.
Bye Moreno
-Messaggio originale-
Da: Nick Stuart [mailto:[EMAIL
I run a gaming website. Sometimes, I have to freeze users for one thing or
another. But, since there are lots of tables involving users that get
displayed to other users, they still get seen. One solution to this seems
to be to have an array of frozen users in the header, which I check when
on 4/11/02 11:14 AM, Leif K-Brooks at [EMAIL PROTECTED] wrote:
I run a gaming website. Sometimes, I have to freeze users for one thing or
another. But, since there are lots of tables involving users that get
displayed to other users, they still get seen. One solution to this seems
to be to
Hi there,
I am wondering what would be the best way to update a db. I would like to
bring down the server, but I am afraid to get
an inconsistant state of data. What if someone is just registering on
another db? Is there a way to flush and lock the whole db not just some
tables?
Thanx,
Andy
Get all table names in a db and lock them :show tables;;
Andrey
- Original Message -
From: andy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 11, 2002 7:37 PM
Subject: [PHP-DB] how to bring down the mysqlserver without getting an inconsistant db?
Hi there,
I am
Have in mind this :
LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases any locks held
by the current thread. All tables that are
locked by the current thread are automatically unlocked when the thread issues another
LOCK TABLES, or when the connection to the
server is
Hi all...kinda new to PHP and MySQL...anyhow, I have created the following
table:
CREATE TABLE images (
id smallint(6) NOT NULL auto_increment,
image_title varchar(75) default NULL,
image_src varchar(150) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
I have also created a form that
brandon,
you can only ever upload 1 file per file input box, but you can have more
than one of these input fields per form. you might have something like
input type=file name=file1
input type=file name=file2
input type=file name=file3
that way when you are processing (assuming PHP4+) you can
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
What is the Aliases used for???
Aliases. SELECT COUNT(*) AS howmany FROM table
Then use the variable $howmany
At this stage I refer you to The Fine (mysql) Manual - or anything on the
SQL language.
--
David Robley
Temporary
I'm using PHP to read data from a file and dump it into an array,
then I'mfeeding that array into mySQL
transfer happens fine except that some the numeric values are halfed
currenly I'm simply tweaking the output by going:
(int) $player_data[16] = $player_data[16] * 2 / 10;
the /10 is needed
19 matches
Mail list logo