You have a pretty good handle on what's happening there, I hope I can add some clarity.
The Resource Id you're trying to echo is a pointer to a MySQL result set, you aren't actually working with the data yet. That's where the mysql_fetch functions come in. The mysql_fetch_assoc function fetches the next line of the result set and stores it in an associative array, so that you can reference your results by their database field name, i.e. $row_RS_CourseEnrollment['Id_field']. Otherwise, using a similar function like mysql_fetch_row, you'd end up with $row_RS_CourseEnrollment[0] for the first field, [1] for the second, and so on. If you ever change your database and you're using select *, this can get messy. Additionally, the mysql_fetch functions are simply returning a portion of the result of your previously executed query, so the database isn't re-queried every time you loop through it. Hope this helps! On Fri, 10 Sep 2004 16:12:06 -0500, Robb Kerr <[EMAIL PROTECTED]> wrote: > Here are my questions... > 1) Do I understand what's going on? > 2) When I ECHO the variable created in Line 4 of the connection I get > "Resource id #4". Why don't I get "Array" or something I can read? > 3) Because the last line of the repeat region includes > "mysql_fetch_assoc($variableDefiningTheQuery)" does this mean that the > database is queried every time through the loop? > 4) I can't find "mysql_fetch_assoc()" in the MySQL documentation. What's > this command do? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
