On Fri, 10 Sep 2004 17:49:21 -0700, Andrew Kreps wrote: > 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? >>
Thanx Andrew. I thought that's what was going on. I was just concerned because I didn't know exactly what mysql_fetch_assoc() was doing. I was afraid that the database was being queried every time through the repeat region loop. I found it hard to believe that DW would code so inefficiently, but then again, it might. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams ---------------------------------------------------- http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
