With the line:
while (list($link, $title, $content) = mysql_fetch_array($result)) {
The php docs don't actually say what the list() function returns, but since
your getting an infinite loop i would say that it probably evaluates to
true no matter whats on the right hand side of the assignment. I would
suggest that you use:
while ($tmp = mysql_fetch_array($result)) {
list($link, $title, $content) = $tmp;
Cheers,
Owen Prime
http://www.noggin.com.au
Keith Posehn wrote:
> 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
