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 Quote 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. Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.