New Problem with Arrays won't show the first record of a query.
| From: | Elliot J. Balanza | Date: | Fri, 12 Mar 2004 22:30:09 +0000 |
| Subject: | New Problem with Arrays won't show the first record of a query. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-180297@lists.php.net to get a copy of this message | ||
Ok thanks to Michael Nolan I was able to do what I needed. The final code is
this:
<snip-snip>
mysql_select_db($database_MBTTIENDA, $MBTTIENDA);
$query_prefs = "SELECT * FROM mtmbt_prefs ORDER BY Pref_name ASC";
$prefs = mysql_query($query_prefs, $MBTTIENDA) or die(mysql_error());
$row_prefs = mysql_fetch_assoc($prefs);
$totalRows_prefs = mysql_num_rows($prefs);
while ($row_prefs = mysql_fetch_assoc($prefs)) {
$MTMBT[$row_prefs['Pref_name']] = $row_prefs['Pref_value'];
}
mysql_free_result($prefs);
<snip-snip>
and it works fine EXCEPT it wont show the first record of the query... any
ideas why?
Vamp