The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Thread Tools Display Modes
Old 02-16-2007, 09:06 PM
Lionel Lionel is offline
Senior Member
Join Date: Sep 2006
Posts: 135
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Gazette License Holder 
Default Mysql question

In module featured.php we have

PHP Code:
$results $this->db->query_read("SELECT DISTINCT byline, header_image, threadid FROM 

TABLE_PREFIX "gars WHERE feature_untill > " TIMENOW " ORDER BY RAND()"); 
DISTINCT does not work because threadid is different. But every else is the same. I am trying to avoid displaying same image twice. How should I handle the where clause to tell it to get ONLY one threadid with same image

never mind

Last edited by Lionel; 02-18-2007 at 07:15 AM.. Reason: worked around it
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL error every day Hengis Geek Advertising Banner System 8 12-09-2009 07:21 PM
Getting mysql error truCido Geek Advertising Banner System 6 08-11-2008 09:27 AM
reproduce / database / mysql leroub Geek Article and Review System 1 03-02-2008 05:43 AM
mysql error during restore clearchannel Geek Article and Review System 23 01-23-2007 07:38 PM
Mysql error after reinstall? CAMS GeekMart 11 07-03-2006 02:10 AM

All times are GMT. The time now is 12:41 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.