getting db info problem

[skbanta]

I have my php and I know it's getting to the table, but I need to select it and have it appear in a table in reverse chronological order (newest first) with a date and timestamp at the top (very unsure how I'd code the last part). Here's the code I have:

<?php
		  $con=mysql_connect("***","***","***")
		  if($con)
		  {
		  die('Problem connecting to the database:'.mysyql_error());
		  }
		  mysql_select_db("kylban5_banta",$con);
		  $result=mysql_query("SELECT entry FROM politics");
echo "<table border='1'>
		  while($row=mysql_fetch_array($result));
		  {
                                        echo "<tr>"; 
		  echo "<td>".$row['entry']."</td>";
		  echo "</tr>
		  }
echo "</table>";
		  mysql_close($con);
		  ?>

 

I would also like to be able to delete data after a certain amount of time or so, but I can worry about that later.

[lilbadger25]

I may be misreading what you're asking, but if you're wanting to display your results in reverse order, you'd do this:

 

SELECT entry FROM politics ORDER BY id DESC

 

You'd change the "id" to whatever it is you are basing your order on. Desc is descending.

 

Hope that was what you were asking...

[skbanta]

Thanks, that was one of my problems, but I can't get the data to show up in my page at all much less in a table.  It shows up blank where I have that code. Since I am using dreamweaver Templates does it have to be a php template or can I use an html template and just put the php code into the html?

[kts]

mysql_select_db("kylban5_banta",$con) or die(mysql_error());

 

make sure its connecting, if so do      or die(mysql_error());

after the query as well.... make sure its working

[rlindauer]

Did you copy/paste that code exactly? You have some syntax errors:

 

<?php
		  $con=mysql_connect("***","***","***")
		  if($con)
		  {
		  die('Problem connecting to the database:'.mysyql_error());
		  }
		  mysql_select_db("kylban5_banta",$con);
		  $result=mysql_query("SELECT entry FROM politics");
echo "<table border='1'>
		  while($row=mysql_fetch_array($result));
		  {
                                        echo "<tr>"; 
		  echo "<td>".$row['entry']."</td>";
		  echo "</tr>
		  }
echo "</table>";
		  mysql_close($con);
		  ?>

 

You aren't closing your echo statement. And you have a semi-colon after while...

 

<?php
echo "<table border='1'>";
		  while($row=mysql_fetch_array($result))
?>

[skbanta]

I changed those and now this "; echo " } echo "

"; mysql_close($con); ?> shows up in my browser when I open it

[rlindauer]

There are more syntax errors. Are you using a decent editor? It will highlight your code and you can see the problem. You are missing a closing quote and semi-colon after an echo

 

<?php
		  echo "<td>".$row['entry']."</td>";
		  echo "</tr>";
		  }
?>

[skbanta]

im using dreamweaver, i couldn't even select anything from my db without tables

[skbanta]

any ideas?

[skbanta]

is this bad code?

<?php
		  $con=mysql_connect("*********")
		  if($con)
		  {
		  die('Problem connecting to the database:'.mysyql_error());
		  }
		  mysql_select_db("kylban5_banta",$con);
		  $result=mysql_query("SELECT entry FROM politics ORDER BY id DESC");
		  $num=mysql_numrows($result);
		  mysql_close();
		  $1=0;
		  while($i<$num)
		  {
		  $entry=mysql_result($result,$i,"entry");
		  }?>
		  <table>
		  <tr>
		  <td><? echo $entry; ?></td>
		  </tr>
		  </table>
		  <? 
		  $i++;
		  }
		  echo "</table>";
		  ?>