Trusten
09-04-2002, 03:46 AM
Hi,
i'm proud of myself. I'm getting this php thing. I recently made a script that does a search through mulitple tables. Nothing fancy, I know, but for me it's a big deal.
now, down to business.
my titles have to do with translated and untranslated goods. Unsubtitled, and subtitled, right?
now, here is the problem, i want to list ALL things in my catalog, i hve a script for deviding them into pages so i should be ok there. and i can make them go in asc order etc. etc. etc.
problem is this,
i have one product that has 3 versions. each version has their own row in the table. ya know?
what i want to do, is when i hve this script list all in whatever the person searches for, is that it lists the extras.
like say they search for 'gum'
and there is an item called 'gum of the world' or something like that.
and there is one main one that is translated and subtitled, and one isn't.
how do i make it so that when the query is finished and the data is found, that it only lists ONE item, then shows other possible entries that may ineterest the person.
um, does this make any sense?
i'm proud of myself. I'm getting this php thing. I recently made a script that does a search through mulitple tables. Nothing fancy, I know, but for me it's a big deal.
now, down to business.
my titles have to do with translated and untranslated goods. Unsubtitled, and subtitled, right?
now, here is the problem, i want to list ALL things in my catalog, i hve a script for deviding them into pages so i should be ok there. and i can make them go in asc order etc. etc. etc.
problem is this,
i have one product that has 3 versions. each version has their own row in the table. ya know?
what i want to do, is when i hve this script list all in whatever the person searches for, is that it lists the extras.
like say they search for 'gum'
and there is an item called 'gum of the world' or something like that.
and there is one main one that is translated and subtitled, and one isn't.
how do i make it so that when the query is finished and the data is found, that it only lists ONE item, then shows other possible entries that may ineterest the person.
um, does this make any sense?