Ok, here is the question:
I have a sql query, nothing special. It has 3 variables. I have created the
php code to display the variables in context with the html code. I need it
to loop a select number of times, most likely twice, and therefore display
the first two rows of the query.
In other words, querying the database for a set of rows, it needs to display
the first two of the rows on the page.
Here is the code I have tried so far, which has either looped continuosly or
displayed the top row twice (edited for security):
<?php
$sql = "SELECT * FROM [database] ORDER BY [collumn] LIMIT 2";
$result = mysql_query($sql) or die("problem with $sql");
// list($title) = mysql_fetch_array($result);
?>
<td width=48% align=left valign=top>
<h3>What's New?</h3>
<?php
/* It tried this: */ while(list($link, $title, $content) =
mysql_fetch_array($result)){
/* And this: */ while($row = mysql_fetch_array($result) and (($count++)<2)){
// The first kept looping infinitely, the second displayed the top row
twice. Grr... >_<
?>
<h4>
<a href="<?php echo mysql_result($result,0,"link"); ?>"><?php echo
mysql_result($result,0,"title"); ?></a>
</h4>
<p>
<?php echo mysql_result($result,0,"content"); ?>
</p>
<?php
}
?>
</td>
Thanks for any help you can provide.
-Keith Posehn
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
