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.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2007, 08: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 06:15 AM.. Reason: worked around it
Reply With Quote
Reply

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 06:21 PM
Getting mysql error truCido Geek Advertising Banner System 6 08-11-2008 08:27 AM
reproduce / database / mysql leroub Geek Article and Review System 1 03-02-2008 04:43 AM
mysql error during restore clearchannel Geek Article and Review System 23 01-23-2007 06:38 PM
Mysql error after reinstall? CAMS GeekMart 11 07-03-2006 01:10 AM


All times are GMT. The time now is 09:45 AM.


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