[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

2001-10-25 Thread Tim Foster
RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...Agreed. Personally, I refuse to keep date values in fields that are not DATE fields of some kind. Too much trouble. TIM -How do "Do Not Walk On Grass" signs get there? -Original Message- From: Robinson, Mike [mailto:[EMAIL PROTECTED]

[PHP-DB] RE: what's a GOOD starting HOURLY rate for a PHP/MYSQL job?

2001-11-09 Thread Tim Foster
>I'd also be interested in what people are charging as I'm thinking of >setting up as a contractor myself and it would be nice to have a 'ball park' >figure of what the going rate is ... > >Pls mail replies to [EMAIL PROTECTED] Feel free to post your responses to the list. I'm curious about it to

RE: [PHP-DB] RE: what's a GOOD starting HOURLY rate for a PHP/MYSQL job?

2001-11-09 Thread Tim Foster
> -Original Message- > From: Kodrik [mailto:[EMAIL PROTECTED]] > The problem is that you have to be able to differentiate yourself from those > fakes, and it can be difficult. They usually have flashy sites that move and > make sound linked some database capability with access (like to ca

RE: [PHP-DB] help me on projecting some tables

2001-11-16 Thread Tim Foster
A couple of questions: > INSERT INTO traits VALUES("Added Chemicals",LAST_INSERT_ID(),"Sugar"); 1. Will LAST_INSERT_ID() work reliably in a multi-user environment? What happens if you're in the middle of inserting a dozen records and someone else inserts a record? Does MySQL keep the LAST_INS

[PHP-DB] RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...

2001-10-25 Thread Tim Foster
> From: Chris Newbill [mailto:[EMAIL PROTECTED]] > >snip... (been doing VBScript on ASP for several years, tho). > > I feel sorry for you. :) ;) Never fear. It works, does what it needs to do (so long as it's properly patched ;) and I make a fist-full of money for moon-lighting. Can't complain

RE: [PHP-DB] PHP and MySQL queries...

2001-10-25 Thread Tim Foster
I'm new to this list, to PHP and to MySQL (been doing VBScript on ASP for several years, tho). I'm curious... If you're going to store it as an integer, why not store "10/24/2001" as MMDD (20011024). This gives you the added benefit of being able to have the db sort your fields. This even w

RE: [PHP-DB] inserting mysql data using php array???

2001-11-28 Thread Tim Foster
Very interesting. I didn't know you could use SET with an INSERT. I tried this on MySQL and it worked. Dunno if it's standard SQL, but it didn't work on MSAccess and MS SQLServer (the only other DBs I have at hand to test it with). I wonder what other DBs it works on, because you could be painti

RE: [PHP-DB] inserting mysql data using php array???

2001-11-28 Thread Tim Foster
ge- > From: Ubaidul Khan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 28, 2001 10:04 AM > To: Tim Foster > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] inserting mysql data using php array??? > > > Actually, there is another way of doing it. The prer

RE: [PHP-DB] Re: Alternating rows pulled from database

2001-11-30 Thread Tim Foster
I'm new to PHP, so I don't know if there are any substantive advantages in execution time to any particular method, but here's what I do (granted, I've never tried it in PHP, but I do it all the time in VBScript). $cols = array("#FF", "#EEFFEE"); for ($i=1; $i<=count(mysql_num_rows($return);

[PHP-DB] RE: TO TIM FOSTER - REGARDING THE ALTERNATING ROWS PULLED FROM TABLES

2001-12-04 Thread Tim Foster
e doing). TIM -Depression is merely anger without enthusiasm. > -Original Message- > From: Vins [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 3:27 PM > To: [EMAIL PROTECTED] > Subject: TO TIM FOSTER - REGARDING THE ALTERNATING ROWS PULLED FROM > TABLES >

[PHP-DB] RE: Multiple select list box to search mysql database

2002-01-02 Thread Tim Foster
I've done stuff like this in VBScript and haven't yet done it in PHP, so this advice may be worth what you're paying for it: 1. Make sure you've got a space in your sql string. $query .= "WHERE MANUFACTURER LIKE '$manufacturername' should be $query .= " WHERE MANUFACTURER LIKE '$

RE: [PHP-DB] Concept help required

2002-01-09 Thread Tim Foster
You wouldn't happen to have a spare ELH diagram (or two) lying around that one could take a look at, would you? Thanks. TIM -When you save for a long time to buy something, then you find that you can't afford it --- that's inflation. > -Original Message- > From: DL Neil [mailto:[EMAIL