TheSky Posted April 7, 2011 Share Posted April 7, 2011 <?php include("config.php"); $sql=mysql_query("SELECT * FROM uudised ORDER BY id DESC LIMIT 0,5") or die(mysql_error()); $x=0; while($row=mysql_fetch_array($sql)) { echo ($x+1).') '.$row['uudis'].'<br />'; $x++; } ?> Hey how should i get more data from uudised i want get date_added also but how i should do Link to comment https://forums.phpfreaks.com/topic/233002-how-to-get-more-values-from-database/ Share on other sites More sharing options...
Maq Posted April 7, 2011 Share Posted April 7, 2011 If date_added resides in the uudised table then you would display it the same way as uudis. Link to comment https://forums.phpfreaks.com/topic/233002-how-to-get-more-values-from-database/#findComment-1198335 Share on other sites More sharing options...
TheSky Posted April 7, 2011 Author Share Posted April 7, 2011 oh i did use echo $row['date_added'].($x+1).') '.$row['uudis'].'<br />'; and it did work Link to comment https://forums.phpfreaks.com/topic/233002-how-to-get-more-values-from-database/#findComment-1198340 Share on other sites More sharing options...
Maq Posted April 7, 2011 Share Posted April 7, 2011 oh i did use echo $row['date_added'].($x+1).') '.$row['uudis'].' '; and it did work Right since you selected *, which is every column in that table, then you can retrieve anything from the result set, which was set to $row, in that format. Link to comment https://forums.phpfreaks.com/topic/233002-how-to-get-more-values-from-database/#findComment-1198342 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.