appreciated.
Regards,
Patrice Olivier-Wilson
828-628-0500
http://Biz-comm.com
b...@biz-comm.com
Everything will be alright in the end, so if it is not alright, it is not yet
the end. - Quote from movie: The Best Exotic Marigold Hotel
--
MySQL General Mailing List
For list archives: http
just a few thoughts (things to look into)
if you want to populate a db with command parameters, i'd mine the man
pages. it's a consistent format and you should be able to find a
parser for whatever language you prefer.
if you want to see what has been entered and statistics about that
process,
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller fuller.art...@gmail.com wrote:
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column? I try to design my tables such that every column is NOT
On Aug 3, 2011 9:24 AM, David Lerer dle...@us.univision.com wrote:
I rarely use aliases (unless rarely required in self-join queries).
When I have that option, I create unique columns by prefixing every
table (and its objects) with a number.
Something like:
Create table T1234_Employee
mysql select day(now())-5;
+--+
| day(now())-5 |
+--+
| 26 |
+--+
2011/7/31 yavuz maslak mas...@ihlas.net.tr:
I don't want all records during 5 days ( 24*5days ) . Only I need records
at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
Look into select into or just insert. The mysql doc covering this might even
have a suitable example.
On Jul 23, 2011 8:42 AM, Velen Vydelingum ve...@biz-mu.com wrote:
Hi,
I have 2 tables and need to create a 3rd one as follows:
Table Sales:
Code Price sQty sDate
123 12.00 2 2011-03-12
190
On Thu, Jul 14, 2011 at 10:50, Jerry Schwartz je...@gii.co.jp wrote:
There are a couple of problems with using any database for doing this.
you're probably right. that said
- Rows in a table are inherently in no particular order. That means they are
neither sorted nor random.
-
On Jul 13, 2011 2:26 PM, Elim Qiu elim@gmail.com wrote:
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
|
On Jul 13, 2011 6:41 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
I have million of sites stored in url column of a mysql table.
I need to shuffle the . words . Is there any in built function in mysql to
achieve this.
Why would you want to do this in mysql? What's your
I'm actually enjoying this discussion because I have the same type of issue.
However, I have done away with trying to do a full text search in favor of
making a table with unique fields where all fields should uniquely identify
the group. If I get a dupe, I can clean it up.
However, like you,
i'm just looking for rough ideas here...
i've got a table that has 31 fields. most of them need to be there
(entry time, exit time, entry lat, etc). however, i've got 4 fields
that i query this db with that should generally be unique... well,
really 3 fields that should be unique, because the
Hi,
I have a situation where I need clients to connect to a proxy server and to
then determine which MySQL server to forward their connection to based on
the username supplied. Does anyone know if this is possible using
mysql-proxy with Lua? Or by any other means?
Thanks.
REW
I have a question that this list solved a year ago, and I can't remember
what the solution was. Does this list have an archive?
(Sorry if it is on one of the links to the list, but I don't have any on
hand at the moment.)
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing
On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote:
I have a question that this list solved a year ago, and I can't remember
what the solution was. Does this list have an archive?
(Sorry if it is on one of the links to the list, but I don't have any on
hand at the moment.)
see
Dear:
I would like to share with you my recently shopping experience: I
found a very excellent e-site, the above is the latest and most
popular products. By their staff, understanding that they have stable
supply channel, so the price of products is shock your eyeballs burst.
Certainly I will not
On 9/28/10 8:33 PM, Chris W wrote:
SELECT *
FROM announcements
WHERE announcements_expiredate CURDATE()
AND announcements_postdate = CURDATE()
ORDER BY announcements_expiredate ASC
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives
an announcements_postdate in the table. Just not sure what the
WHERE should be to not show until that date.
Thanks much,
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
On 9/28/10 10:52 AM, Patrice Olivier-Wilson wrote:
Hi... beginner here. Working on a php page and using this
$query_announcements = SELECT * FROM announcements WHERE
announcements.announcements_expiredate CURDATE() ORDER BY
announcements_expiredate ASC ;
Client now wants the announcement
Thanks all... I got this to work! Much appreciated..
And thanks for patience with a newbie!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, but then I couldn't expand
later.
Reverse is true if I add user_ID to the Topics.
So, need an idea how to solve this so it doesn't matter how many new
users I keep adding, I can still see who is using the topics.
As I said, a newbie question. Thanks much.
--
Patrice Olivier-Wilson
http://biz
On 9/10/10 12:31 PM, Jerry Schwartz wrote:
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
that
there is already a table named tips in databaseB.
Yep, know that... I want to bring in the contents...not make a new table.
Any help, most appreciated
Thanks as always
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
I have 2 databases, different domains. Both have a table named
'tips'... both have different contents in the table.
Using phpMyAdmin for GUI.
I want to export databaseA tips as sql (done) then import content
into databaseB tips. But when I run
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
I have data I need to keep in both db just trying to merge.
There's two ways around this:
First is to not export the structure (uncheck structure). The second
is to export with if not exists. This should (IIRC) do a create
table
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
Gave it a try got this:
MySQL said:
#1062 - Duplicate entry '1' for key 1
Yeah, that's what I was saying about in my previous mail. It looks
like you've got a primary key on one of your columns, and you're
attempting to insert data
:
On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson
michaelwilso...@gmail.com wrote:
I am running MySQL 5 on OS X Snow Leopard...
Have it set up (by installing the pref pane) to always be running as
soon
as my MacBook starts.
For some odd reason, I can't remember the password I issued
Okay, that worked, thank you!
-Mike
On Nov 16, 2009, at 6:49 PM, Hassan Schroeder wrote:
On Mon, Nov 16, 2009 at 6:15 PM, Michael Wilson
michaelwilso...@gmail.com wrote:
I don't know what the password is for the Unix mysql user...
You mean sign in as mysql in the OS X Login Window
I am running MySQL 5 on OS X Snow Leopard...
Have it set up (by installing the pref pane) to always be running as soon as my
MacBook starts.
For some odd reason, I can't remember the password I issued for root user and
wish to either change it back to blank or a new specific password.
What
a thought. If anyone has any insight, most appreciated.
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
CRLF (chr(13)chr(10)).
andy
Patrice Olivier-Wilson wrote:
In case anyone might find this of the least interest, probably not,
but I always hope to add to discussion just as part of the thank you
for help.
Further work with same issues found that a file received from a PC
based client, if opened
Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to import and it stopped at line 17 (again). BUT progress!
So, went back to the converter and entered into SQL on phpmyadmn
interface... viola! success.
Thank you both so much for your help.
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives
(not the table) --
viola!
:-)
Just thought I'd share in case anyone else might need it...
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.)
posted by . February 14, 2007
)
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
(above represents an empty portfolio_ID, a filled in sort_ID, title,
empty bodycopy, image, empty before)
Thank you.
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
Yep, typo ...:-(
I
.
--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
+44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greetings:
I have a project for which need to import cvs files into db
Hi everyone --
I'm pretty new to MySql, but not many years ago I was an ISAM guy so I
understand the issues with indexes and on-the-fly inserts.
I've seen many questions around this error message, Access denied; you need
the RELOAD privilege for this operation. But I'm not grokking the
Hi folks --
What would be the right approach in MySql 5.0?
My table, USERS, has columns NAME and IP. Associated with each user is also a
collection of from 0 to 50 INTs. What's a reasonable way to put these 50 INTs
in the table without using 50 separate columns, INT01...INT50? Is BLOB an OK
Pete wrote:
Hi folks --
What would be the right approach in MySql 5.0?
My table, USERS, has columns NAME and IP. Associated
with each user is also a collection of from 0 to 50 INTs.
What's a reasonable way to put these 50 INTs in the table
without using 50 separate columns,
Hi folks --
I am new to MySQL and just laying out what I hope will be just one db that
holds all the info for a list of forged or machined metal parts.
Let's say there are 10,000 such parts, each with a unique part number. That
part number is the primary index.
Each part has at least one,
, from someone with experience.
-- Pete Wilson
http://www.pwilson.net/
--- On Thu, 5/14/09, Jim Lyons jlyons4...@gmail.com wrote:
From: Jim Lyons jlyons4...@gmail.com
Subject: Re: MAC address as primary key - BIGINT or CHAR(12)
To: Ilia KATZ ik...@dane-elec.co.il
Cc: mysql@lists.mysql.com
) and also
the readable representation (just for debugging/problem-solving)? (Well, of
course I know what the cost is: it's 12 bytes, plus overhead, per row.)
It all depends, but in general, would you call that too costly, given the
benefit?
-- Pete Wilson
http://www.pwilson.net
http://www.kionic.com
I've been a very active and heavy customer for years and very satisfied.
-- Pete Wilson
http://www.pwilson.net/
--- On Sun, 4/19/09, Cameron Rogers cameronl...@gmail.com wrote:
From: Cameron Rogers cameronl...@gmail.com
Subject: A good US Hosting Site
\, \p...@pwilson.net\); );
I can imagine this happening when the connector is running in real life. So:
What is the correct and reasonable way for a running connector to deal with
this error intelligently?
Thanks!
-- Pete Wilson
http://www.pwilson.net/
--
MySQL General Mailing
!
-- Pete Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Recent books that I've looked at have 2 ISBN's - one the older 10 digit, and
also the newer 13 digit version. Both printed on the same book (both on the
back cover at the bottom and inside).
Of course, a hard cover will have a different ISBN again.
Hooker
--
If ignorance is bliss, politicians
Hi. I'm brand new at this so I'm looking for a little help.
I need to have two difference levels of access to a mysql database that I am
developing for our librarians to use to maintain the various research
resources we have available in our library. AdminType1 should have Delete,
Insert,
It seems that mysqldump on mysql 5.0 does not export my stored
procedures.
How do I dump these out so that other people can load them into their
copies of my database?
Matt
--
A better way of running series of SAS programs:
http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles
--
MySQL
I'm writing a stored procedure that gets a VARCHAR(45) as a parameter.
Inside my stored procedure, I want to create a table with a name based
on that parameter.
For example, if I do
call my_sp('XXX');
I want the stored procedure to create a table named foo_XXX.
I don't know how to do this.
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want to draw a picture with a box
for
I wrote a fairly large query that summarizes our sales into monthly
totals by business unit, then left joins on some other information from
a bunch of other tables.
Running the query takes a long time.
I'm considering whether to store my summary data as a table, like this:
create table
rao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Ben Wilson
Mundus vult decipi, ergo decipiatur
?
Regards,
Ben Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3,
hi ,
I have crerated a mysql database to store images , mp3 , video files..etc. In
my first stage i stored images as jpg , gif .
But when i try to store little but huge gif files it wont store . I used the
script as follows to upload images,
html
head
titleUpload File To MySQL
PROTECTED] wrote:
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
This seems to be a common question, but answers aren't that common...
What are people using as a web-based reporting tool? I'd like to add a
user-facing interface to allow users to run pre-defined reports (in which
they may need to enter data, like Start Date and End Date) against their
data.
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die(Couldn't get
file list);
if (!isset($result))
{echo NULL;}
//if
hi Friends,
I have a WAP portal which is running based on mysql database. That's meant that
contents has been stored in the data base.
wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now
now problems with the content retrieving. WAP site hosted in REDHAT Linux BOX.
I
- for
example, 08 is Western Australia, and also South Australia. And
literally millions of numbers don't have an area code at all - mobiles
and everything starting with 1.
Paul Wilson
iiNet Ltd
6/263 Adelaide Tce, Perth, WA6000
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
OK so...
I'm having this problem where I'm trying to store (rather small
(36-byte)) hex values in MySQL, but some of them end up getting
truncated, therefore breaking my app... I'm using 4.1.10, with
--default-table-type=InnoDB... Or what ever option that is
anyway... point is, all of
of this but I'm thinking it's CPU.
Thanks again!
scott
On Jan 6, 2005, at 1:58 PM, Scott Wilson wrote:
Hello,
I'm interested to hear peoples' experiences running mysql on OS X.
I've moved the database for a fairly heaily used website (~ 2M queries
a day) over to a new dual 2GHz XServe running OS
can go 64
Bit, I expect we'll be a lot happier with our OS X G5s and can put enough
through them that we'll start to see CPU use become significant... It'll be
like getting two more servers for every server we already have.
Best Regards, Bruce
On 1/6/05 7:58 PM, Scott Wilson wrote
Hello,
I'm interested to hear peoples' experiences running mysql on OS X.
I've moved the database for a fairly heaily used website (~ 2M queries
a day) over to a new dual 2GHz XServe running OS X Server 10.3.7.
This database has run smoothly on an aging dual PIII machine running
freebsd for the
understand that I could use
LIMIT, but has anyone got any working example of this?
Thanks
Keith Wilson
www.giraffedog.net
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.618 / Virus Database: 397 - Release Date: 09/03/2004
--
MySQL
Hi all,
I have some questions I thought people might be able to enlighten me on.
I have a database of website content that I have inherited that is
full of standards-killing html (about 500 website pages; long story). I
would like to change that, but its a job that is a little too big for
connectivity but the question is How in
linux.
--
Chadley Wilson [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
concatenate columns using a special operator.
Depending on what DBMS you are using, this can be a plus sign (+) or two
pipes (||).
Neither seem to work.
Can anyone point me in the right direction?
Thanks.
Gilbert Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
VALUES ('1', '04/13/2002', '10:46:19');
INSERT INTO blah_events_power VALUES ('1', '07/28/2002', '11:51:19');
**
Should return 6 dates:
'04/13/2002'
'04/14/2002'
'05/13/2002'
'05/24/2002'
'06/21/2002'
'07/28/2002'
--
Mark Wilson, Computer Programming Unlimited
We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of
MySQL, it does everything as far as installing and compiling it for us. But what we
found is that is stores the databases where it wants and would like to move them but
cant seem to figure it out. Does anybody
I have just recently compiled Mysql 5.0 onto my redhat linux box, and
have been trying to set up some store procedures, but have yet to be
able to figure out how. Can anyone help me on this on how to go about
creating a stored proc in Mysql 5.0??
Any help or suggestions would be great.
I have just recently compiled Mysql 5.0 onto my redhat linux box, and
have been trying to set up some store procedures, but have yet to be
able to figure out how. Can anyone help me on this on how to go about
creating a stored proc in Mysql 5.0??
Any help or suggestions would be great.
syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'SELECT MAX(
plan_submission_number )
FROM 'artifacts'
WHERE p
---
What am I missing? Thanks
- Mark
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web
' AND plan_submission_number = '2')
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web : http://cpuworks.com Tel: 410-549-6006
Email: [EMAIL PROTECTED] Fax: 410-549-4408
Quoting Mark Wilson [EMAIL PROTECTED]:
I have an app for which people can submit plans.
Each plan
Er, I _used_ a basic SQL tutorial, which specifically said that should work.
The problem seems to be a limitation of MySQL, not general SQL operation.
That being said, are there any clever one-query options (using JOINs, etc?) or
is this basically a 2-step process in MySQL?
--
Mark Wilson
Hi. I'm a relative MySQL newbie.
A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box.
After some use, the system began to run very slowly, e.g, the login
box, start menu, and other apps were taking a few seconds to respond
to my mouse. Rebooting did not solve the problem.
By trial
, interactions, or missettings that might
cause this kind of behavior? I would dearly like to learn MySQL, but I can't
reinstall it if it is going to peg my system.
- Dave Wilson
. The problems with
Apache and the mail composer also went away.
Does anyone know of any bugs, interactions, or missettings that might
cause this kind of behavior? I would dearly like to learn MySQL, but I can't
reinstall it if it is going to peg my system.
- Dave Wilson
I ran into this too. I assume it is a limitation on the free version of MySQL, and
that
you have to pay to use load data in an SQL script. To import my data files, I use
the mysqlimport function from the command line or batch file. It seems to support
most of the load data options.
-
Is it possible to rename a MySQL table? If so, how?
If not, is there a simple query syntax to copy a table?
I don't have access to the command-line version,
just a web interface, and no, not anything nice like PhpMyAdmin! :-(
--
Mark Wilson, Computer Programming Unlimited (cpuworks.com)
Web
Hi guys,
Hopefully have an easy question for you guys.
Whats wrong with this query
Select * from Tablename where drinks is not = 'pepsi';
Driving me batty..
A cookie for the right answer..
t 8920 8877
f 8920 8866
e [EMAIL PROTECTED]
w http://www.netwaynetworks.com.au
Lol,
I keep the cookie.
I was just looking for the != syntax..
-Original Message-
From: Andrew Wilson
Sent: Friday, March 21, 2003 11:49 AM
To: '[EMAIL PROTECTED]'
Subject: where drink is not equal to pepsi
Hi guys,
Hopefully have an easy question for you guys.
Whats wrong
Lol.. beat me by 2 minutes.. Can i fed-x that cookie ?
-Original Message-
From: Jon Wagoner [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:54 AM
To: Andrew Wilson; [EMAIL PROTECTED]
Subject: RE: where drink is not equal to pepsi
Select * from Tablename where drinks != 'pepsi
Hi all!
Using mysql 2.23.54a as both master slave:
** On master:
mysql CREATE DATABASE repl_test;
Query OK, 1 row affected (0.03 sec)
mysql USE repl_test;
Database changed
mysql CREATE TABLE test (
- a INT UNSIGNED AUTO_INCREMENT NOT NULL ,
- b INT UNSIGNED NOT NULL,
- PRIMARY
, stack_end=0xba2c) at ../sysdeps/generic/libc-start.c:129
Fix:
None known at this time, desperately searching for a solution...
Submitter-Id: Chris Wilson [EMAIL PROTECTED]
Originator:ditto
Organization: NetServers Ltd, Cambridge, UK.
MySQL support: none
Synopsis: MySQL crashes
When can we expect a release of 5.0 with stored procedure
functionality in MySQL?
Sincerely,
Joshua Wilson
Software Engineer
SOSystems Corporation
[EMAIL PROTECTED]
801-222-0200
'Whoever controls your thoughts, controls your actions
to pull out 1 coke,1 fanta,1 pepsi .
Thanks for your help, a virtual beer to whoever answers my question :)
Andrew Wilson
Technical Support
Netway Networks
8920-8877
Netway Networks Pty Ltd
(T) 8920 8877
(F) 8920 8866
John,
and I am getting this error message
ERROR 1030: Got error 28 from table handler
# perror 28
Error code 28: No space left on device
Free some disk space!
I have figured out that it is t0.test that is causeing the problem as when i
remove it the query works. This query has been
'?
* title VARCHAR
* text TEXT
I need the date col to remain the same, what am I doing wrong?
Much thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE9CeQ3HpvrrTa6L5oRAp4KAKCeXaGZg7U2GK9HvSvincd+hZytFgCgqG3l
ignores the update
for efficiency.)
*You explicitly set the TIMESTAMP column to NULL.
HTH!
Sure does, cheers Jay.
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE9CfkZHpvrrTa6L5oRAlgCAJ47bPK5shotAZek3a8p7Fw8ZqoyFACgq8JV
, user, pass);
mysql_select_db(dbmt);
$result=mysql_query($qry);
As you can see, there is nothing special there... So what would cause it
to insert *2* records?
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
I'm having some weirdness when inserting from the php api, I do not get
the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing
tried this sql:
SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id =
'2';
to no avail.
Could someone please explain what I *should* be doing?
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
anyway. Here is what I've
get:
You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1
That comes from exactly what you have above, it works without the 'as
desc' part but then I have no way to get at it?
Cheers...
- --
Nick Wilson // www.tioka.com
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1
Ooops, reserved word! Works great ;-)
Any way to add something to it like or should I do that in my
php?
Many thanks
See what I mean?
I can't beleive there is nothing that can be done with sql about this
but I can't seem to find anything that will tell me how to do it so a little pointer
would be smashing.
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version
;
$qry.=FROM $this-table ;
$qry.=WHERE module = '$module' ;
$qry.=ORDER BY date ASC;
Thanks very much for the help!
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
?
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgMQCcDxoq
iOgEUaj2XvG3trF/nWqQXt4=
=Uh1r
-END PGP SIGNATURE
1 - 100 of 149 matches
Mail list logo