axm

Hello, would help if we knew what problem that outputted

Right figured out how to do it! Here is the code: <?php include('includes/connect.php'); $yourQuery = mysql_query("SELECT * FROM testimonials", $constr); $halfWay = ceil(mysql_num_rows($yourQuery) / 2); $x = 0; while ($record = mysql_fetch_array($yourQuery)) { if ($x < $halfWay) { $col1[] = $record; } else { $col2[] = $record; } $x++; } ?> <div id="testimonials_left"> <?php print '<ul>'; foreach ($col1 as $data) { print '<li><a title="AAR ' . $data['id'] . ' testimonial" href="read_testimonial.php?id=' . $data['id'] . '">' .$data['title']. '</a></li>'; } print '</ul>'; ?> </div> <div id="testimonials_right"> <?php print '<ul>'; foreach ($col2 as $data) { print '<li><a title="AAR ' . $data['id'] . ' testimonial" href="read_testimonial.php?id=' . $data['id'] . '">' .$data['title']. '</a></li>'; } print '</ul>'; ?> </div>

Right... it's all working okay except i forgot to mention that the data in the <li>'s are links... here is the code I have done (you can easily see that I have used && to demonstrate what I wish to do haha!). <div id="testimonials_left"> <?php print '<ul>'; foreach ($col1 as $data && $col1ID as $id) { print '<li><a title="AAR ' . $id . ' testimonial" href="read_testimonial.php?id=' . $id . '">' .$data. '</a></li>'; } print '</ul>'; ?> </div> <div id="testimonials_right"> <?php print '<ul>'; foreach ($col2 as $data && $col2ID as $id) { print '<li><a title="AAR ' . $id . ' testimonial" href="read_testimonial.php?id=' . $id . '">' .$data. '</a></li>'; } print '</ul>'; ?> </div>

Many thanks MrAdam! I shall try this and let you know how I get on. $20 donation coming PHPFreaks' way :]

Oh I think I'm beginning to understand! I don't believe it matters really in what order they go however, I would prefer them to go record 1 record 3 record 2 record 4 Cheers MrAdam! :]

Sorry for my poor explanation! I have a set of records i.e. ID title text ID title text ID title text ID title text etc... I want to total these and split the total in half so they display in two columns :] Hope that's better! Thanks.

Cheers MrAdam! Though I don't understand how it counts the number of fields then divides them in two? Do you mind briefly explaining the code? Many thanks :]

Hey all, bear with me whilst i try to explain this! I have two <ul> lists that are to be populated with data from a MySQL database. The <ul>'s sit side-by-side. I wish to create a script that will build these so that they are both equal (or one has 1 fewer if the total is an odd number). So I was thinking of using a COUNT to count the total of entries in the table. Dividing that value in half and building the two <ul>'s. However, I'm not sure how to do it! Many thanks in advance :]