[Resolved] Looping HELP

[cheyner11]

Can anyone help me find the problem with this loop. I have tried everything that my little knowledge will allow. The database is working as I can extract one row. But this loop now shows nothing.

PLease HELP.

if($tsx)

mysql_select_db('johnt_core');

$queries = "SELECT date,url,title FROM news WHERE symbol='$tsx' ORDER BY date DESC LIMIT 5";

$desult = mysql_query($queries)
or die ("Could not execute query");

while ($now = mysql_fetch_array($desult));

{

?>

<table border='0' width='400'>
<tr><td width='100' height='20'><font face='arial' size='1'><?php $now["date"]; ?></td>
<td width='300' height='20' align='center'><a href='<?php $now["url"]; ?>' target='_blank'><?php $now["title"]; ?></a></font></td>
</tr></table>

<?php } ?>

[mmilano]

with that loop, you should be using:

mysql_fetch_row not mysql_fetch_array

<?
 $queries = "SELECT date,url,title FROM news WHERE symbol='$tsx' ORDER BY date DESC LIMIT 5";

$desult = mysql_query($queries)
or die ("Could not execute query");

while ($now = mysql_fetch_row($desult));

{

?>

<table border='0' width='400'>
<tr><td width='100' height='20'><font face='arial' size='1'><?php $now["date"]; ?></td>
<td width='300' height='20' align='center'><a href='<?php $now["url"]; ?>' target='_blank'><?php $now["title"]; ?></a></font></td>
</tr></table>

<?php } ?>

[cheyner11]

I have included "echo" and included mysql_fetch_row, and still nothing.

Any other suggestions?

Thanks again.

[mmilano]

if this doesn't work, then your query is bad 😉

<?
$queries = "SELECT date,url,title FROM news WHERE symbol='$tsx' ORDER BY date DESC LIMIT 5";
$desult = mysql_query($queries)

$num = mysql_numrows($qesult);

for($i=0;$i<$num;$i++)
{
   $date = mysql_result($desult,$i,"date");
   $url = mysql_result($desult,$i,"url");
   $title = mysql_result($desult,$i,"title");

  echo "<table border='0' width='400'>
  <tr>
    <td width='100' height='20'><font face='arial' size='1'>$date</td>
    <td width='300' height='20' align='center'><a href='$url' target='_blank'>$title</a></font></td>
  </tr>
  </table> \n";
} 
?> 

let me know.

[cheyner11]

Thanks for your help. It worked perfectly.