Re: [PHP-DB] new guy with stupid question

2006-01-20 Thread Julien Bonastre
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

RE: [PHP-DB] Length of variable

2006-01-20 Thread Bastien Koert
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

[PHP-DB] Length of variable

2006-01-20 Thread Ron Piggott (PHP)
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

Re: [PHP-DB] Getting PHP 5 w/mysqli to communicate with MySQL 5

2006-01-20 Thread Allen Schultz
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

Re: [PHP-DB] Storing money values in MySQL

2006-01-20 Thread tg-php
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

RE: [PHP-DB] SELECT

2006-01-20 Thread Bastien Koert
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

Re: [PHP-DB] Getting PHP 5 w/mysqli to communicate with MySQL 5

2006-01-20 Thread Arie Nugraha
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

[PHP-DB] Re: SELECT

2006-01-20 Thread David Robley
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

RE: [PHP-DB] new guy with stupid question

2006-01-20 Thread Lonny
-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

Re: [PHP-DB] SELECT

2006-01-20 Thread Adrian Bruce
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

[PHP-DB] SELECT

2006-01-20 Thread Ron Piggott (PHP)
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-

[PHP-DB] Select found_rows problem...

2006-01-20 Thread Yemi Obembe
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

Re: [PHP-DB] new guy with stupid question

2006-01-20 Thread Balazs Hegedus
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

Re: [PHP-DB] new guy with stupid question

2006-01-20 Thread Jeffrey
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

Re: [PHP-DB] new guy with stupid question

2006-01-20 Thread Balazs Hegedus
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

Re: [PHP-DB] new guy with stupid question

2006-01-20 Thread Aaron Koning
$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

[PHP-DB] new guy with stupid question

2006-01-20 Thread Lonny
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