Show And Hide Using PHP?

[Guest hauntmisery]

Hello, I have a bit of a problem here.. im pulling some data form mysql and i need to do a show and hide type thing but i cant seem to find anything that will work cause the data is in a WHILE loop form mysql.. so what do i do now?  :o

[Daniel0]

What do you mean with "show and hide type thing"?

[Guest hauntmisery]

like let me give you a example  go here http://www.spookyplanet.com/ and than cick on Animations under the categories youll see the sub list come under Animations

[Daniel0]

That would be a matter of CSS, but I am not sure what you got problems with? Do you create the menu dynamically? Is that the problem?

[Guest hauntmisery]

yes thats is the problem i have posted my code below

[code]<tr>
                <td><img src="images/cat_left_top.jpg" width="180" height="40"></td>
              </tr>
  <?
  $categories = mysql_query("SELECT * FROM `store_categories` ORDER BY `id`");
              while ($categoriesget = mysql_fetch_array($categories)) {
  ?>
              <tr>
                <td class="cat_text">
                  <a href="?list=<?=$categoriesget[id]?>"><?=$categoriesget[categorie_name];?></a>

<?
if ($_GET['list']) {
$categorie_list = mysql_query("SELECT * FROM `store_categorie_list` WHERE list_categorie_id='$_GET[list]' ORDER BY `id`");
            while ($categorie_list_get = mysql_fetch_array($categorie_list)) {
echo "<br><br>--- $categorie_list_get[list_name]";
}
}
?>

  </td>
              </tr>

              <tr>
                <td height="0"><hr align="center" width="170" size="1" noshade class="cat_bar"></td>
              </tr> <?
  }
  ?>[/code]

[Daniel0]

What errors do you get using that code?

[Guest hauntmisery]

none.. it just shows the sub list in all main cats

Home Decor

--- Test 1 

--------------------------------------------------------------------------------

Illusions

--- Test 1 

like that..

[Daniel0]

Can you post a screenshot or give me a link to the site?

[Guest hauntmisery]

it dose this..

Home Decor

--- Test 1 

--------------------------------------------------------------------------------

Illusions

--- Test 1 

[Daniel0]

You don't like have a screenshot of your output? For what I can tell from what you posted, it looks ok.

[Guest hauntmisery]

ill give you a link..

http://www.nightmaredesigns.com/previews/monster-tronics/

click on home decor and illsusions

[Daniel0]

Try this code: [code]<?php
echo <<<EOF
<tr>
<td><img src="images/cat_left_top.jpg" width="180" height="40"></td>
</tr>

EOF;
$categories = mysql_query("SELECT * FROM store_categories ORDER BY id");
while($c = mysql_fetch_assoc($categories))
{
echo <<<EOF
<tr>
<td class="cat_text">
<a href="?list={$c['id']}"{$c['categorie_name']}</a>

EOF;
if($_GET['list'])
{
$_GET['list'] = mysql_real_Escape_string($_GET['list']);
$c_list = mysql_query("SELECT * FROM store_categorie_list WHERE list_categorie_id='{$_GET['list']}' ORDER BY id");
while($c_list_item = mysql_fetch_assoc($c_list))
{
echo "\t\t\t<br /><br/>--- {$categorie_list_get['list_name']}\n";
}
}
echo <<<EOF
</td>
</tr>

EOF;
}
echo <<<EOF
<tr>
<td height="0"><hr align="center" width="170" size="1" noshade class="cat_bar"></td>
</tr>

EOF;
?>
[/code]

[Guest hauntmisery]

Parse error: syntax error, unexpected $end in /home/nightdes/public_html/previews/monster-tronics/index.php on line 279

[Daniel0]

That must be something you did. My code could in no possible way make that error. Show us the [i]entire[/i] code from index.php and we will show you how to implement the code correctly.

[Guest hauntmisery]

still doing the same sub cats in the main cats thang..

[wildteen88]

Try this:
[code]echo <<<EOF
<tr>
<td><img src="images/cat_left_top.jpg" width="180" height="40"></td>
</tr>

EOF;

$categories = mysql_query("SELECT * FROM store_categories ORDER BY id");

while($c = mysql_fetch_assoc($categories))
{
echo <<<EOF
<tr>
<td class="cat_text">
<a href="?list={$c['id']}"{$c['categorie_name']}</a>

EOF;
if(isset($_GET['list']) && is_numeric($_GET['list']) && $_GET['list'] == $c['id'])
{
$_GET['list'] = mysql_real_Escape_string($_GET['list']);
$c_list = mysql_query("SELECT * FROM store_categorie_list WHERE list_categorie_id='{$_GET['list']}' ORDER BY id");

        echo "\t\t\t<p>\n";

        while($c_list_item = mysql_fetch_assoc($c_list))
{
echo "\t\t\t--- {$categorie_list_get['list_name']}<br />\n";
}
}
echo <<<EOF
            </p>
</td>
</tr>

EOF;
}
echo <<<EOF
<tr>
<td height="0"><hr align="center" width="170" size="1" noshade class="cat_bar"></td>
</tr>

EOF;[/code]

[Guest hauntmisery]

Parse error: syntax error, unexpected $end in /home/nightdes/public_html/previews/monster-tronics/index.php on line 278

EDIT:
Parse error: syntax error, unexpected $end in /home/nightdes/public_html/previews/monster-tronics/index.php on line 282

[wildteen88]

You must of done something to your code, when you copied and pasted the code over, all I did was mofify the if statement. Make sure [b]EOF;[/b] is not indented and is on its own line with no whitespace before or after it.

[Mutley]

Those codes are both error free. Post ALL the code to your index.php Your probably missing a closed curley bracket at the end.

[Guest hauntmisery]

i could never get this to work...

[wildteen88]

Ok. I got rid of all the heredoc statements. Try this:
[code]echo '
    <tr>
        <td><img src="images/cat_left_top.jpg" width="180" height="40"></td>
    </tr>';

$categories = mysql_query("SELECT * FROM store_categories ORDER BY id");

while($c = mysql_fetch_assoc($categories))
{
    echo '
    <tr>
        <td class="cat_text">
            <a href="?list=' . $c['id'] .'">' . $c['categorie_name'] . '</a>';

    if(isset($_GET['list']) && is_numeric($_GET['list']) && $_GET['list'] == $c['id'])
    {
    $_GET['list'] = mysql_real_Escape_string($_GET['list']);

        $sql = "SELECT * FROM store_categorie_list WHERE list_categorie_id='" . $_GET['list'] . "' ORDER BY id";

        $c_list = mysql_query($sql);

        echo "\t\t\t<p>\n";

        while($c_list_item = mysql_fetch_assoc($c_list))
        {
            echo "\t\t\t\t--- {$categorie_list_get['list_name']}<br />\n";
        }
    }

    echo '
            </p>
</td>
    </tr>';
}

echo '
    <tr>
        <td height="0"><hr align="center" width="170" size="1" noshade class="cat_bar"></td>
    </tr>';[/code]
if you cannot get that code to work then there is an error with your code. if you get any error post the full code here.

[Guest hauntmisery]

nice nice nice.. it works thanks!