simple php related

i wanna know how can we display right content on one of the results page.

I will explain the background 1st so that you dont get confused :)

Well i m maintaining a database & has structure just like how you guys structure for e-commerce.

At insert page, when adding product there is an option to chose category. here choosing multiple cat option in given.
Now data store as multiple like this: 1,2,3,4.........

Now on results page i know how to display value of 1 category name thru something like this:

<?php $_GET['ID'] = $row_Products[‘CategoryID’]?>

<?php
$colname_CategoryName = "-1";
if (isset($_GET['ID'])) {
  $colname_CategoryName = $_GET['ID'];
}
mysql_select_db($database_con1, $con1);
$query_CategoryName = sprintf("SELECT * FROM LockoutPoints WHERE ID = %s", GetSQLValueString($colname_CategoryName, "int"));
$CategoryName = mysql_query($query_CategoryName, $con1) or die(mysql_error());
$row_CategoryName = mysql_fetch_assoc($ProductCatName);
$totalRows_CategoryName = mysql_num_rows($ProductCatName);
?>

then to show category name i insert php as this:

<?php echo $row_CategoryName['Name'];?>

So lets say i had choosen multiple categories for a product. This display just the first value present in category. ie 1's (category name) ex: 1,2,3,4
I wanna display all category names from 1,2,3,4 values. (category names)


How can this be done?
Anyone?

You can try:

mysql_select_db($database_con1, $con1);

$query_CategoryName = "SELECT * FROM LockoutPoints WHERE ID IN (".$row_Products[‘CategoryID’].")";

$CategoryName = mysql_query($query_CategoryName, $con1) or die(mysql_error());

$row_CategoryName = mysql_fetch_assoc($ProductCatName);

$totalRows_CategoryName = mysql_num_rows($ProductCatName);

?>

Then you can use a repeat region to show all of the category names from the returned recordset.

You made it look easy :) but how can comma (,) be added after each?

Originally Said By: Ray Borduin

  You can try:

php:

mysql_select_db($database_con1, $con1);

$query_CategoryName = "SELECT * FROM LockoutPoints WHERE ID IN (".$row_Products[‘CategoryID’].")";

$CategoryName = mysql_query($query_CategoryName, $con1) or die(mysql_error());

$row_CategoryName = mysql_fetch_assoc($ProductCatName);

$totalRows_CategoryName = mysql_num_rows($ProductCatName);

?>

Then you can use a repeat region to show all of the category names from the returned recordset.  

This is good.

Can be used for all in similar way?

$query_CategoryName = "SELECT * FROM LockoutPoints WHERE ID IN (".$row_Products[‘CategoryID’].")";

I'm not sure I understand the question. I think that the CategoryID column already has a comma separated list of IDs, that is what I got from your post.

If you want to just show the category names comma separated you can use:
$query_CategoryName = "SELECT GROUP_CONCAT(Name) AS AllCats FROM LockoutPoints WHERE ID IN (".$row_Products[‘CategoryID’].")";

And then you can just show the column AllCats and don't need a repeat region.

what is GROUP_CONAT? and AllCats
i got this error : FUNCTION lotomanager.GROUP_CONAT does not exist

Sorry typo... should have been GROUP_CONCAT

That SQL function will take multiple rows in a recordset and combine them comma separated into a single value.

error:
Unknown column 'Name' in 'field list'

What is Name referring to? i m confused a little from this code:

$query_CategoryName = "SELECT GROUP_CONCAT(Name) AS AllCats FROM LockoutPoints WHERE ID IN (".$row_Products[‘CategoryID’].")";

The category name field in the AllCats table that you want comma separated to display on the page.