[PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-31 Thread Jim Lucas
]{1}[0-9]{2}\-[0-9]{4}$ 1 http://us.php.net/manual/en/regexp.reference.repetition.php Jim Lucas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] goto - My comments

2010-12-21 Thread Jim Lucas
On 12/18/2010 9:17 PM, Ethan Rosenberg wrote: Dear List - Thanks to all for your EXCELLENT comments. I definitly agree that goto is a command to be avoided at all costs. In this case, I could not figure out how to acheive the desired result without the goto. So being a newbie, I humbly

[PHP-DB] Re: [PHP] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Jim Lucas
the lang-auth-book. Thanks -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-03 Thread Jim Lucas
to similarly formed SQL calls, I would like to hear their experiences. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: [PHP] Re: the opposite of a join?

2007-10-03 Thread Jim Lucas
Robert Cummings wrote: On Wed, 2007-10-03 at 14:49 -0700, Jim Lucas wrote: This is only from my own personal testing. Mind you that I have only been using PostgreSQL for a year or so. But one problem that I have always ran into with MySQL is that when JOIN'ing tables that have large data

Re: [PHP-DB] any php/Linux gurus out there?

2002-03-05 Thread Jim Lucas [php]
the deps also. it will be worth it in the long run. Jim Lucas - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 04, 2002 8:18 PM Subject: Re: [PHP-DB] any php/Linux gurus out there? On Tuesday 05 March 2002 07:52, Peter Lovatt wrote: Hi

Re: [PHP-DB] easy date format question

2002-03-01 Thread Jim Lucas [php]
$today = date(Ymd); $sql = INSERT into table (date) values ('$today'); when the $today variable is inserted into a mysql date column it will fit just right. but, if you want to insert it into a timestamp column, you will have to padd it with 6 zero's Jim Lucas www.bend.com - Original

Re: [PHP-DB] Passing form values with quotes, to itself

2002-02-14 Thread Jim Lucas [php]
it is called magic quotes and it can be enabled through the php.ini file. Jim Lucas - Original Message - From: William Fong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 10:36 AM Subject: Re: [PHP-DB] Passing form values with quotes, to itself Doesn't PHP

Re: [PHP-DB] A while loop prob ?

2002-02-14 Thread Jim Lucas [php]
string. then echo/print the $display_srch_rows variable. Jim Lucas - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: php List [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 11:40 AM Subject: [PHP-DB] A while loop prob ? Hi All What have I done wrong here. 3 yes 3

Re: [PHP-DB] Passing form values with quotes, to itself

2002-02-13 Thread Jim Lucas [php]
Try this. input type=text name=Body value=?=htmlspecialchars($Body)? That should to the job. Jim Lucas - Original Message - From: Faye Keesic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 10:02 AM Subject: [PHP-DB] Passing form values with quotes, to itself

Re: [PHP-DB] Passing form values with quotes, to itself

2002-02-13 Thread Jim Lucas [php]
it will still cut off with the double quots. if you have a double quote inside of a double quoted value property ? $myvalue = And he asked, \what have you done, son\? ; ? input type=text name=something value=?=addslashes($myvalue)? This will still break. it does care if they are escaped. Jim

Re: [PHP-DB] Select rows where ?

2002-02-12 Thread Jim Lucas [php]
select * from table where columnsomething select * from table where column NOT LIKE %something% Jim Lucas - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: php List [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 10:39 AM Subject: [PHP-DB] Select rows where ? Hi All

Re: [PHP-DB] # of Records in Table

2002-01-23 Thread Jim Lucas [php]
does the table have an autoincrement column? Jim Lucas - Original Message - From: Zach Curtis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 23, 2002 10:27 AM Subject: [PHP-DB] # of Records in Table What syntax can I use to determine how many records are in a MySQL

Re: [PHP-DB] Passing parameter in Paging

2001-12-28 Thread Jim Lucas [php]
better yet, have a starting page multiplied by the page length define a constant that gives the page limit then have the receiving page do some math and do a mysql_data_seek() or array_seek() (which ever you are using) and then limit the returns by the page limit size? wouldn't that be the

Re: [PHP-DB] Mysql result resource error

2001-12-20 Thread Jim Lucas
which one was giving you the problem? the first or second mysql try. if it was the second, try wrapping the $cattyname with single quotes like this Minor_Category = '$cattyname'. if the $cattyname var has anything but numbers, the statement won't work. Jim - Original Message - From:

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jim Lucas
Try this input type=checkbox name=firstvalue ?=($result[32]?checked:)? Jim - Original Message - From: SpyProductions Support Team [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 8:40 AM Subject: [PHP-DB] Checkboxes, PHP, and MySQL I've looked around in a

Re: [PHP-DB] Learning PHP Sessions

2001-10-31 Thread Jim Lucas
one problem I see, you are trying to populate the variable after you register it. session_start(); $myvar = something; session_register('myvar'); echo $myvar; Jim Lucas - Original Message - From: Russ Michell [EMAIL PROTECTED] To: Steve Cayford [EMAIL PROTECTED] Cc: Matthew Tedder

Re: [PHP-DB] New users on mysql using php

2001-10-25 Thread Jim Lucas
go grab yourself a copy of phpmyadmin http://phpmyadmin.sourceforge.net/download.html jim - Original Message - From: Harpreet [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 2:02 PM Subject: [PHP-DB] New users on mysql using php I connect to mysql database

Re: [PHP-DB] array-problems

2001-10-24 Thread Jim Lucas
- Original Message - From: Jim Lucas [EMAIL PROTECTED] To: Bart Verbeek [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 24, 2001 12:42 PM Subject: Re: [PHP-DB] array-problems Try this: BEGIN:PHP-CODE $result = mysql_query (SELECT DISTINCT date FROM linktracker