Posted by Bob Bedford on 03/09/06 15:31

Hello there,

I know this isn't a mysql NG, but I've no access to any good mysql
newsgroup, and since most php coders also know mysql, I ask here.

I've a table in wich I store pictures of articles. I've a field where I
store the priority (let's say is the order the pictures are shown).

So I've those fields in the database: articleID, imagepath, priority.

So for article 455 I've this record:
455;455-1.jpg;1
455;455-2.jpg;2
455;455-3.jpg;3

Now some articles have missing numbers priority.
example article 24 has those records:
24;24-2.jpg;2
24;24-4.jpg;4

I've up to 5 pictures per article. How to retrieve with a query all
articlesID where I've priority 2 but not priority1 with mysql ?

Thanks for helping

• Next in forum: Re: Comparing indexed MySQL datetime columns
• Prev in forum: Re: Update statement causes mysql varchar field to be set to empty string
• Thread view: mysql question

[Reply to this message]