Forum: Chit Chat
2005-03-21, 07:50 PM
|
|
Replies: 20
Views: 1,791
|
|
Forum: Link Lists & Getting Listed
2005-03-21, 12:14 PM
|
|
Replies: 10
Views: 1,129
|
|
Forum: Programming & Scripting
2005-03-20, 10:24 PM
|
|
Replies: 17
Views: 1,183
F I N A L L Y !
SELECT sponsor,...
F I N A L L Y !
SELECT sponsor, COUNT(keyword) AS cnt FROM (
SELECT sponsor, keyword FROM banners WHERE keyword LIKE 'horizontal'
UNION
SELECT sponsor, keyword FROM banners WHERE keyword LIKE...
|
|
Forum: General Business Knowledge
2005-03-20, 09:19 PM
|
|
Replies: 7
Views: 1,312
|
|
Forum: Possible Cheaters
2005-03-20, 07:20 PM
|
|
Replies: 11
Views: 2,716
|
|
Forum: Programming & Scripting
2005-03-20, 07:07 PM
|
|
Replies: 17
Views: 1,183
|
|
Forum: Programming & Scripting
2005-03-20, 06:49 PM
|
|
Replies: 17
Views: 1,183
Here's what the full query looks like:
...
Here's what the full query looks like:
$uniq_banners = 3;
$query = 'SELECT '.$uniq_banners.' = COUNT(*) FROM (
SELECT DISTINCT 1 FROM banners WHERE sponsor LIKE "$sponsor" AND keyword LIKE...
|
|
Forum: Programming & Scripting
2005-03-20, 06:37 PM
|
|
Replies: 17
Views: 1,183
|
|
Forum: Programming & Scripting
2005-03-20, 06:35 PM
|
|
Replies: 17
Views: 1,183
|
|
Forum: Possible Cheaters
2005-03-20, 06:31 PM
|
|
Replies: 11
Views: 2,716
|
|
Forum: Programming & Scripting
2005-03-20, 05:55 PM
|
|
Replies: 17
Views: 1,183
Exactly, that's why I stick to LIKE :)
I...
Exactly, that's why I stick to LIKE :)
I have it pretty much figured out, but it's in 2 queries.
#1. Get all sponsors
#2. Check if sponsor has the type of banners I'm looking for
SELECT 3...
|
|
Forum: Programming & Scripting
2005-03-20, 11:54 AM
|
|
Replies: 17
Views: 1,183
|
|
Forum: Programming & Scripting
2005-03-20, 01:34 AM
|
|
Replies: 17
Views: 1,183
|
|
Forum: Programming & Scripting
2005-03-20, 12:57 AM
|
|
Replies: 17
Views: 1,183
Mysql query
My mind is completely blank right now, so please help me out here :)
Table:
sponsor | keyword | banner
sponsor1 | horizontal | banner1.jpg
sponsor1 | vertical | banner2.jpg
sponsor1 | button...
|
|
Forum: Link Lists & Getting Listed
2005-03-19, 10:40 PM
|
|
Replies: 20
Views: 2,494
|
|
Forum: General Business Knowledge
2005-03-19, 08:55 PM
|
|
Replies: 27
Views: 2,444
|
|
Forum: Chit Chat
2005-03-19, 06:11 PM
|
|
Replies: 27
Views: 2,170
|
|
Forum: Chit Chat
2005-03-19, 05:03 PM
|
|
Replies: 27
Views: 2,170
I saw part of a documentary about the Millau...
I saw part of a documentary about the Millau Viaduct. When I first heard about before it was being built, it was hard to picture it. It was HUGE, and push the parts out... and the height? It was just...
|
|
Forum: Chit Chat
2005-03-19, 03:42 PM
|
|
Replies: 27
Views: 2,170
If you like tunnels and stuff, you should read...
If you like tunnels and stuff, you should read about the biggest train tunnel fiasco in Swedish history. Hallands*stunneln, unforunately I don't think there's too much about it in English.
The...
|
|
Forum: Chit Chat
2005-03-19, 03:31 PM
|
|
Replies: 27
Views: 2,170
|
|
Forum: Chit Chat
2005-03-19, 02:44 PM
|
|
Replies: 27
Views: 2,170
|
|
Forum: Chit Chat
2005-03-19, 01:56 PM
|
|
Replies: 27
Views: 2,170
|
|
Forum: Chit Chat
2005-03-19, 01:50 PM
|
|
Replies: 27
Views: 2,170
|
|
Forum: Chit Chat
2005-03-19, 01:31 PM
|
|
Replies: 27
Views: 2,170
The hotel in Dubai would be awsome to go see....
The hotel in Dubai would be awsome to go see. It's just amazing. The architecture is not of this world.
The people I buy bread from, Il Panificio (http://www.ilpanificio.se/) has got a contract...
|
|
Forum: Newbie Questions
2005-03-19, 01:14 PM
|
|
Replies: 9
Views: 1,385
It's nice and simple :)
You might want to...
It's nice and simple :)
You might want to compress the pics a little more. The ones I looked at were around 110kB. I'm not sure if it's my connection, but the pics loaded really slow.
|
