PHP - All My Posts Are Being Generated For All The Categories

Hi there, I have a piece of code that takes all posts with the category of 'model' and puts it on the models page. It then displays the post as a gallery using fancy box. The problem is I want all posts with the category of 'faces' to go on the faces page, but at the moment they are appearing on both pages. Here is the code I have. Any help will guarantee a donation as I am at my wits end trying to figure this out.

Code: [Select]
<?php
  global $post;

  $args = array(
    'numberposts'     => 8,
    'offset'          => 0,
    'category'        => 'models',
    'orderby'         => 'post_date',
    'order'           => 'DESC',
    'post_type'       => 'post',
    'post_status'     => 'publish' );

  $posts_array = get_posts( $args );
  $x = 1; // track model
  foreach( $posts_array as $post ) {
    setup_postdata($post); ?>
    <div id="model-thumb">
<?php
    $arg2 = array( 'post_type' => 'attachment', 'numberposts' => -1, 'order' => 'ASC', 'post_status' => null, 'post_parent' => $post->ID );
    $attachments = get_posts($arg2);
    if ($attachments) {
        $i = 1; // track images
        foreach ( $attachments as $attachment ) {
            $image_attributes = wp_get_attachment_image_src( $attachment->ID, 'full' );
            if ($i == 1) { // Get thumbnail info to display with second image
                $img1src = $image_attributes[0];
                $img1w = $image_attributes[1];
                $img1h = $image_attributes[2];
            } elseif ($i == 2) { // Display thumbnail with link to second image
?>
           <a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>" 
?><img src="<?php echo $img1src; ?>" width="<?php echo $img1w; ?>" height="<?php echo $img1h; ?>"/></a><br /><p><?php the_content();?></p></div>

<?php
            } else { // Other images
?>
                <div style="display:none;"><a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>"><img src="<?php echo $image_attributes[0]; ?>" width="<?php echo $image_attributes[1]; ?>" height="<?php echo $image_attributes[2]; ?>"/></a></div>

<?php
            }
            $i++; // Increase image count
        }
    }

    $x++; // Increase model count
  }

?>

I have developed a calendar app. You can add events to certain days, edit, delete them, etc. It works fine now but I'm trying to improve the adding event section. I would like to be able to have a form where there are "name_of_event" and "description" inputs and then display a input that would have a date-picker. I also want to have a link/button that says something to the effect of "add additional day" and then tie a javascript function to it so when it is clicked another date-picker input will pop up under the first, and they'll be able to add as many additional days as they like. I can't figure out how to write the php code that will cycle through only the date-picker inputs though. Something like the following

Code: [Select]
<?php
$name = $_POST['name_of_event'];
$description = $_POST['description'];

foreach(datepicker_inputs as $date)// <-- part i need help with
{
mysql_query("INSERT INTO Events (name, description, event_date) VALUES ($name, $description, $date)");
}
?>
anybody have ideas on how i can only cycle through the date inputs? I'm pretty sure i'm going to have the date input form name something like "date_1", "date_2", etc.

Hello Guys,

Need a little help here. I have a db structure like this

cat_id |  cat_name | cat_status | parent_id
1        First Test         1                  0
2        Just testing       1                    0
4        Books               1                    2
5        Cars               1                    0
6        Ford               1                  5

If the parent_id = 0 it is considered to be the parent.
If it is a number it is considered a child and referencing the parent

I want to be able to query the database and grab the cat and the sub cat and echo it on my page. Its like a classified ads application.

Here is my while loop that I currently have which only echo's out the parent category. I would like to echo the child category under the respective parent category.

I think I would have to do a loop within a loop, but not sure how to do it..


$query  = "SELECT * FROM ad_category WHERE cat_status='1' && Parent_id='0' ORDER BY cat_name";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
   
    $cat_name = $row[1];
    

$cupper = UCWords($cat_name);

    echo $cupper . "<br>" ;
    
        
} 




Thanks for your help in advance

Hi,

Please help

I need to make categories with su-categories
I made in my database tables like this

table = categories

cid      |     cat_id    |   parent_list    | categ_name                 | type
1               0                   1                  General category            c
2               1                   1,2               sub category                   s
3               1                   1,3               sub category                   s
4               1                   1,2               sub category                   s
5               1                   1,5               sub category                   s
6               5                   1,5,6            sub sub category            s
7               0                   7                  General category2          c
8               7                   7,8               sub category                   s

I need to view this in dropdown menu using parent_list column

I have been going in circles about how to handle the issue that I have come up with and was hoping that someone could provide a different method. Basically I want to be able to create an infinite number of categories and allow them to be assigned to other categories then making them subcategories/sub sub categories if you will. My initial plan was to use a method I have used before by just saving the parent id of the subcategories and recursively going through the data. However, I am not to fond of this because of the inefficiency that it provides. I did some research and found that method is called the "Adjacency List". I also found another way to do it called "Nested Sets" which seems to be much more efficient but its a little harder to understand / maintain. I was hoping that someone here could offer alternatives to both of these methods that will allow me to keep the efficiency of "Nested Sets" but providing the ease of use / maintenance of the "Adjacency List".

Thanks in advance for any help.