Re: Generating HTML table from MySQL table based on some criteria

Sudheer, Post the code you are using and we'll better be able to point you in the right direction to get your code working. Wolf ---- Sudheer Satyanarayana <sudheer.s@binaryvibes.co.in> wrote: > Hello, > > I have a MySQL table with four columns - userid, created_date, username > and path_to_picture. path_to_picture column contains the path to the > image files of those users who have uploaded pictures. An example path > stored in path_to_picture column is picture/username.png. There are > some users that don't have their pictures uploaded. The column contains > nothing for these usernames. > > I want to generate an HTML table with 20 recent users who have uploaded > their pictures. Each row in the HTML table should contain 5 columns. > Thus the HTML table would contain 4 rows. > > How can I accomplish this? > > I hope I have provided enough information to describe my problem. I > would be glad to provide more details if required. > > I tried few permutations and combinations with ORDER BY and LIMIT > clauses to no avail. I have been scratching my head from few hours to > get this to work. Any help would be greatly appreciated. > > > > > -- > With Warm Regards, > Sudheer. S > http://www.binaryvibes.co.in > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php