|
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
Navigation:
[Reply to this message]
|