This is probably something for the php list, however, how is
REGISTER_GLOBALS set on your server? On or off? It is off by default on
newer version of PHP. (has been for a while.)
If it is off you need to grab the vars from post like:
$softwareid = $_POST["softwareid"];
$manufacturer = $_POST["man
dbmail.
http://www.dbmail.org/
I'm using it and so far I'm having really good luck with it.
-- Jason
On Mon, 2003-06-02 at 14:13, David Garamond wrote:
> I'm just wondering if there is an MTA/MDA/IMAPD/Exchange-like app/other
> mail-related daemons that stores mail messages in a relational
t possible?
>
> Steve Nakhla
> [EMAIL PROTECTED]
>
> __
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://platinum.yahoo.com
---
| Jason Bur
It's not all that elegant, but how about this:
Mysql> SELECT date_format(date_add('2002-10-01', interval -1 day), "%d");
Basically, take the first day of the month, subtract one and figure out what
the day number is.
-- Jason
On 11/18/02 9:02 AM, "Andrew Braithwaite" <[EMAIL PROTECTED]> wro
You are searching for the word "dogs"...that word is not contained in
the word 'dog' or the phrase 'dog house.'
If you searched for '%dog%' you would get both of those results.
The wildcard character allows any other character in it's place...hence
'%dog%' finds 'mydog', 'mydogs', etc, etc...it
select date_format(DATEFIELD, "%d-%m") from YOURTABLE;
-- Jason
On Thu, 2002-04-04 at 19:45, saraswathy saras wrote:
> hi,
>
> Can anyone help me.how to query out only day and month from the table.
> The result should be like this:-
> ---
> |05-04|
> ---
> |06-04|
> ---
> |07-04
You need to set the max_connections variable like this in the my.cnf
file:
set-variable = max_connections=250
-- Jason
On Thu, 2001-12-27 at 11:38, Kim Albee wrote:
> We are trying to optimize mySQL. Right now, the max_connections is set to
> 100. We are only able to open 99 concurrent co
David,
I currently run a system with Raid 5. I have had one disk drop, however,
no data was lost. That is one of the beauties of RAID 5, you have a
spare disk that takes over.
I too had heard originally that running MySQL on a RAID 5 was a bad idea
(this, after I already had it running...), howe
Calvin...
The connection is being made from the machine on which php is running.
Most likely the web server. It is not connecting from your browser.
So, these tables are checking the privileges of the connection.
-- Jason
On Wed, 2001-11-28 at 16:14, Wee Chua wrote:
> Hi all,
> I have a que
SELECT DISTINCT Type FROM Products WHERE Type != "System" AND Type !=
"Upgrade"
-- Jason
On Thu, 2001-08-30 at 15:35, Webmaster Odell wrote:
> Hi
>
> I am trying to write a query that pulls all the items from a database except
> two
>
> here is what I am using:
>
> $query = 'SELECT DISTINC
Add this to the top of the script:
set_time_limit(0);
That will set the time out to 0, so it will never time out.
-- Jason
On 8/8/01 3:11 PM, Jason Radley was heard saying:
> I have written a php script to get all the clients
> for a mysql table and send them emails. The
> problem is
Jason.
>
> Another question, where is the my.cnf stored? I don't have this config file
> under my MySQL dir. Do I need to create one or ...?
>
> Thanks,
> Michael
>
>
>> From: Jason Burfield <[EMAIL PROTECTED]>
>> To: Michael Lin <[EMAIL PROTECTED]>
&
You can add : skip-networking : to your my.cnf file. You will only be able
to connect to the database server from localhost then.
-- Jason
On 7/26/01 5:21 PM, Michael Lin was heard saying:
> Hi,
>
> Does anyone know how to disable mysql listening port?
>
> Thanks,
> Michael Lin
>
> __
Quick question about the SHOW TABLE STATUS command and the Data_free info in
particular.
You say: "If it is high, then it's time to run OPTIMIZE TABLE..."
What is considered high? As I'm looking at my output, I see that most of my
tables show a value of 0, however, some have a value around 300 a
alter table TABLENAME add COLUMN_NAME etc, etc...
ie:
alter table members add firstname varchar(50) not null;
If you want to put it after a specific column you can do the following:
alter table members add firstname varchar(50) not null after lastname;
-- Jason
On 7/18/01 10:32 AM, Paul C
You need to specify an initial record and limit number. Try this:
This will give you the first 10 results, starting at record 0 and moving up.
>From this page you can add something like this:
clickable text
//yadda, yadda, yadda...
?>
That link will transfer in the next initial record as n
16 matches
Mail list logo
