Ok, found the problem.. I've been fighting with this for like an hour
but the error was here:
POSITION() should be LOCATION().. Way to go Niklas! :)
Niklas
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: 29. lokakuuta 2001 15:46
To: Php-DB
Subject: RE: [PHP-DB
I have a large table with quite many dates in format dd.mm. (don't
ask why :) and I want to convert them into -mm-dd for obvious
reasons. How can I do this the smartest way? I know I could do it with
php and update it row by row but that doesn't seem too smart. Can I
somehow do a
On Sat, 27 Oct 2001 13:36:57 +1000
Andrew Duck [EMAIL PROTECTED] wrote:
Error
SQL-query :
CREATE TABLE mail (
from int(32) NOT NULL default '0',
to int(32) NOT NULL default '0',
subject varchar(80) NOT NULL default '',
message text NOT NULL
) TYPE=MyISAM
MySQL said:
Assuming you're using MySQL - 35 seconds is all it took to find:
http://www.mysql.com/doc/P/a/Pattern_matching.html
Good luck!
Russ.
On Thu, 25 Oct 2001 14:16:40 +0300 =?iso-8859-1?Q?Niklas_Lamp=E9n?=
[EMAIL PROTECTED]
wrote:
How can I query for specified fields that has to contain atleast
REGEXP '..+'
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 6:17 AM
To: Php-DB
Subject: [PHP-DB] mySQL Query and blank fields
How can I query for specified fields that has to contain atleast 2
charters?
Example:
Field AAA contains
On Thursday 25 October 2001 13:16, Niklas Lampén wrote:
How can I query for specified fields that has to contain atleast 2
charters?
SELECT * FROM foo_table WHERE length(bar_field)=1;
Arpi
Example:
Field AAA contains '' (NULL) = No match
Field BBB contains ' ' (one charter) = No
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message-
From: Tamas Arpad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:01 AM
To: Niklas Lampén; Php-DB
Subject: Re: [PHP-DB] mySQL Query and blank fields
On Thursday 25 October 2001 13:16
' not '98765' as I expected.
Niklas
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 25. lokakuuta 2001 15:56
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Change that to:
SELECT * FROM foo_table WHERE length(bar_field)1;
-Original Message
?
-Original Message-
From: Niklas Lampén [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:04 AM
To: Php-DB
Subject: RE: [PHP-DB] mySQL Query and blank fields
Thanks a lot! I quite didn't know what to look for in the manual.
I actually have another question:
If I want to update
On Thursday 25 October 2001 15:08, Rick Emery wrote:
First, I wouldn't use length(), I'd use REGEXP: SELECT * FROM
foo_table WHERE fieldname REGEXP '..+'
It's quicker.
regular expression is faster then a length() call? that's seems
strange considering how complex a regexp can be
with
MySQL command: show table status
This command returns multiple fields, including date/time of last update,
for each table in the selected database.
Call it with mysql_query(show table status)
Check the MySQL manual for more information
-Original Message-
From: Sheridan Saint-Michel
-Original Message-
From: Peter [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2001 16:42
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MYSQL Problems Please help
I am runing RH 7 Mysql (installed of RPM), Apache (compiled
version) and PHP
4.0.4pl1
configure command './configure' '--with-xml'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2001 17:11
To: Jason Wong
Subject: Re: [PHP-DB] MYSQL Problems Please help
Jason,
Mysql is running, so thats not the problem.
I tired to run your updatedb to no avail.
my directory for mysql is /var
Check the MySQL manual DATE/TIME functions.
try: DELETE FROM mytable WHERE date_column ( CURRDATE()-30 )
-Original Message-
From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 7:41 AM
To: 'Php-Db (E-mail)
Subject: [PHP-DB] mysql - php DATE
sorry for misspelling: curdate()
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 8:23 AM
To: 'Koutsogiannopoulos Karolos'
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql - php DATE QUESTION...
Check the MySQL manual DATE/TIME
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Russ
Michell
Sent: 25 September 2001 18:32
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Hash Function
G'day folks:
I have a seemingly simple problem:
I keep my passwords as simple MySQL hashes in a
On Tue, 2001-09-25 at 13:32, Russ Michell wrote:
G'day folks:
I have a seemingly simple problem:
I keep my passwords as simple MySQL hashes in a users' table. The rest of the system
is reliant on
this fact (othewise I'd change it quick sharp!)
I've just constructed a simple
: Re: [PHP-DB] MySQL Query Weirdness
When you use mysql_fetch_array you're actually retrieving an array with
two copies of the value you're looking for. One is indexed by the column
number and one indexed by the column name. So it looks like you're
looping through them both and printing each out
Check out for MySQL mailing lists
http://www.mysql.com/documentation/lists.html
-JAson Garber
At 03:42 PM 9/20/2001 -0500, Christopher Raymond wrote:
NOTES: I know this is a PHP list, but I also know that many of you are
experienced MySQL admins. In addition, I was unable to find a MySQL
When you use mysql_fetch_array you're actually retrieving an array with
two copies of the value you're looking for. One is indexed by the column
number and one indexed by the column name. So it looks like you're
looping through them both and printing each out. You might want
mysql_fetch_assoc
: Wednesday, September 05, 2001 4:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL/PHP what is the difference between unset()
and mysql_free_result() ?
Hello,
unset() simply deletes the pointer to the data without releasing the space
held by the data.
mysql_free_result() releases
And how can i free the data-space from a string or somting like that?
b.e.
$string=a very long string;
free($string);#?
#could i use mysql_free_result($string);
Maybe I can use: unset($string=);
or unset($array=array()); to free the data-space also
--
PHP Database Mailing List
nope.
see my previous reply
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 06, 2001 10:11 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL/PHP what is the difference between unset()
and mysql_free_result() ?
And how can i free the data
unset() simply deletes the pointer to the data without releasing the space
held by the data.
mysql_free_result() releases the data storage pointed-to by the $result
pointer.
This is important because $result could be pointing-to a dataspace
containing a large number or rows returned by the
Hello,
unset() simply deletes the pointer to the data without releasing the space
held by the data.
mysql_free_result() releases the data storage pointed-to by the $result
pointer.
This is important because $result could be pointing-to a dataspace
containing a large number or rows returned
Hi,
I'm just a newbie and don't know that much but would putting:
Echo (pre$code/pre);
solve the problem. That's what most people use to display HTML code on an
HTML page.
As I said I'm new and I never tried it. But you can try and see if it works.
Ali
-Original Message-
From:
Yea I tried that before I posted I even tried editing the data in the table
to but the pre before and /pre after and it still will not show it.
--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!
Ali Nayeri [EMAIL PROTECTED] wrote in message
[EMAIL
That did it thanks for the help.
--
Cross Walk Central
www.crosswalkcentral.net
Support Center
Your Web Hosting Community!
Paul Burney [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
on 9/1/01 7:12 PM, CrossWalkCentral at [EMAIL PROTECTED] wrote:
Yea I tried
on 8/30/01 4:06 PM, Malcolm White at [EMAIL PROTECTED] wrote:
$query = UPDATE Groups SET GName=$new_name WHERE GID=$gid;
If the Gname field is a string type, there should probably be quotes around
it.
$query = 'UPDATE Groups SET GName=' . $new_name . ' WHERE GID=' . $gid;
HTH.
On Tue, 28 Aug 2001, Brian Grayless wrote:
Gotta problem
For some reason, many of my persistent connections aren't terminating. I end
up with up to 30 connections to MySQL that aren't being used. My guess is
that the user connection is slow and the script never finishes running or
- Original Message -
From: Arcadius A. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 9:28 PM
Subject: [PHP-DB] MySQL DB CleanUp Help!
Hello !
I'd like to automatically delete old entries from my MySQL
Is there any special funcion in PHP or MySQl for
Or of course one could compile PHP as a standalone and simply cron the
script itself.
No matter how PHP is invoked, though, IMHO scripts like this that require
no human interaction should be a bit more robust than interactive systems.
For example, one would probably want to code it to make sure
on 8/17/01 8:35 AM, Fai ([EMAIL PROTECTED]) wrote:
Does any body know how to prevent mysql server looking for user specific
optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in
his home directory to affect the mysql server behaviour.
Please try the MySQL list since
on 8/13/01 1:56 PM, Szii ([EMAIL PROTECTED]) wrote:
Opening multiple databases on the same database machine
seems unsupported. While you CAN do it, it has a tendency
to reuse the last connection even in lieu of a specific database.
Right now we're using mysql_db_query() to get around it,
it on two different links, it's seems to modify both
links. Almost like it's global
*shrug*
-Szii
- Original Message -
From: Paul Burney [EMAIL PROTECTED]
To: Szii [EMAIL PROTECTED]; php mailing list [EMAIL PROTECTED]
Sent: Monday, August 13, 2001 2:28 PM
Subject: Re: [PHP-DB] MySQL
At 07.08.2001 20:39, Brian Weisenthal wrote:
hey,
im using php and mysql. i am sure that i am getting mysql errors but for
some reason they are not being displayed making it real hard to debug. i
hate debugging, im going to go insane..i cant see my errors
helpplease, pretty
Hi Ralph,
Here is how I do it, which is how you suggested.
Regards,
Chris...
#--
CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`browser` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);
INSERT INTO test VALUES
to the database where the first connects at the same
time.
Anyway glad you fixed your problem. It wasn't a holiday in Australia (just
a Sunday night :-))
Cheers
Howard
-Original Message-
From: sg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 9:40 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP
Have a look at how I would insert data in your case.
Howard
-Original Message-
From: sg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 29 July 2001 8:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL newbie: inserting new entry to table?
Hi folks!
I'm new to PHP/mysql.
I created a db
Thank You Howard!
You sure are quick!
I found a way to make it work. I used to have both scripts (the one that
displays and the one that inserts new entries) on the same page...
Once I separated them I had a link on a third page. I first clicked on the
insert entry link then back to the display
on 7/26/01 11:11 AM, Steve Fitzgerald ([EMAIL PROTECTED]) wrote:
ran the query in the MySQL client and got the ERROR 1054: Unknown column
'$ContactID' in 'where clause'. I know the column ContactID exists.
Of course it did. It can't find the text $ContactID in the table. Try
putting in a
In Oracle, the syntax for a theta-style join (the one you're describing)
is:
SELECT ...
FROM ...
WHERE item1 (+) = item2
However, MySQL doesn't support this syntax. The only way to do left
(outer) joins in mysql is the way you described:
SELECT ...
FROM ...
LEFT JOIN ... ON ... = ...
Thanks. I was using MySQL by DuBois book as a reference.
Jeff
According to the manual, 12 is YYMMDDHHMMSS and 14 is MMDDHHMMSS.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME
Jeff Oien [EMAIL PROTECTED] wrote:
I have a field that's timestamp(12)
I CC-ed the mailing list by accident. Below is my original reply to Brian.
-Original Message-
From: Jonathan Hilgeman
Sent: Thursday, June 28, 2001 8:14 AM
To: 'Brian Grayless'
Cc: PHP-DB (E-mail)
Subject: RE: [PHP-DB] MySQL Error???
Hi Brian,
Sounds like you have a tinyint field
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Steve Brett) wrote:
'invalid index test assumed 'test' in test.php at line 13' can't
remember the exact syntax but that's the general idea.
if i quote the var when i reference it the error goes away. like
$arow['test'] as opposed to
Thanks guys. It was all very helpful and worked great!
Brian
-Original Message-
From: Christian Sandfeld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 3:06 AM
To: 'Brian Grayless'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] MySQL Error???
Brian,
Sounds to me as if the field
At 9:05 AM +0100 6/22/01, Russ Michell wrote:
Is this a new use of the function mysql_num_rows?
No!.
It's not a change in syntax, but it is a change in PHP's behavior.
In PHP 4, mysql_num_rows() and mysql_num_fields() will issue error
messages if the argument is not a result set. In PHP 3
the code wasn't mine.
it was a drop in message board.
Steve
-Original Message-
From: Jason k Larson [mailto:[EMAIL PROTECTED]]
Sent: 28 June 2001 11:12
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql errors or php errors
Another thought came to mind
sounds like your field definition is something like int(2) or something, it
needs to be bigger so that it can handle higher numbers for the unique
primary key :)
// -Original Message-
// From: Brian Grayless [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 28 June 2001 12:24 AM
// To: PHP
Hi,
This error occurs when your auto_increment index field is of type TINYINT.
This field type can accept values form -128 to 127 so you cannot add records
with index value greater than 127.
I recommend you change it to INT(11) UNSIGNED which can accept values from 0
to 4294967295.
If you expect
Brian,
Sounds to me as if the field you have as primary key is set to type
'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when
set to 'unsigned' it accepts values from 0 to 255.
In your place I would concider changing that column to a 'SMALLINT' and set
it to 'unsigned'.
Another thought came to mind.
These errors could be the result of verbose error reporting by PHP.
php.ini or a script could be setting error reporting high enough to display
these errors, however it's extremely poor PHP coding syntax to not correctly
quote everything (except constants, of
At 27.06.2001 17:24, Brian Grayless wrote:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add
Most likely, your id (index, auto-increment field, whatever it is) data type
is tinyint which only goes to 127.
Brian Grayless [EMAIL PROTECTED] said:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works
Hi
You create a unique index (i think primary) an try to enter a key that is
already in the table.
greetings saul
- Original Message -
From: Brian Grayless [EMAIL PROTECTED]
To: PHP DB list (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 12:24 PM
Subject: [PHP-DB] MySQL
on 6/27/01 9:24 AM, Brian Grayless at [EMAIL PROTECTED] wrote:
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add them anymore. Any
On Wed, Jun 27, 2001 at 10:24:13AM -0600, Brian Grayless wrote:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
The error means you are attempting to put a second record in with the
value of 127.
I wrote a great bookmark management program that works fine, but
-Original Message-
From: Brian Grayless [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 11:24 AM
To: PHP DB list (E-mail)
Subject: [PHP-DB] MySQL Error???
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark
Tomás García Ferrari pressed the little lettered thingies in this order...
Hello,
I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on
lines like this:
$rows = mysql_num_rows($result);
and noticed that this is a solution:
$rows =
on 6/21/01 2:30 PM, Tomás García Ferrari at [EMAIL PROTECTED] wrote:
I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on
lines like this:
$rows = mysql_num_rows($result);
and noticed that this is a solution:
$rows = @mysql_num_rows($result);
Is this a new
$rows = mysql_num_rows($result) should work. If you want to know what's
going on, try doing:
?php
$rows = mysql_num_rows($result) or die(Error grabbing number of rows. MySQL
said:pfont color=red . mysql_error() . /font);
?
-- David Balatero
-Original Message-
From: Tomás García Ferrari
Hi,
the '@' is an error control operator avaialble in all php versions. When
prepended to an expression in PHP, any error messages that might be
generated by that expression will be ignored.
Check the PHP Manual for more info.
Dobromir Velev
-Original Message-
From: Tomás García Ferrari
Is this a new use of the function mysql_num_rows?
No!
You can use the @ to 'suppress error messages' that may reveal
delicate information to users such as paths to directories on your
server. It can be preppended to almost any php function likely to
result in an error, if used incorrectly.
.
Steve
-Original Message-
From: Shriram Chaubal (Personal) [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2001 15:31
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql client compression with php?
Is there anyone who can help with this? Or is there a paid
support option I
could use
Is there anyone who can help with this? Or is there a paid support option I
could use to help resolve this issue?
Regards,
Shriram
Shriram Chaubal (Personal) [EMAIL PROTECTED] wrote in message
9gntu2$ng8$[EMAIL PROTECTED]">news:9gntu2$ng8$[EMAIL PROTECTED]...
Hi,
I have to connect my php
]]
Sent: Thursday, May 17, 2001 2:16 PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem
I'm on Windows 2000.
Jeff
Jeff,
If you are on unix/linux use the command id to see who you are.
You can only use jeff in your connect string if jeff is a user in your
mysql
ook like this
?
$host=localhost;
$user=;
$password=;
$dbasename=database_name;
?
You shouldn't need a password.
I hope this helps
All the Best
Lisa
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:16 PM
To: PHP-DB
Subject:
: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 2:16 PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem
I'm on Windows 2000.
Jeff
Jeff,
If you are on unix/linux use the command id to see who you are.
You can only use jeff in your connect string if jeff is a user
PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem
I'm on Windows 2000.
Jeff
Jeff,
If you are on unix/linux use the command id to see who you are.
You can only use jeff in your connect string if jeff is a user in your
mysql
database.
If you are root when you
of something
else. Very weird, but its worth a shot.
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 8:24 PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem
Yes they are.
Jeff
Is the MySQL and Apache running on the same
: Tuesday, May 15, 2001 8:24 PM
To: PHP-DB
Subject: RE: [PHP-DB] MySQL Connect Problem
Yes they are.
Jeff
Is the MySQL and Apache running on the same machine?
Jeff Oien wrote:
I have MySQL on a new Win2000 install and can't connect to it using
PHP.
I am
Dammit, that code looks right.
So
1. Have you tried it at the mysql console? What results?
2. How accurately does day match $day? Have you tried = instead of LIKE?
Maybe it's doing it twice?
3. Is day distinct? How do you know you have only one?
When you tested with 2, assuming i had a
Message -
From: Miles Thompson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 3:50 PM
Subject: Re: [PHP-DB] mySQL Addition Problem
Dammit, that code looks right.
So
1. Have you tried it at the mysql console? What results?
2. How accurately does day match
WOW - sharp eyes!!
Miles
At 04:02 PM 5/16/01 -0700, Szii wrote:
Remove the comma after the SET clause?
-Szii
- Original Message -
From: Miles Thompson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 3:50 PM
Subject: Re: [PHP-DB] mySQL Addition Problem
Dammit
Here is sample code:
?
$connection = @mysql_connect(localhost, jeff, *)
or die(Couldn't connect.);
if ($connection) {
$msg = success!;
}
?
This is on my machine only used by me. I also tried connecting to
IP address and 127.0.0.1 and it still won't work. Thanks.
Jeff Oien
Are
Here is sample code:
?
$connection = @mysql_connect(localhost, jeff, *)
or die(Couldn't connect.);
if ($connection) {
$msg = success!;
}
?
This is on my machine only used by me. I also tried connecting to
IP address and 127.0.0.1 and it still won't work. Thanks.
Jeff
Is the MySQL and Apache running on the same machine?
Jeff Oien wrote:
I have MySQL on a new Win2000 install and can't connect to it using PHP.
I am able to connect using the command line. I'm not sure what the next
step is to troubleshoot. I've checked the username and password in the
.ini
Yes they are.
Jeff
Is the MySQL and Apache running on the same machine?
Jeff Oien wrote:
I have MySQL on a new Win2000 install and can't connect to it using PHP.
I am able to connect using the command line. I'm not sure what the next
step is to troubleshoot. I've checked the username
how to set mysql to ask password to any user who try to enter ?
If you are using a GUI like phpMyAdmin to administer the MySQL
database, you can use it to prompt for a username and password such as
would occur with a .htaccess/.htpasswd file combination.
If you're on the command line - in
If I were U I would convert it to UNIX date first subtract and then restore
to normal format what do U think !?!?!
Mikail [EMAIL PROTECTED] escreveu na mensagem
008c01c0d2f2$2e0df880$bb02a8c0@maz">news:008c01c0d2f2$2e0df880$bb02a8c0@maz...
hi,
I'm a newbie from Italy
I use php with mysql
Here's how I'd do it:
SELECT * FROM customers WHERE Site='egebjergnet' AND
TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'
where date_column contains record dates...
Martin
Dan Eskildsen [EMAIL PROTECTED] wrote in message
9crq7l$mfb$[EMAIL PROTECTED]">news:9crq7l$mfb$[EMAIL PROTECTED]...
IT works!
Thanks!
martin helie [EMAIL PROTECTED] skrev i en meddelelse
9crqud$voj$[EMAIL PROTECTED]">news:9crqud$voj$[EMAIL PROTECTED]...
Here's how I'd do it:
SELECT * FROM customers WHERE Site='egebjergnet' AND
TO_DAYS(NOW()) - TO_DAYS(date_column) = '45'
where date_column contains
Check to see that mySQL is running on your system. On mine, when it is not,
I get an error just like that.
Matt
LENNART KARLSSON [EMAIL PROTECTED] wrote in message
9cefep$4pu$[EMAIL PROTECTED]">news:9cefep$4pu$[EMAIL PROTECTED]...
Hi!
I have a problem when I try to use a mySQL connection.
I
what is your SQL select statement ?
olinux
--- johndmiller [EMAIL PROTECTED] wrote:
Ok here is my problem. I have this database and the
key is comprised of
two fields, filename and path to file. When I read
based on this key, I
get 0 records found. When I insert the same record,
it will
Some people in the APC mailing list have said that mysql blows up at around
200-300 queries a second.
http://lists.communityconnect.com/pipermail/apc-cache/2001-April/000611.html
Phil Jackson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Some good advice
Some good advice already given, and I quite agree. MySQL is no light-weight -
comparable to MS SQLServer and Oracle in performance. Also, running the DB on a
dedicated DB server may buy some performance. If you must check out SQLServer, then
http://www.sqlteam.com is a good place to start.
Your DB needs sound more hardware intensive than anything. Your queries
sound simple and I would bet you would never need to use anything but
mysql. Also keep in mind that mysql/php/apache etc run on more than just
PC's. There is some serious hardware out there that can handle
If anyone has had some experience with upgrading as your operations grow,
I'd appreciate if you could answer ANY of the following questions:
Did you say M$.. yuck.. if you think you need something else then MySQL you
could take a look at PostgreSQL.. It's good, it's free and it doesn't have
On Tue, Apr 17, 2001 at 05:52:53PM -0400, Peter J. Krawetzky wrote:
How do you move the database files to another location in MySQL? I am
running Redhat 7.1 with MySQL version 3.23.33.
You ask the appropriate list @ [EMAIL PROTECTED]
Of course by the time you do so, you have already
a common question. This might help
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Missing_Transactions
--
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 8:36 PM
Subject: Re: [PHP-DB] MySQL transactions?
a common question. This might help
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Missing_Transactions
--
Regards,
Gary "SuperID"
At 21:20 8-4-01 +0200, Adam wrote:
Hello,
I have a fresh instalation of mysql from the ditribution of RH7.
What do I have to put into the user and host tables so that
I can use MySQL through PHP (I doesn't have to be super-secure,
just so that not everybody could get to my databases)
I don't
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Lee Stretton) wrote:
Got a bit of a problem with the number of users accessing a website
driven by a MySQL database. I want to increase the number of allowed
connections to the database, I have found the variable to change
(max_connections)
www.mysqlfront.de
I have used it and found it to be great. However I am a beginner and if
there is a better product please let me know.
All the best
Lisa
-Original Message-
From: Rosen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 3:26 PM
To: [EMAIL PROTECTED]
Subject:
what about kmysql and kmysqladmin ??
Greetinx,
Mike
-Original Message-
From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 4:34 PM
To: 'Rosen'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL manager
www.mysqlfront.de
I have used it and found
Jeff,
Check www.freshmeat.net There are a couple of packages out there that
already do this. Some of them use MySQL. If nothing else, you can borrow
their database schema.
Cal
http://www.calevans.com
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: Monday, March
At 26.03.2001 22:21, you wrote:
how bout something like this.
You have 3 columns
TOTAL_HOURS | UNPAID_HOURS | LAST_PAID
when you are paid, update TOTAL_HOURS to add UNPAID_HOURS and clear [delete,
or set to zero] the UNPAID_HOURS column... LAST_PAID would be type =
timestamp, or date.
You could
On Sat, Mar 24, 2001 at 11:22:37PM +0800, Fai wrote:
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query:
Hi,
to do this you'd need to be a quite priviledged user.
in order to create users you'll need acces to the
user-table of mysql. not likely to be given to a "normal"
user. developing on your home pc, well...
you need GRANT to grant priviledges to any user.
also not likely to be given to a user.
In the 'user' table in the 'mysql' database on server1, you need to insert
the username you'll be using to connect (and the encrypted password), and in
the Host field you have to specify the hostname of server2, as well as what
privileges you want that user to have (I recommend nn,
801 - 900 of 916 matches
Mail list logo