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 should be getting is "200310" via the Mysql command line client. But with PHP all I got was the value of "1".

Would appreciate if anyone can nudge me in the right directory.

Thanks in advance and would appreciate it.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to