Jesús Alain Rodríguez Santos wrote:
I have a query:
$query = mysql_query("SELECT event FROM table WHERE month = 'x' ORDER BY
day ASC");
I have all days of the month insert in day field: 1, 2, 3, 4, 5 ...
when I print the query:
if ($query_r = mysql_fetch_array($query)) {
-----------------^
Right there, you called the first result row, then below....
do {
echo "<td width='8%'>".$query_r['event']."</td>\n";
} while ($query_r = mysql_fetch_array($query));
-------------------------^
You call it again, and since you already called for the first row, this
time it is returning results starting from the second row.
echo "</tr> \n";
} else {
echo "No se encontraron registros";
}
It print all result of the query, less day 1
What it's the problem
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
