[Product table, options table. Select all products with their cheapest option?]

You may also want to have a look at this... I'll probably add this to the stickies at some point.

Informative read, thanks for the link.

[Product table, options table. Select all products with their cheapest option?]

Spot on! Thanks for the prompt solution fenway - Great stuff.

[Product table, options table. Select all products with their cheapest option?]

Confusing title? I couldn't explain it any other way in such a small field! Ok, here goes...

 

product

id, name, description

 

product_option

id, product, name, price

 

I'm trying to display a list of products, each with its cheapest option as the display price.

 

SELECT p.*, po.`price` 
FROM `product` as p
LEFT JOIN `product_option` AS po ON p.`id` = po.`product`
ORDER BY po.`price`

 

This query returns duplicate data, one almost identical row per option, with the price differing. To be expected. I'm having difficulty only returning one row per product, with the price of the cheapest option. I tried adding a GROUP BY p.`id`, and this cut it down to one row per product, but it was not displaying the cheapest price, it displayed the price with the lowest id in the product_option table. Ordering before Grouping returns errors...

 

Am I attacking the task from the wrong direction, can someone point me in the right way? Many thanks.

[Fastest sql server]

I would have thought the speed difference between different database software products is minimal. I'd imagine the difference is made on how well you optimize your queries and the hardware that is running the server(s). Something like WoW probably utilises a silly amount of physical machines...

[You ever see a piece of beautiful code?]

I agree, amazing!

[Forum posting services]

Not sure I follow. Are you asking about paying someone to post on your behalf on a forum you frequent, or are you setting up a forum which you want populated with relevant content to get the ball rolling?

[SMS Gateway]

FYI: UK numbers are 11 digits without the country code.

[still single?]

Why are you worried about it?  There is no benifit for a man to getting married, unless she makes more money than you.

Hah! That made me laugh!

[still single?]

22 and single here - Though, I prefer it that way at the moment. Running a successful business and in the middle of another start-up consumes a lot of my time. I also like my own space, and having a social anxiety disorder doesn't help much.

 

There's time for all that later in life when I have less on my plate. Not an immediate concern for me.

[blocked images of a website]

Do you have any internet security software installed? Some Norton products have been known to block standard banner sized  images.

[sending quotes]

No, we don't break it down unless specifically requested to do so - Even then, we try and leave it in as bigger chunks as possible.

[Image Recoloring with PHP]

Considering you're using a gif, you could just change the colour palette with imagecolorset()

[Macbook Air - imagine writing PHP on this thing]

I stumbled across this last night, very nice looking - Not sure how usable it would be though, you can only go so small before it becomes uncomfortable. Was really impressed at the spec that they have managed to cram into such a small space though! I only had another MacBook delivered last week, damn you Apple!

[Anyone else excited for KDE 4?]

I wasn't aware of the new version, neither am I a user - I use Gnome. Though after reading some hype, I think I might grab a live CD to see what all the fuss is about...

[Which PHP-Editor do you think is the best?]

I'm now currently using Bluefish - Out of the handful of editors I have tried under Ubuntu, it works the best for me, though not perfect. I find that it takes a couple of seconds to open files regardless of their size...

 

My editor is ever changing - I'm now using one called Geany. I think I might stick with this one, good syntax highlighting; fast; built-in function suggestion (including user defined functions) etc.

[What is "managed" hosting?]

So, if you have dedicated hosting that isn't managed, does that mean you personally go in and manage the server?

Yes, you'd be responsible for maintenance such as security and software updates et cetera.

[[SOLVED] Why use {} in "if / else" scripts]

The only time I don't use brackets is for a line like this:

if($x > 0) $y /= $z;

Otherwise, I use the brackets purely for consistency and readability. Unless there's more than one line, then they have to be used anyway!

[providing hosting for customers]

We rent a number of dedicated servers which generally host all of our clients projects, we charge them monthly.

[Help with concept name (reading external URLs, then parsing content)]

Page scraping?

Data mining?

[Make custom directory useing mkdir]

Are you getting any errors? If not, switch error reporting on in php.ini and see what it spits out.

[Would anyone say they are good at mod_rewrite?]

I wouldn't say it's illogical, you're writing regular expressions at the end of the day with a few options here and there. I've never used it on a Windows install, what are the differences? Surely they can't be major?

[Hopelessly Lost]

If I understand you correctly, this is not a language specific problem, but more of a logic problem, right?

[How do image hosting systems filter inappropriate content?]

I can't see how it's not manual, unless they have some kind of proprietary artificial intelligence image recognition software. Unlikely, I think. Either that, or images can be viewed from a direct URL, but not browsable through the website until approved. I've never used an image hosting website in any depth to make me think otherwise.

[Google Map Api]

Have you tried moving the xml file to a directory that is not web accessible?

[upload extract]

Try:

system('unzip "'.$upload_factsheets.'" -d $upload_folder');