2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables "events" and "categories" which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 |
Oh yeah, forgot to mention that. Yes, one event will have multiple
categories. And one category can be applicable to multiple events.
On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal <
jaiswal.dha...@enzenglobal.com> wrote:
>
> Just curious as it is not mentioned. Can Category ID also have multi
Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables "events" and "categories" which
look like th
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
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
--
My
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
>-Original Message-
>From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
>Sent: Friday, September 1
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did wrong.)
Jerry Schwartz wrote:
[JS] This is just a shot in the dark, but Excel can be rather surprising when
it puts out a CSV file. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what happ
>-Original Message-
>From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
>Sent: Sunday, September 27, 2009 10:19 AM
>Cc: 'mysql'
>Subject: Re: Newbie question: importing cvs settings
>
>Back again... I have 192 records to import, and tried my extra lin
6, 2009 11:02 AM
To: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using
base Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 27 September 2009 15:19
Cc: 'mysql'
Subject: Re: N
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 did
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using CSV method. The LOAD DATA method
did not enter anything.
My earlier assumption about line 17 w
I assume you mean csv not cvs!
What is the error you get when the import fails? What version of MySQL are
you using? Can you post the output of SHOW CREATE TABLE for the table you
are trying to load the file in to and a sample of the csv which is failing
to load?
Do you get the same error if you
in information_schema.tables
e.g.
SELECT AUTO_INCREMENT from information_schema.tables where
WHERE TABLE_NAME = "Products" AND TABLE_SCHEMA = "bs3578";
Viel Gluck,
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerku
Hello Bob,
BobSharp wrote:
Picture does not seem to have been carried in the message, posts with
attachment did not seem to get through either.
So hope the link works.
Below is the ER diagram in an exercise I am trying to do.
http://www.probowluk.co.uk/images/er_ECA_001.jpg
It's been going
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) s
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> H
or as the docs read:
shell> mysqladmin password
John Daisley wrote:
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> FLUS
The root Password will be blank after initial install.
You can set it at a shell prompt with commands something like this...
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> FLUSH PRIVILEGES;
mysql> EXIT;
Where newpwd is your desired password.
Best to
Hi Dave,
that's easy. Either install
http://www.phpmyadmin.net/home_page/index.php on the server, the best
tool to manage a mysql server.
Or use XAMPP, a complete package from
http://www.apachefriends.org/en/index.html
Guenther
Dave Stevens wrote:
> Hello all,
>
> I have set up a little serve
Dave,
Log in as the user you intend to set up for them. Issue the following:
show grants;
select @@sql_mode;
If you aren't sure how to interpret the information I will direct you
to the manual: http://dev.mysql.com/doc/refman/5.0/en/
Side note: I would upgrade. 5.0.45 has some pretty serious
Hi Mário, all !
Mário Gamito wrote (re-ordered):
Sebastian Mendel wrote:
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
Either use reply to all, or manually enter the list email address in the to
field.
There are two general feelings about list operation:
1) all replies should go to the list
2) all replies should default to the sender
This list is configured as #2 (I prefer #1 myself)
Thanks,
David Ruggles
CCNA
I think this change will get you what you want:
SELECT comment_approved, COUNT(comment_agent)
from wp_comments
WHERE comment_agent LIKE '%Linux%' AND comment_approved=0
GROUP by comment_approved
andy
Mário Gamito wrote:
Hi,
I'm trying to get a single number out of a SELECT statement:
SEL
Hi Michael,
I've tried your tip, but I get the error:
"#1054 - Unknown column 'ct_ct_comment_agent' in 'field list'"
Any ideas ?
Warm Regards,
Mário Gamito
Michael Cole wrote:
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(
Hi Sebastian,
Thank you for your answer.
I tried your way, but still, I get a column with two values:
|-
|COUNT(comment_agent)|
||
| 1|
--
| 47|
--
What I need is just the 47.
An
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(ct_ct_comment_agent) from (SELECT comment_approved,
COUNT(comment_agent) as ct_comment_agent from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comme
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comment_approved
But instead i get two rows:
|
On Dec 13, 2007 12:11 PM, Al <[EMAIL PROTECTED]> wrote:
> (Sorry if this is a duplicate post, email issues w/multiple accts)
>
> I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
> knowledge of computer systems, but haven't setup or worked with mySQL
> before. (usually use it p
Hi Sebastian,
That was it alright. I commented out the socket lines from mysql.ini
(restarted it) and changed my php command to:
$mysqli = new mysqli(".", $username,$password, $database);
and all seems to be working fine now.
Thanks again for your help, much appreciated.
Regards,
John
John Comerford schrieb:
> Hi Sebastian,
>
> I did read somewhere that sockets was not valid for windows, and
> '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
> tried the following commands:
>
> $mysqli = new mysqli(".", $username,$password, $database);
> or
> $mysqli =
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(".", $username,$password, $database);
or
$mysqli = new mysqli(".", $username,$password, $
John Comerford schrieb:
> Thanks Sebastian, that did the trick.
> The full command I use is:
> $mysqli = new mysqli(".", $username,$password,
> $database,null,"/tmp/mysql.sock");
there is no need for the socket, their are no sockets on windows
$mysqli = new mysqli('.', $username, $password, $dat
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(".", $username,$password,
$database,null,"/tmp/mysql.sock");
Regards,
JC
Sebastian Mendel wrote:
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable netwo
John Comerford schrieb:
> Hi Folks,
>
> I have a database running on Window XP, that I want to disable network
> connections to and enable 'named pipes'. I am running MySQL 5.0.27
> and my.ini looks like...
>
> [...]
>
> I can connect to the DB using the GUI tools if I set my pipe name to
> '
On 11/24/06, Algomez <[EMAIL PROTECTED]> wrote:
Hello,
I have an application that stores the information in several MySql databases
and I am starting to look at the information and I found a problem.
Information is stored everyday in threed different sessions. Each session
creates a new databas
Adriano -
MySQL names temp tables like that (starting with # sign), in paticular
while storing a result set to be sorted. I would guess that your
query is returning a result set large enough to hit a filesystem limit
on your box. How big are you expecting the results to be? Perhaps
you are mis
Grass Cake wrote:
I'm still unsure about foreign keys..even after reading the doc file and
Paul Dubois 3rd edition
My doubt is...how much constraint is applied.( probably a bad
explanation)
If i have a table 'Customers' with the primary key being 'CustID'
Then i have a table 'LastVisit' wi
Naser, Md Abu wrote:
Hi All,
I am very new. I wish to do some exercise before I go to real business.
Could anyone advise me any tutorial link or resources for beginner?
Some tutorials are listed at
http://www.artfulsoftware.com/dbresources.html. Also you might want to
look at
http://www.a
While this is offtopic, just a side note:
You probably want to store your images on disk with the filename in
the database rather than the actual image binary data in the db.
Filesystems are very good at storing and retreiving chunks of binary.
Databases do it because... well... I'm not really su
At 04:22 PM 7/21/2006 Friday, Scott Haneda wrote:
> I'm going throught some tutorial about uploading and displaying
> images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
Yes, it's cross-posted. I j
> I'm going throught some tutorial about uploading and displaying
> images files. But the display script isn't working. Here's what I have:
I think you may want to bring this to a php based list, not a mysql one.
--
-
Scott Haneda
Rob Desbois schrieb:
I agree that it's often better to point someone in the right direction rather
than just writing the query for them, but in this case it was a newbie question.
And therefore it's most important that he tries to learn how to look at
the doc.
Remembering my own troubles learn
Rob Desbois schrieb:
Sorry but you want me to write the whole SQL query?
He has to use his brain.
Grouping and joining the tables.
I'm not here for doing your or his work!
Barry,
I agree that it's often better to point someone in the right direction rather
than just writing the query for them,
Rob Desbois schrieb:
To those who responded - read the question.
He wants to combine the values from the data column of *2* rows into one, not
just a straightforward string concatenation.
Sorry but you want me to write the whole SQL query?
He has to use his brain.
Grouping and joining the
Hi, the GROUP_CONCAT worked. Thank you. However, I'm getting duplicates in
the "all_data" column. Is there a function like array_unique in PHP to
remove these duplicates?
I tried DISTINCT but that did not work.
Thank you.
--
View this message in context:
http://www.nabble.com/NewbieCREATE
Thank you!
--
View this message in context:
http://www.nabble.com/NewbieCREATE-VIEW-Question-tf1890326.html#a5171108
Sent from the MySQL - General forum at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi,
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
site
z247 schrieb:
Say I have the following tables;
siteID,name
--
site1, XYZ
site2, RSQ
ID,site,data
1, site1, M
2, site2, Q
3, site2, Y
4, site1, P
... etc.
And I want to create a view like this;
siteID,name,data
--
Search the Manual for CONCAT.
SELECT
/Peter
-Original Message-
From: z247 [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 04, 2006 10:02 PM
To: mysql@lists.mysql.com
Subject: Newbie - CREATE VIEW Question
Say I have the following tables;
siteID,name
--
site
David T. Ashley wrote:
Nigel wrote:
mod_php will persist the MySQL connection holding open any lock or
syncronisation token obtained through any of the three methods :
begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
ensure that even in the event of timeouts or fatal e
Nigel wrote:
> mod_php will persist the MySQL connection holding open any lock or
> syncronisation token obtained through any of the three methods :
> begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
> ensure that even in the event of timeouts or fatal errors any shutdown
>
David T. Ashley wrote:
Nigel wrote:
If you can't or won't do this properly by using a transactional table
and begin/commit at least look at using get_lock() based guard
conditions which only lock a string leaving the database accessable.
Whatever you do if you client is php install a shutdo
Nigel wrote:
> If you can't or won't do this properly by using a transactional table
> and begin/commit at least look at using get_lock() based guard
> conditions which only lock a string leaving the database accessable.
> Whatever you do if you client is php install a shutdown handler to clean
>
David T. Ashley wrote:
Hi,
I'm doing a PHP application, and there are just a few instances where I need
to do atomic operations on more than one table at a time and I can't express
what I want to do as a single SQL statement.
What I'm trying to guard against, naturally, is race conditions when
Hey! I figured out this one myself:
On Apr 19, Adam Wolff wrote:
> * Question 2:
> Why does introducing an extra WHERE clause make things slower?
> If I do this:
> SELECT * FROM contacts WHERE fullname LIKE "j%" AND user_id=1
> ORDER BY fullname LIMIT 10;
>
It's because the index needs t
Thanks for the replies. The database is basically read-only at the moment,
so OPTIMIZE TABLE didn't do anything.
When I force the key to be fullname for the second problem, it runs even
worse. It's not practical to create an additional email,fullname index
because in my app I actually have 3! c
On 4/20/06, Adam Wolff <[EMAIL PROTECTED]> wrote:
> How can I optimize the case where I filter on one key but sort on another?
> This is fast:
>SELECT * FROM contacts WHERE fullname LIKE "j%" ORDER BY fullname LIMIT 10;
>
> But this is slow:
>SELECT * FROM contacts WHERE fullname LIKE "j%"
Hi,
2006/4/20, Adam Wolff <[EMAIL PROTECTED]>:
> Hi. I'm new to database optimization and I have a couple of questions.
>
> I have a table like this:
>
> +++-+-+
> | id | fullname | email | user_id |
> +++-
Is there a query that will, say, trim a table down to a million rows (with
some sort order, of course, as I'm interested in deleting the oldest ones)?
If you have got a datecolumn, you might also want to delete anything
that is older than x days (2 in my example):
DELETE FROM database.table W
--- "David T. Ashley" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm a beginning MySQL user ...
>
> I have a table of log entries. Over time, the entries could grow to
> be
> numerous. I'm like to trim them to a reasonable number.
>
> Is there a query that will, say, trim a table down to a millio
At 11:15 PM -0400 4/12/06, David T. Ashley wrote:
Hi,
I'm a beginning MySQL user ...
I have a table of log entries. Over time, the entries could grow to be
numerous. I'm like to trim them to a reasonable number.
Is there a query that will, say, trim a table down to a million rows (with
some
Al Sparks <[EMAIL PROTECTED]> wrote on 13/02/2006 16:11:49:
> Basically, I'm new to mysql (or to any database for that matter).
>
> I have an old version installed on my linux machine. I thought, as a
> learning exercise I'd take 2 files (tab separated tables) load them
> into mysql and then mer
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 11:03 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
So it is clear now, that you should have 16 columns and to build
dynamically the column headings. The usual way to do s
ately, time is running out.
>
> TIA,
>
> Joseph "Tito" Kraer
> Business Systems Analyst
> Taylor, Bean & Whitaker Mortgage Corp
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 0
uot;Tito" Kraer
> Business Systems Analyst
> Taylor, Bean & Whitaker Mortgage Corp
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 06, 2005 6:52 AM
> To: mysql@lists.mysql.com
> Subject: Re: Newbie Question: listin
ss Systems Analyst
Taylor, Bean & Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
> Ple
Hello.
> Please, I don't need comments telling me that I'm missing the semicolon
> or that comments such as "doesn't work" are worthless. I know there's
> something inherently wrong with this query (obviously . . . since it
> doesn't give me the results that I am looking for). Does anyone h
Kraer, Joseph wrote:
I thought that IF
statements would do the job, but I get a syntax error (1064).
Obviously, they are not the way to go. Nevertheless, here's the
complete query so you can get an idea of where I want to go:
Your if statement is wrong.
The syntax is:
if ( condition, va
Hi,
Try with mysql -u root first, the installation process doesn't create a
password.
You can then use mysqladmin -u root password 'newpassword' to set it.
You can find out all about the security/permissions system here :
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Regards
D
Joseph
>update table
>set column5 = number1
>where column 1 = number2
>and column1 = number3
>but it is not working. I tried listing the conditions separated by
>commas (where column 1 = number2, column1 = number3) and also didn't
>work. What am I doing wrong?
No commas in the WHERE clause. WHE
Hello.
I'm not a PHPMyAdmin guru, but at least LOAD DATA LOCAL feature (if it is
present in PHPMyAdmin) can be disabled due to some security reasons. See:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Joe Herman wrote:
> To those thinking of answering this question, T
seph "Tito" Kraer
Business Systems Analyst
Taylor, Bean & Whitaker Mortgage Corp
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 12:13 PM
To: Kraer, Joseph
Cc: mysql@lists.mysql.com
Subject: Re: Newbie Questio
Hi,
In your query you try to update on the condition "column 1 = number2 and
column1 = number3".
I think what you want is " column 1 = number2 or column1 = number3" .
If you use and it will try and found a record in column which has a value =
number2 and at the same time = number3.
hth,
mela
"Kraer, Joseph" <[EMAIL PROTECTED]> wrote on 11/30/2005 11:58:56 AM:
> I am trying to update a couple of rows in a table by doing the
> following:
>
> update table
> set column5 = number1
> where column 1 = number2
> and column1 = number3
>
> but it is not working. I tried listing the condition
I guess that the problem is the reserved word "table"
Try it:
Update `table`
Set column5=number1
where column 1 = number2
and column1 = number3
But the sintax is ok
Regards!
-Mensaje original-
De: Kraer, Joseph [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Noviembre de 2005 1
Kraer, Joseph wrote:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
This appears to be correct syntax.
but it is not working.
We can't help you if you don't tell us what you mean by
Hello.
I'm not PHPMyAdmin guru, but at least LOAD DATA LOCAL feature (if it is
present in PHPMyAdmin) can be disabled due to some security reasons. See:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Joe Herman wrote:
> To those thinking of answering this question, The
Hello.
Start points for you problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
> socket=/home.dbdata/mysql/mysql.sock
What is your client thinks about the location of mysqld socket?
Put the same
>>Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT
This doesn't nesessarily mean that mysql hasn't started. This script waits
only for certain time to check if mysql has started or not. If it is not
started in that time, it simply says 'mysql start failed'. But mysql may
ta
al
sequence in which data is stored.) [NOTE: I mostly use DB2 and clustering is
a big deal there but I'm not sure if it works the same way in MySQL.]
Rhino
- Original Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Jeffrey G. Ubalde" <[EMAIL
> > I would just like to ask a somewhat not so intelligent question. What
> > is the downside of indexing almost all of the fields in a table? Is it
> > advisable?
>
> Indexes have to be built
They also consume disk space, so if you're tight on hard drives, they
might put you over the top.
--
Sco
Jeffrey G. Ubalde wrote:
Good day list!
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built... so if you did that, for every query that
alters the data many index
Christoph Lehmann wrote:
Hi
I have 2 tables, say A and B. One field in table A, say A_link, points
to a field B_link in table B. I need to select entries in A, which
fulfill two conditions: A_cond1 = XX and B_cond2 = YY.
E.g
table Atable B
A_cond1 A_linkB_link B_cond
Hello.
> i'm having a backup of the entire drive, but no dump.
In what way have you done the backup of the drive? Do you
have an archive with files from the corrupted drive or
a raw image (snapshot) of the file system?
If you have an archive you can just copy the data
directory to
2005/9/15, Julien vander Straeten <[EMAIL PROTECTED]>:
> hi all,
>
> my machine crashed and i'd would like to restore my mysql databases
> on my new system.
> i'm having a backup of the entire drive, but no dump.
>
> my system is mac os x.3 server.
> is there a way to drag&drop some folders to my
Nuno Pereira wrote:
To do date change the first line from
printf(" number_format({$thearray[cost]}, 2)
to
printf(" ".number_format({$thearray[cost]}, 2)."
I think you mean:
print( "" . number_format( $thearray['cost'], 2 ) . "" );
As stated by a previous poster to this thread, you should
Bill Whitacre wrote:
I can get this to work just fine:
Comes out $23,999.39
I'd like use the number_format() thingie on an array returned from a
mysql_query.
My current program snippet looks like:
$res = mysql_query("SELECT org, COUNT(*), SUM(annual_cost) AS
cost FROM a05
Bill Whitacre wrote:
printf(" {$thearray[org]}
{$thearray["COUNT(*)"]}
$ {$thearray[cost]} ");
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
Although this is a MySQL mailing list and your problem is not MySQL
related, but a PHP question I'
Jay
There's a short list of SQL & relational tutorials at
http://www.artfulsoftware.com/dbresources.html, and of a few MySQL
resources at http://www.artfulsoftware.com/mysqlinfo.html.
PB
Jay Paulson wrote:
Hi everyone,
Long time reader, first time poster.
I've been using MySQL for
On Tue, 6 Sep 2005 10:58:28 -0500, "John Trammell"
<[EMAIL PROTECTED]> said:
> The DuBois book is a good start: http://www.kitebird.com/mysql-book/
This might be too basic but it's really clear:
http://www.w3schools.com/sql/default.asp
>
> > -Original Message-
> > From: Jay Paulson [m
The DuBois book is a good start: http://www.kitebird.com/mysql-book/
> -Original Message-
> From: Jay Paulson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 06, 2005 10:56 AM
> To: mysql@lists.mysql.com
> Subject: Newbie needs info!
>
> Hi everyone,
>
> Long time reader, first ti
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" erro
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" error. Now, it is
getti
Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in
my.cnf: socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is
removed.
does your system errors when starting mysqld?
He
You need to run the script that creates MySql tables (user, hosts, ...)
mysql_install_db in scripts dir.
Santino
At 15:20 -0400 16-06-2005, Paul Mitchell wrote:
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option
in my.cnf: socket="/tmp/m
On Thu, 16 Jun 2005, Spenser wrote:
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
same old...
/usr/local/mysql/bin/mysqld_safe --user=mysql
--datadir=/usr/local/mysql/tmp &
cat ../
Try it with an absolute file path instead of a relative one. For
instance,
/usr/local/mysql/bin/mysqld_safe --user=mysql --datadir
= /usr/local/mysql/tmp
On Thu, 2005-06-16 at 15:20 -0400, Paul Mitchell wrote:
>
> ./mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp
--
MySQL General Ma
On Tue, 14 Jun 2005, Danny Stolle wrote:
if i start my mysqld it creates a mysql.sock because of an option in my.cnf:
socket="/tmp/mysql.sock"
when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed.
does your system errors when starting mysqld?
Hello Danny,
Thanks for t
1 - 100 of 745 matches
Mail list logo
