This should work as well (newer syntax) ?:
SELECT F.question, F.answer
FROMFaqsAS F
LEFT JOIN FaqsRelatedToProducts AS FP ON F.faqid = FP.faqid
WHERE fgnumber = '$yourfgnumber'
Use:
SELECT DISTINCT ...
when your FaqsRelatedToProducts
Hi list,
I am trying to develop a product catalog using MySQL and PhP.
A long time I was looking for some tips for the database
structure.
The idea is to have a powerfull and as much as possible
universal DB application.
Does anyone have an idea of a book, e-book, site, resource please ?
12:19
To: Hynek Semecký ME; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Catalog
lots of excellent resources on www.devshed.com, notably a PHPShop tutorial
and a catalogue implementation.
Ignatius
- Original Message -
From: Hynek Semecký ME [EMAIL
Semecký ME'; Ignatius Reilly; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Catalog
jou want to make it yourself even without nowing how to code it or how to
set up a database design???
just by looking to other code??
think it will be to hard for a first project.. just my idea...
kind regards,
Mark
First you have to find how many rows would make your SELECT query in
case you would not use LIMIT from, num.
Then you have to divide this by number of rows per page and use it
in the SELECT query.
Then to your number of pages displayed on your page you add links to
the first number of the LIMIT