Can you post a piece if code here, of how you make and fetch query, and how you ouput it.
–
devdRewJan 6 '12 at 11:56

First of all try this to fix first one. And please, describe more about second problem.
–
devdRewJan 6 '12 at 12:04

After $row_Recordset1 = $q->fetchAll(PDO::FETCH_ASSOC); just do <?php foreach ($row_Recordset1 as $row): ?> here your html and then <?php endforeach; ?>, I think the problem is about fetching few times...
–
devdRewJan 6 '12 at 12:10

Look for the last code listing in my answer. This should work. After $rows = $q->fetchAll(PDO::FETCH_ASSOC); You have array of all records retrived by query. Then you need just to do simple foreach ($rows as $row) {}
–
devdRewJan 6 '12 at 12:20

So I assign my sql a varible and then put this in place of the old query?
–
MarkJan 6 '12 at 8:15

Look at the second code listing, you pass query with ? in the place of you variables, and as the second arg give array of values to replace ? in your query. Then execute, and if it's all ok - fetch.
–
devdRewJan 6 '12 at 8:19

Ok so I think I'm getting the hang of this but now I get this error
–
MarkJan 6 '12 at 9:56

I don't see any of that in my example, what's for you need ::exec() method? $q = $pdo->prepare('SQL with ? ? ? as places for vars'); if ($q->execute(array($v1, $v2, $v3))) return $q->fetchAll();
–
devdRewJan 6 '12 at 10:24