Re: [PHP-DB] MySql and PHP question

2005-04-07 Thread Bastien Koert
subselects are available as of 4.1 bastien From: graeme <[EMAIL PROTECTED]> To: "Juffermans, Jos" <[EMAIL PROTECTED]> CC: "'php-db@lists.php.net'" Subject: Re: [PHP-DB] MySql and PHP question Date: Thu, 07 Apr 2005 12:55:13 +0600 From memory earlier versions of MySQL don't support subselects. The

[PHP-DB] Problem with foreach looping...

2005-04-07 Thread NIPP, SCOTT V \(SBCSI\)
I am attempting to use a simple foreach loop on a query result, and I am only getting the first element of the array back. Here is the code... $exclude_query = "SELECT hostname FROM exclusion"; $exclude_results = mysql_query($exclude_query, $Prod); $exclude = mysql_fetch_array($exclude_re

RE: [PHP-DB] Problem with foreach looping...

2005-04-07 Thread Mike Johnson
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] > I am attempting to use a simple foreach loop on a query result, > and I am only getting the first element of the array back. > Here is the > code... > > $exclude_query = "SELECT hostname FROM exclusion"; > $exclude_results = mysql_q

RE: [PHP-DB] Problem with foreach looping...

2005-04-07 Thread Wendell Frohwein
Try this $exclude_query = "SELECT hostname FROM exclusion"; $exclude_results = mysql_query($exclude_query, $Prod); while ($exclude = mysql_fetch_array($exclude_results)) { echo $exclude["hostname"]."\n"; } -Wendell -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTEC

RE: [PHP-DB] Re: Just can't get it to work.. variables

2005-04-07 Thread Gavin Amm
Yeah, you did explain it clearly, I just couldn't get the casting to work in PHP.. I found 2 or 3 ways of doing it in PHP, but I just couldn't get any of them to work.. I even looked at casting in MySQL, though I couldn't find an int cast. At any rate, it's working fine based on my previous e-mai

[PHP-DB] Question about clients

2005-04-07 Thread karl james
Team, How do most of you get your clients, are their any other tricks besides word of mouth. I really want to become a freelance web designer, or work for a provider of clients. Also/or for a major coporation that. Does anybody have any suggestions on how I can start getting paid for what I know