Posted by Sarah on 10/28/07 21:05

Man do I feel stupid. In messing around earlier with the mySQL table
I inadvertently deleted my primary key column and made my friendid
column my primary key. This inadvertently limited my entries to one
per friendid instead of all of the data. I can't believe what a dumb
mistake that was. I swear I am usually more careful!

Once I added back in the column and got the primary key straightened
out I then was missing about 5 entries and wasn't quite sure why since
the loops were working. In reviewing your responses and looking back
over the data it looks to be because I had not been using
mysql_real_escape_string. As soon as I used that my last 5 missing
entries were able to be inserted with no problem.

I will also fix my code to add in (I appreciate the best practices
tip!):
mysql_free_result($resultBlogsMarket) after the end of the outer
loop.
mysql_free_result($resultBlogs) before the end of the inner loop.


Thank you so much for your help and patience with me. I really
appreciate it!!


Sarah

[Back to original message]