hi there i have a new module created on vabadvanced that shows the last 5 custom made profile fields (or at least thats what i want it to do)
users add their fav youtube videos on thier profile page (url link) along with a title for the video so this uses say field 23 and 24 - thats great and i can have them showing on a block- what i cant get it to do is show random entrys or have anymore than 5 (latest videos showing - a 6th one wont update)
my problem is the USERFIELD table - Using SELCECT rand () will also show entrys not submited - ie: blanks fields (which i dont want on the block) so someone sugested i use datetime on the table... so i can use the random command
Can someone show me how to add this ..or if theres another way around this
i just want either random entrys showing or latest im not fussed - thanks in advanced
users add their fav youtube videos on thier profile page (url link) along with a title for the video so this uses say field 23 and 24 - thats great and i can have them showing on a block- what i cant get it to do is show random entrys or have anymore than 5 (latest videos showing - a 6th one wont update)
my problem is the USERFIELD table - Using SELCECT rand () will also show entrys not submited - ie: blanks fields (which i dont want on the block) so someone sugested i use datetime on the table... so i can use the random command
Can someone show me how to add this ..or if theres another way around this
i just want either random entrys showing or latest im not fussed - thanks in advanced