try implementing Query cache, which comes with MySQL v 4.0 n above.
http://www.mysql.com/doc/en/Query_Cache.html
enjoy
Nitin
- Original Message -
From: "Matt Babineau" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 26, 2003 8:28 PM
Subject: [PHP-DB] Need some MySQL
Dell 4200, mem 128g, disk 13g, mhz 800g, Mysql-3.23.54a-linux-i686,
PHP-4.30, httpd_2.0.44 ,Mozilla/50 1.0.1, ZEND IDE 2.6
When running a PHP script (program), Mozilla stops displaying the web page
after using about 5mb of disk space.
Based on the percentage of source processed, I estimate I need
Hi,
I have in my database a total value which looks like
this.
0.0
If the figure is more than 9.9 it goes to 10.0
and so on.. The first 2 digits after the . is cents
and the following is part of a cent.
So it appears in the database for example like 7.51234
.. But I want to display
Hi,
is it possible to create a query with parameters such that it selects a
field if it isn't null?
for example:
SELECT
A.Column1,
A.Column2,
(if not null, B.Column1)
FROM Table1 A, Table2 B
Thanks for your help
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: h
I think that you want to round the number, and yes, you can do it, How?,
well, by example
//Your Number from the DB
$number=10.259;
//Apply the round function to show only two decimals
$new_number=round($number,2);
//The result 10.26
echo $new_number;
Regards
Nilson
El sáb, 27 de 09 de 20
i'm sorry,
i rushed that previous post!!!
what i meant to ask was, if the value of B.Column1 is null then can the
query be written such that we dont select A.Column2.
Sorry!
"Shaun" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> is it possible to create a query with param
I have three tables as shown below:
tbl1
---
user_id
username
password
..
..
tbl2
--
user_id
age (date)
tbl3
---
user_id
town
country
How can i construct sql query for example to select data from all three
tables where age is 30 and count
Hi
You did not mention your DB , but following syntax should get you on your
way
select tbl1.user_id
, tbl1.username
, tbl2.age
, tbl3.town
, tbl3.country
fromtbl1
, tbl2
, tbl3
where tbl1.user_id=tbl2.user_id
and tbl1.user_id=tbl2.user_id
and tbl2
[I apologize if this comes through twice, the first time I sent it did not
appear to go through]
My problem is what I am trying to show the average number of visitors I am
getting on a daily basis over a given month. So for example, I would like
to be able to display the average number of visitor
