[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.

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 might like to

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

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

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. ?php if ($_SERVER['REQUEST_METHOD'] === 'GET') {//'GET' !== 'get' //display form (using POST method) } elseif ($_SERVER['REQUEST_METHOD'] === 'POST' isset($_POST['_non-optional_fields_'])

[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 id

[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-19

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

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

[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 record

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

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 php-db@lists.php.net Subject: [PHP-DB] SELECT Date: Fri, 20 Jan 2006 06:00:33 -0500 Yesterday I asked how to get the

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] 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: htmlhead/headbody ?php $link = mysqli_connect('localhost','root','xx'); if (mysqli_connect_errno()) { echo error;

[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] 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 php-db@lists.php.net 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

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