In reference to Jeffrey's comment about the performance of
mysql_fetch_row vs mysql_fetch_array, which I always have used the
_array implementation:
From the horses mouth:
Performance: An important thing to note is that using
mysql_fetch_array() is not significantly slower than using
mysql_f
of course
strlen($var)
bastien
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: PHP DB
Subject: [PHP-DB] Length of variable
Date: Fri, 20 Jan 2006 20:48:21 -0500
Is there a way I may find out how many characters
$variable
is long after it has been submitte
Is there a way I may find out how many characters
$variable
is long after it has been submitted through a web form?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Sorry, I was in a rush to work guys.
All these were downloaded pre-compliled for Win32.
Apache 2.0.55
PHP 5.1.1 w/php_mysqli.dll (improved mysql)
MySQL 5.0.18
This script:
turns into this:
no error
And this script:
turns to this:
In summary again, It seems to want to connect to
Thanks Balazs and David.. I think that's exactly what I was looking for. I
searched for hours (and I consider myself a fairly decent researcher) and was
just getting frustrated..hah.. I think my problem was I was searching for
"money" and "float problems" and such and not "monetary". I think
Convert both to unix timestamps...be much easier to wrok with both date and
time then
bastien
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: PHP DB
Subject: [PHP-DB] SELECT
Date: Fri, 20 Jan 2006 06:00:33 -0500
Yesterday I asked how to get the date & time 90 m
To solve compability problem with mysql library, try to save your mysql user
password with OLD_PASSWORD('some pass') function, not the ordinary
PASSWORD('some pass') function.
With this you can connect to MySQL 4.1 > 5 even with php 4
Ron Piggott (PHP wrote:
> Yesterday I asked how to get the date & time 90 minutes ago and I
> received several responses. Thanks.
>
> I don't think this select statement is working "correctly". (Correctly
> being what I am intending it to do)
>
> I took a look at the table this morning. One r
-Original Message-
From: Lonny [mailto:[EMAIL PROTECTED]
Sent: Friday, January 20, 2006 3:46 AM
To: php-db@lists.php.net
Subject: [PHP-DB] new guy with stupid question
Hello,
I am new to the list.
I thought I would call my question stupid just to raise some eyebrows to
those who might
Possibility?
WHERE (`date_created` = '$date_90_minutes_ago' AND
`time_created` <= '$time_90_minutes_ago') or
(`date_created` < '$date_90_minutes_ago' AND
`time_created` > '01:30:00')
Ade
Ron Piggott (PHP) wrote:
Yesterday I asked how to get the date & time 90 minutes ago and I
received se
Yesterday I asked how to get the date & time 90 minutes ago and I
received several responses. Thanks.
I don't think this select statement is working "correctly". (Correctly
being what I am intending it to do)
I took a look at the table this morning. One record remains that was
created 2006-01-
Using the select calc_found rows code (i.e select sql_calc_found_rows *
from table where ... limit 0, 10) to get the found fesult irrespective of
the limit clause...then using $count = mysql_query("select found_rows()");
with the hope of getting the returened result but got this instead: Resource
i
Hi,
Aaron helped me to understand the question so here's an add-in to his comment.
from the MySQL manual:
MySQL version through 4.1 accept certain "illegal" values for dates,
such as '1999-11-31'. This is useful when you want to store a possibly
incorrect value specified by a user (for exampl
Lonny wrote:
OK, sorry for the long winded info.
For today I will ask for a script that will gather emails from the email
field of a table in a database and send a news letter to those emails.
How do I compose the email formatted with html for a professional look and
send it to everyone in the d
Hi,
Here's what I found googling around (with these keywords: html email php):
http://www.sitepoint.com/article/advanced-email-php
didn't read it through, but looks good imho (and there's more).
And my apologies but I really don't understand your second question. :)
Balazs
--
PHP Database Mail
$date = $month."-".$day."-".$year;
$query = "INSERT INTO sometable (date) VALUES ('$date');";
Hope this works for you,
Aaron
On 1/20/06, Lonny <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
> I am new to the list.
> I thought I would call my question stupid just to raise some eyebrows to
> those who mig
Hello,
I am new to the list.
I thought I would call my question stupid just to raise some eyebrows to
those who might like to flame me for not reading some basic php/mysql books.
Fact is - I have -
I have been working with some scripts where I can change them and expand on
them to suit my needs.
I
17 matches
Mail list logo