[RESOLVED] Conditional drop down

[Azureum]

Hey guys!

I am building a wordpress install for the purpose of storing fan fiction archives.

I have coded up a drop down box that basically will if it finds more than 1 post with the same name, list them in a drop down list so the user can select a chapter (they are organised into episodes via a tag, i.e; 1x01, 1x02).

Here is the code I am using to generate the drop down.

<?php

$counter = '1';

echo '<form action="../">
			<select onchange="window.open(this.options[this.selectedIndex].value,\'_top\')">
			<option value="">Choose a chapter...</option>';	

$chapters = $wpdb->get_results("SELECT * FROM $wpdb->posts
	WHERE post_title = '" . $post->post_title . "' AND post_status = 'publish' ORDER BY post_date");

if ($chapters) :

foreach ($chapters as $post) :
	setup_postdata($post);

echo '<option value="' , the_permalink() , '">Chapter ' , $counter++ , '</option>\n';

endforeach; 


    else : 

endif;

echo '</select></form>';
?>

What I am trying to do and am getting confused because it doesn't seem to work, is this.

I would like to first count how many entries there are, for example if there is only 1 result, I do not wish the dropdown to not output. If there is more than 1 result, then go ahead and output it.

I tried changing if ($chapters) : to if ( $chapters > 1 ) : but this did not work.

It's taken me the better part of a day or so just to wriggle the above code to the point it stands at, I'm quite new to PHP.

Can anyone offer any alternative coding that I could use? Or a better coded solution?

Many thanks for reading!

[dagon]

$x=count($chapters);

if ($x>1){

}else{

}

[Azureum]

dagon;10957654 wrote:

$x=count($chapters);

if ($x>1){

}else{

}

I'm sure I tried using the count option, but I don't believe I set a seperate variable, I believe I included it in the if statement for chapters. I'll have a play around with that.

Just out of curiosity, would you code the above drop down any differently than I? Remember I am new so I would appreciate some feedback on how to code it better, as in keep the same functionality but maybe minify the code in some manner, make it more logical.

Thanks for the reply.

[dagon]

$wpdb object may have better options, i don't use word press so can only speculate.

[Azureum]

I'm quite competent with HTML and CSS personally, I can get the general idea of what some aspects of PHP do and are for, but I am learning, jquery as well at the moment.

I find wordpress is a good mix for me, it will allow me to manage my website easily and also provide me with a learning platform, what CMSs do you use?

[Azureum]

Okay, I merged your code with mine, did a little moving around, and now it is complete and working 100%, I thank you sir!

Just for those who are interested, here is the complete and revised code (moved things around as needed), this might be of interest to some of you doing serialised posts in your blogs, wordpress anyways!)

<?php

$chapters = $wpdb->get_results("SELECT * FROM $wpdb->posts
	WHERE post_title = '" . $post->post_title . "' AND post_status = 'publish' ORDER BY post_date");

$x=count($chapters); 	
$counter = '1';

if ($x>1) :

	echo '<form action="../">
	<select onchange="window.open(this.options[this.selectedIndex].value,\'_top\')">
	<option value="">Choose a chapter...</option>';	

foreach ($chapters as $post) :
	setup_postdata($post);

	echo '<option value="' , the_permalink() , '">Chapter ' , $counter++ , '</option>\n';

endforeach; 

	echo '</select></form>';			

else : 
endif;

?>

Thanks again!