Webmastersite.net
Register Log In

removing blank 'links' rows

Title removing blank 'links' rows
Description random links Toplist question
Message Text I've been tweaking my own toplist and, it all seems to be working swell. I am using the links table to generate random images from user albums. Here's the one issue I'm having: There are certain rows that do not link to an image. I'm assuming that this is because the user deleted the image but, the row remains in the table. The problem with this is these rows still get chosen in my toplist, here's the code: <CONFIG> links,rand(),2,ascending,,,,1,0,1,0</CONFIG> Is there a way I can either: a) structure the code to only display rows with image links? b) run a scheduled maintainance on the table to remove rows without links? Oh, one more question to avoid multiple posts. I want to call random images (ala a toplist) on other pages within my site BUT outside of the gallery. Is there a way to do this? These other pages are .php pages (just created long before the gallery was implemented). Thanks, Paul!
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership knotworking
Views 668 views. Averaging 0 views per day.
Similar Topics
Submission Date Jul 10, 2005 - 12:07 PM