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