James wrote:
I'm pretty new to this...I've set this book example up on my PC and it's
fine.
I've attempted this on two Macs...
Here's the error I get when I try to run the application. What does the
error mean?
UNHANDLED ERROR on line 84 in
Hello all,
Have a question for you, don't know how simple this is. I want the
output that mysql sends to arranged a certain way and I don't know if it
is possible.
Here is the select statement:
SELECT cart_search.id, cart_search.year, cart_makes.thename as makename,
cart_models.thename as
Just reorder your list of selected fields.
SELECT fieldnames in order to be returned from tablename WHERE
requirements
-Micah
On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote:
Hello all,
Have a question for you, don't know how simple this is. I want the
output that mysql sends
As a kind soul pointed out, I missed the string joining you need to do, so I
feel tasked with addressing this further..
Simple answer: I don't see a way to do this with a single query unless you're
using a DB with subqueries.. in which case you might be able to figure
something out, but
how about :
SELECT (count( b.unique_id ) + 1) ranking
FROM table_name a, table_name b
WHERE a.unique_id = '4' AND b.score a.score
Mike wrote:
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
1 | 100
2 | 50
3 | 30
4 | 80
5 | 50
after sort:
UNIQUE ID | SCORE
1 | 100
4 |
If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as soon as
it has found the first row_count lines rather than sorting the whole table.
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
I need to get the top $num results from a completely sorted table (eg sorted
on ID,
ioannes wrote:
If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as
soon as it has found the first row_count lines rather than sorting the
whole table.
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
I need to get the top $num results from a completely sorted table (eg
You could also try www.vitalspeeds.com they dont host any microsoft
stuff like .Net or ASP but they are reliable and cheap. Hope this helps.
Regards,
Marcus Joyce
J. Connolly wrote:
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good
On Tue, 2005-02-08 at 16:07 -0500, J. Connolly wrote:
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also. This is for practice
and development not for a company so I am looking to keep the costs
down. There are so many sites, I
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also. This is for practice
and development not for a company so I am looking to keep the costs
down. There are so many sites, I thought maybe someone here might have a
good solution.
i buy my hosting on ebay. haven't had a problem
bastien
From: J. Connolly [EMAIL PROTECTED]
To: PHP list php-db@lists.php.net
Subject: [PHP-DB] MySQL PHP hosting
Date: Tue, 08 Feb 2005 16:07:47 -0500
Is there a site that someone could recommend that does PHP, Mysql hosting?
If they do .NET
joe,
thanks for the advicei just can't host where i work and trying to
develop only on my laptop only at work is becoing tedious. The sys admin
is not happy about me running iis or apache on my laptop here. But at
least I didn't ask how you how to configure my php and mysql
richard,
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP
Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8
I am receiving the enclosed error when I attempt to go into
phpMyAdmin and do not know how to solve the issue...
Any assistance would be greatful.
Thank you
Gary
You may try to create a VIEW. In this case the tables will be dynamically
linked, that is when some values change in both tales the views
automatically update itself each time you call it.
CPT John W. Holmes [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
From: Roger
Why is this query handled differently in 4.1?
4.0
select lower(concat(last_name,id)) from client where prim_id=1
returns johnson1
4.1
same query returns Johnson1
Why don't the lower work in 4.1 when you concatonate with a number?
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To
blackwater dev wrote:
Why is this query handled differently in 4.1?
4.0
select lower(concat(last_name,id)) from client where prim_id=1
returns johnson1
4.1
same query returns Johnson1
Why don't the lower work in 4.1 when you concatonate with a number?
No idea.
select concat(lower(last_name),id)
yeah, that is what I did to fix it...just curious why the problem was
there in the first place.
On Wed, 02 Feb 2005 14:40:55 -0600, Martin Norland
[EMAIL PROTECTED] wrote:
blackwater dev wrote:
Why is this query handled differently in 4.1?
4.0
select lower(concat(last_name,id)) from
precedence of function order may have changed
bastien
From: blackwater dev [EMAIL PROTECTED]
Reply-To: blackwater dev [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql 4.1-4.0
Date: Wed, 2 Feb 2005 15:46:25 -0500
yeah, that is what I did to fix it...just curious why
try
select concat(lower(last_name),id) from client where prim_id=1
bastien
From: blackwater dev [EMAIL PROTECTED]
Reply-To: blackwater dev [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql 4.1-4.0
Date: Wed, 2 Feb 2005 15:35:08 -0500
Why is this query handled differently in 4.1
Hi list,
I try to store/retrieve pictures into MySQL.
I know that a lot of people will say this is not a good practice, so here
are briefly my reasons:
-I want to protect that pictures (restricted access)
-I don't want to use htaccess as I want my users to be able to modify their
password
so what exactly is the problem?
bastien
From: mel list_php [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql - image storing
Date: Tue, 18 Jan 2005 11:30:12 +
Hi list,
I try to store/retrieve pictures into MySQL.
I know that a lot of people will say this is not a good practice
On Tuesday 18 January 2005 19:30, mel list_php wrote:
[snip]
$donnees=stripslashes($row[donnees_binaires]);
[snip]
-I tried different combinations with addslashes/stripslashes, trim in case
of spaces, mysql_real_escape_string...
I haven't looked at your code in detail but stripslashes()
with several header option as I thought it may be the problem as if I
just echo the data without the header they look like normal data for a
picture...
Thanks for the reply.
From: Bastien Koert [EMAIL PROTECTED]
To: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] mysql - image storing
Date
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
--
Joseph Crawford Jr.
Codebowl Solutions
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
If I may step in...
Assuming a MySQL db,
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
The slashes are added for
On Wednesday 19 January 2005 01:51, [EMAIL PROTECTED] wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes
Martin Norland wrote:
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
The
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 18 January 2005 17:11, Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
although 'slashing' text works pretty much all of the time (possibly the
guys using exotic encodings all day will say different :-) but
On Tuesday 18 January 2005 19:18, Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
I think it depends on the database that
Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
INSERT INTO status (hunger) values ('I''ve just eaten.');
...alot of
Simon Rees wrote:
On Tuesday 18 January 2005 19:18, Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
I think it depends on
Martin Norland wrote:
Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be
escaped with another single quote - although backslash also works:
INSERT INTO status (hunger) values ('I''ve just
Hi,
I need some help. Does anyone know a good tool to synchronize MySQL databases?
Thanks in advance for your help
Regards,
Kris
sqlyog is a great tool
bastien
From: Kris Geens [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL db sync
Date: Sat, 15 Jan 2005 14:06:50 +0100
Hi,
I need some help. Does anyone know a good tool to synchronize MySQL
databases?
Thanks in advance for your help
Regards,
Kris
--
PHP
To the PHP Database Mailing-List:
I joined the mailing list for this one question I just can't figure
out. I used the phpMyAdmin to create table. I placed one row in this table, I
used the ENCRYPT function. How do I De-Crypt the data I just encrypted to use
in my PHP code. I encrypted
Kevin the Linux User wrote:
To the PHP Database Mailing-List:
I joined the mailing list for this one question I just can't figure out.
nice, we help you and then you bugger off? - community spirit are go!
I used the phpMyAdmin to create table. I placed one row in this table, I used
the ENCRYPT
On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
[EMAIL PROTECTED] wrote:
OOzy Pal wrote:
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
automatically? No. But you can always just use
SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
if you
On Friday 07 January 2005 02:29, Andrew Kreps wrote:
This would be a great place for a stored procedure, but I don't know
if I can recommend running MySQL 5 to you. The most platform-safe way
I can think of is to get a count(*) of the number of rows with today's
date, add 1 to it, and stick
-Original Message-
From: Andrew Kreps [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 12:30 PM
Subject: Re: [PHP-DB] MySQL Auto PK
On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
[EMAIL PROTECTED] wrote:
OOzy Pal wrote:
Is it possible to have mysql at an ID
Andrew Kreps wrote:
...
20050105-1
20050105-2
20050106-1
...etc.
This would be a great place for a stored procedure, but I don't know
if I can recommend running MySQL 5 to you. The most platform-safe way
an open source alternative that does offer this enterprise level
functionality (stored
Dears,
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
OOzy
=
Regards,
OOzy
What is the purpose of life?
__
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
OOzy Pal wrote:
Dears,
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
probably, possibly, maybe. take your pick.
as Martin Norland already pointed out to someone else; this is not
[EMAIL PROTECTED] (that beauty of a comment is forever burned
into my neo-cortex! :-)
OOzy Pal wrote:
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
automatically? No. But you can always just use
SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
if you _really_ need something like this. Or just join them together in
PHP.
--
---John Holmes...
Nayyar Ahmed wrote:
Hello All:
Is there any tool available for conversion of M$ Access, Oracle etc Databases
to MySQL database ?
google will probably give you more answers than this list (try also
searching for the term 'datapump' and variations on it)
IBExpert is one tool that will allow you to
As some of you will recall, I enquired on this list about versions of MySQL and
PHP a while back regarding and issue wit using the 'ON DUPLICATE KEY UPDATE'
command in MySQL INSERT queries. Having upgraded our in-house system to PHP5
and MySQL 4 the issue was no longer a problem.
However I
DB Designer4 from fabforce (www.fabforce.net/dbdesigner4/)
bastien
From: Nayyar Ahmed [EMAIL PROTECTED]
Reply-To: Nayyar Ahmed [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL database converter ?
Date: Tue, 4 Jan 2005 10:36:20 +0500
Hello All:
Is there any tool available
From: Mark Benson [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL version issue
Date: Tue, 04 Jan 2005 14:43:48 +
As some of you will recall, I enquired on this list about versions of MySQL
and PHP a while back regarding and issue wit using the 'ON DUPLICATE KEY
UPDATE
It seems to me that the _mysql manual_ gives a most straightforward and useful
explanation:
If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0), and a
row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY,
an UPDATE of the old row is performed.
www.daffodildb.com
-Original Message-
From: Nayyar Ahmed [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:06 AM
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL database converter ?
Hello All:
Is there any tool available for conversion of M$ Access, Oracle etc
Databases
Balwant,
Right now this is an algorithm question, not a PHP or MySQL problem.
Define exactly what you want to see as output, what you have as inputs, and
what process you would have to follow to achieve the output.
But don't suppose - be specific.
Then it's possible to fit it to a language:
Balwant Singh wrote:
hi to all,
may somebody guide me on the following:
I want to retrieve data from MYSQL and then want that PHP do calculation
let hope your not asking how to connect to the DB. and perform a query...
- substract a particular field from its previous row. i.e. suppose i
hi to all,
may somebody guide me on the following:
I want to retrieve data from MYSQL and then want that PHP do calculation
- substract a particular field from its previous row. i.e. suppose i
have two field named DATE, STOCK and have 10 rows. Now i want that STOCK
on the 10th row should be
Does anyone know of a FREE program that exports MySQL to access? The trial
versions of the ones I have downloaded do not export all the records of the
database.
- Matthew
-Original Message-
From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Does anyone know of a FREE program that exports MySQL to access? The
trial versions of the
ones I have downloaded do not export all the records of the database.
If you can get a .csv export
why not just link the mysql to access?
bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql to access
Date: Fri, 17 Dec 2004 09:33:39 -0600
Does anyone know of a FREE program that exports MySQL to access? The trial
versions
PROTECTED]
Sent: Friday, December 17, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
it would depend on what you need the app to do...if you are looking to use
access to do reporting and/ or act as a front end, then it may be
feasible...
more details, if you care to share
) instead of MySQL?
Thank you all for your time and patience.
- Matthew
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
it would depend on what you need the app to do...if you
see embedded comments
bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
Date: Fri, 17 Dec 2004 10:25:09 -0600
Here is the problem:
I am currently using MySQL and PHP for this application but have realized
recently
This not be what you need, but I think there are some squiggle brackets
missing.
The curly brackets aren't the problem as they're not needed for just
one statement.
Examples at:
http://www.php.net/manual/en/language.control-structures.php#control-structures.if
anna
--
PHP Database Mailing
for inserts , yes, it does
for lots of update, deletes it might be worth to periodically drop and
rebuild the indeces
bastien
From: Yemi Obembe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql Index table
Date: Thu, 16 Dec 2004 04:59:40 -0800 (PST)
just want to know if mysql
just want to know if mysql automatically update an index table if new datas are
inserted into the original table. for example, if i insert a row of data to a
table I'have already created an index table for, would mysql add the row to the
table?
-
A passion
-
From: PHPDiscuss - PHP Newsgroups and mailing lists
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 15, 2004 9:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MYSQL Maximum Time Exceeded
Hi.
I am running MySQL 4.0 and PHP 4.3.9 (MySQL Client Version 3.9.23) in
Windows XP. I get this error
Walker [EMAIL PROTECTED]
To: 'PHPDiscuss - PHP Newsgroups and mailing lists'
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: [PHP-DB] MYSQL Maximum Time Exceeded
Date: Wed, 15 Dec 2004 19:06:01 -0700
This not be what you need, but I think there are some squiggle brackets
missing.
$conexion
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
No... That is just some strange error generated by the cut and
paste. The IS NOT NU LL that is...
The other issue with 'tablename'... I simply typed 'tablename'
in the e-mail because I didn't
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform an update
I get back an error
saying Table 'tablename' doesn't
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL error...
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform
I have been using a PHP page to update a database table for a
long time now. Unfortunately, I have noticed that frequently when I
perform an update I get back an error saying Table 'tablename' doesn't
exist. This is becoming more and more annoying. The table obviously
exists as the page
So here's the problem: I can connect to a mySQL database on localhost just
fine with a PHP test script I've written, but I cannot connect to a remote
server, even though I can connect to the remote server just fine with
mySQL Control Center. Anybody have any suggestions? Here's a snippet of my
do you have the same user with the same permissions as the mysql cc user?
bastien
From: Bryan Green [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mySQL - can connect with mysqlcc but not PHP code
Date: Fri, 03 Dec 2004 12:52:53 -0800
So here's the problem: I can connect to a mySQL
suggestions or another method?
Thanks a ton!
Nate
[EMAIL PROTECTED]
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 12:11 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql db dump with php
On Wednesday 17 November 2004 13:51, Nate
Nate,
Don't know if this is the case or not, but the destination database has to
already exist on the upload server.
dave
Nate Nielsen [EMAIL PROTECTED]
11/17/2004 10:08 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] mysql db dump with php
I tried this but to no avail
if you have access to phpmyadmin, use that to dump the table and then
re-import the created files in the server
bastien
From: Nate Nielsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql db dump with php
Date: Wed, 17 Nov 2004 10:08:43 -0600
I tried this but to no avail
Hi all, I have this really strange problem. Apache 2.0.50, MySQL 4.1.4a,
and PHP 5.0.2.
I have about 7000 records in a table called mailinglist, I will show you
the sql to build the table:
CREATE TABLE `mailinglist` (
`id` int(20) NOT NULL auto_increment,
`active` char(1) NOT NULL default
]
Subject: [PHP-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http
ian wrote:
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
http://dev.mysql.com/doc/mysql/en/Old_client.html
--
PHP Database Mailing List
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client
My office purchased 21 fascinating cell phones that have GPS locaters and
bar codes.
When we scan a bar code with one of these cell phones, the data is sent to a
third party company; information about this scan is stored on their
database.
I have installed a harvester on my pc that
write a script that will access the information, then use a CRON to schedule
the collection at whatever intervals suite your needs.
Bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL data harvester
Date: Tue, 2 Nov 2004 10:05:50
I have a query that uses a LIMIT clause. Let's say it looks like this:
SELECT * FROM blah WHERE something0 LIMIT 5;
Ok, now my table really has 20 rows that satisfy the WHERE statement but I
only retrieved 5. There was a function/statement that I could use to find
out the total number of rows
use the offset parameter
$offset = 0; //and is set from the application
SELECT * FROM blah WHERE something0 LIMIT $offset , 5;
bastien
From: [EMAIL PROTECTED] (Jovan Ross)
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql Function to display number of records
Date: 2 Nov 2004 20:28:41 -
I have
Perry, Matthew (Fire Marshal's Office) wrote:
Does anyone know a free MySQL backup program to schedule regular backups?
mysql has the ADMINISTRATOR, well at least for win32...
does timed backups.
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
z
--
PHP Database Mailing List
Does anyone know a free MySQL backup program to schedule regular backups?
On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office)
wrote:
Does anyone know a free MySQL backup program to schedule regular backups?
www.mysql.com
google mysql mailing list
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems
(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message-
From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 8:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL
Stuart Felenstein wrote:
First time setting something like this up. So probably
making some major mistakes.
Anyway I get this message : mysql_error(Resource id
#2)
[snip]
echo . mysql_error($link);
Read the above line or use an editor that does syntax highlighting.
Also, you'll want to get the
a hardware issue than a db server issue...
bastien
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL max records
Date: Sat, 16 Oct 2004 02:01:07 +0200
How many records it can hold before becoming too slow for practical use
depends entirely
Have a look at some of the case studies at mysql.comthere are servers
handling 50Million records with not problemsat a certain point it
becomes more a hardware issue than a db server issue...
bastien
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Matthew Perry wrote:
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Matt
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html
v4.1, but it isn't the stable release at this time.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
thanks,
--
How many records it can hold before becoming too slow for practical use
depends entirely of the hardware that makes up the server.
Current versions of MySQL has a finite limit of 2^64 records per table, but
how many billion records you can shove into it before you start seeing
performance
ApexEleven wrote:
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
Check the output from phpinfo()...
]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql error and resource ID:
Quote as in string or quote as in 'string' ?
Those two confuse me.
Stuart
--- [EMAIL PROTECTED] wrote:
If any of the variables used to insert data are
strings ($f1a, $f2a,
etc...), you'll need to have quotes
Anyone see something wrong here :
My error message is :
0: 1064: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server
version for the right syntax to use near
'd',1,'d',1,1, 31, 33,10/15/2004))' at
line 5
Code:
$query = INSERT INTO MainTable
single
quotes around the whole date, like '10/15/2004'.
dave
Stuart Felenstein [EMAIL PROTECTED]
10/14/2004 10:02 AM
To:
Stuart Felenstein [EMAIL PROTECTED]
cc:
[EMAIL PROTECTED]
Subject:
RE: [PHP-DB] mysql error and resource ID:
Anyone see something
301 - 400 of 1362 matches
Mail list logo