[RESOLVED] List selector

[ee12csvt]

Hi,

I am currently creating a website for my wife to sell some of her knitting/crotchet items. I have created an admin section which includes pages to list all the products that are available online or offline.

At the moment I have three separate pages for listing these pages

All products
Online products and
Off line products

I use this code for the offline products page

mysql_select_db($database_connBIW, $connBIW);
$query_rsProducts = "SELECT * FROM biw_product WHERE productonline = 'n' ORDER BY productid ASC";
$query_limit_rsProducts = sprintf("%s LIMIT %d, %d", $query_rsProducts, $startRow_rsProducts, $maxRows_rsProducts);
$rsProducts = mysql_query($query_limit_rsProducts, $connBIW) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);

For the online page I have

mysql_select_db($database_connBIW, $connBIW);
$query_rsProducts = "SELECT * FROM biw_product WHERE productonline = 'y' ORDER BY productid ASC";
$query_limit_rsProducts = sprintf("%s LIMIT %d, %d", $query_rsProducts, $startRow_rsProducts, $maxRows_rsProducts);
$rsProducts = mysql_query($query_limit_rsProducts, $connBIW) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);

To show all products I have this

mysql_select_db($database_connBIW, $connBIW);
$query_rsProducts = "SELECT * FROM biw_product ORDER BY productid ASC";
$query_limit_rsProducts = sprintf("%s LIMIT %d, %d", $query_rsProducts, $startRow_rsProducts, $maxRows_rsProducts);
$rsProducts = mysql_query($query_limit_rsProducts, $connBIW) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts);

Now even though all these work, I want to just use one page to display the information, with a selection box to choose between the three outputs, All, Offline or Online.

Could anyone point me in the right direction?

Regards,

Phil

[_uk_stuff]

Hi,

I think that the easiest method would be to use the GET array and just pass in the filter you wish to apply i.e.

echo "<form method='GET'>"
        ."<SELECT NAME='filter'>"
        ."<OPTION VALUE=''>All Items</OPTION>"
        ."<OPTION VALUE='y'>Published Items</OPTION>"
        ."<OPTION VALUE='n'>Non-Publishe Items</OPTION>"
        ."</SELECT>"
        ."<INPUT TYPE='Submit' VALUE='Load Products'>"
        ."<FORM>";

if ( isset($_GET['filter']) && strlen($_GET['filter']) > 0 )
    $query_rsProducts = "SELECT * FROM biw_product WHERE productonline = '".$_GET['filter']."' ORDER BY productid ASC";
else
    $query_rsProducts = "SELECT * FROM biw_product ORDER BY productid ASC";
mysql_select_db($database_connBIW, $connBIW);
$query_limit_rsProducts = sprintf("%s LIMIT %d, %d", $query_rsProducts, $startRow_rsProducts, $maxRows_rsProducts);
$rsProducts = mysql_query($query_limit_rsProducts, $connBIW) or die(mysql_error());
$row_rsProducts = mysql_fetch_assoc($rsProducts); 

Hope this is of some use?

[jdc44]

I'm not sure I understand your problem entirely, but this is my take on it. You want to use one admin to display your items and foreach item, be able to choose which page (or category) is falls into. I.e., pot-holders go into the online pages, cat-nip toys go into the off-line pages, etc...

I would create an admin page with a search form that allows you to select any one record from your db at a time.
Feed that chosen record into a form that will allow you to modify it's data (as needed). If you have a field for recording where each record gets displayed: (online, offline, all) use it or create one. (let's call it category)

In your form, create a drop-down list with offline, online, all options.
When you submit the form to modify your record, update the db category field for that item to have your drop-down selection chosen(online, offline, or all).

On your pages you display items on, use the 'category' field to determine if an item should be displayed on that page or not.

Hope this helps.

[ee12csvt]

Thanks for the replies,

I shall give it a go later and see if I can get it to work

Regards,

Phil