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

[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

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

2001-12-04 Thread Tim Foster
]] Sent: Monday, December 03, 2001 3:27 PM To: [EMAIL PROTECTED] Subject: TO TIM FOSTER - REGARDING THE ALTERNATING ROWS PULLED FROM TABLES Hi Tim. I'm a programerr in PHP4 for about years now and just by looking at your script i can tell it wont work ! First of all, if would be dificult

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);

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

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

2001-11-28 Thread Tim Foster
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 prerequisite for this method, is that you have an auto_incremented

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

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

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

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