|
|
Posted by Captain Paralytic on 11/17/06 10:29
alex.kemsley@hottubs2buy.co.uk wrote:
> Captin Paralytic,
>
> Thanks for your input,
> I am using Mysql
> Your were right that prices should have been dealers.
> I can construct the html form with no trouble and access the submitted
> values?
> I have the database already constructed and can access it.
> The main trouble i am having is creating a nested repeat region that
> will display the three cheepest products and their corisponding dealer
> infomation without listing each product more than once in php
>
> Many thanks
>
> Once again
>
> Alex
First thing to say is "Please don't top post". This forum uses bottom
or interleaved posting to improve readability.
The SQL that you posted is not MySQL as far as I am aware, you will
need to use an ORDER BY and a LIMIT 3 on my sample SQL. The SQL that
you posted looked more like MSSQL.
Now, the first thing I did when I saw your latest message was type
"nested repeat region" into google and found on the first page:
http://www.finalwebsites.com/snippets.php?id=30
which is a script showing how to use PHP/MySQL to obtain a nested
repeat region. I am sure that you have already done such a simple thing
as googling what you wanted and so have seen this sample script. So
could you explain in what way this script does not meet your needs so
that we may advise you on what else you may need to do?
Navigation:
[Reply to this message]
|