: Shahmat Dahlan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 12:42 AM
To: php-db
Subject: [PHP-DB] acquiring value from a sql statement which
contains an
alias
I have a question,
I have this SQL statement,
$sql_stmt = SELECT DISTINCT EXTRACT(YEAR_MONTH FROM visitdate
I have a question,
I have this SQL statement,
$sql_stmt = SELECT DISTINCT EXTRACT(YEAR_MONTH FROM visitdate) AS
availYearMonth FROM visitedurl;;
$result = mysql_query ($sql_stmt);
while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {
echo $row[availYearMonth];
}
By right the value that I