Jump to content

How to add records to query


AndyPSV

Recommended Posts

I've got query.

 



    SELECT * FROM '.PRFX.'sell WHERE draft = "0" '.$e_sql.' AND ID NOT IN (SELECT id_ FROM '.PRFX.'skipped WHERE uid = "'.$u.'") AND ID NOT IN (SELECT id_ FROM '.PRFX.'followed WHERE uid = "'.$u.'") ORDER BY raised DESC '.$sql_limit;


I want to add 3 records by the lowest number of refreshes; best on 5th position

 

they must be unique (so if you connect two UNION ALL...)

Link to comment
https://forums.phpfreaks.com/topic/293044-how-to-add-records-to-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.