August 12th, 2002, 10:21 PM
|
|
Contributing User
|
|
Join Date: Jun 2002
Posts: 54
Time spent in forums: < 1 sec
Reputation Power: 7
|
|
Hi all,
I understand everything that Harvard says in his article, but I don't understand this part of the code. (I've bolded the part that I don't understand.)
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
When I create PHP scripts, I usually use something like:
PHP Code:
<?php
// Retrieve all authors from the database
$sql = mysql_query("SELECT * FROM AuthorsTemp");
// If the above query has an error, echo the error
if (!$sql) {
errorMsg("Database Error", "<p>Cannot retrieve authors: " .
mysql_error() . "</p>");
exit;
} // End error check on $sql
// While loop for $sql
while($row = mysql_fetch_array($sql)) {
$id = $row["ID"];
$firstname = $row["Firstname"];
$lastname = $row["Lastname"];
$email = $row["Email"];
?>
<tr>
<td align="center"><?php echo($id); ?></td>
<td align="center"><?php echo($firstname); ?></td>
<td align="center"><?php echo($lastname); ?></td>
<td align="center"><a href="mailto:<?php echo($email); ?>"><?php echo($email); ?></a></td>
<td align="center"><a href="deltempauthor.php?id=<?php echo($id); ?>">X</a></td>
</tr>
<?php
}
?>
So basically my question is: why is there the , MYSQL_ASSOC?
Thanks,
__________________
Sincerely,
Corbb O'Connor, Author at DevArticles
Last edited by WebGuy : August 12th, 2002 at 10:30 PM.
|
Dev Articles Community Forums Sponsor:
Article Discussion: Quick and Dirty Emoticons
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
