Displaying contents from MySQL database in show/hide div tags

Hi everyone,

Looking at the URL I have submitted, you can see that I have managed to retrieve the poem titles beginning with the letter selected from the array.

The query is: $query="SELECT PoemTitle, PoemText FROM tblPoems WHERE PoemTitle LIKE '".$letter."%' ORDER BY PoemTitle";

$letter is appended to the URL when a letter is clicked.

As you can see, this is working fine for letters A-Z.

I have 2 issues:

1) I can't seem to get the hash/number (#)  sign to work. There are poems that begin with numbers, e.g. 3am, and I want to list those under the "#" sign.

2) I don't know if I can ask about a second problem on the same question but here it goes. If you click on one of the poem titles on the page, you will see the top one expand (obviously I want the one clicked on to expand!). I am using a div tag to do this as I want to be able to show and hide each poem when it is clicked.

However, this seems rather tedious as I will need to create a div with an ID for each poem. Can anyone think of a better way in PHP to do this?

On the web page, the other poems do not show/hide as I have only done it for one, which only works for the first poem listed. I gave up thinking, "there's gotta be a better way to do this!".

I have attached the code snippet for this.

Any help would be greatly appreciated and I will explain more if needed.

Thank you.Start Free Trial

1:
2:
3:
4:
5:
6:

while($row = mysql_fetch_array($result)) {
	echo "<div id=\"contents\" align=\"left\">
			<div id=\"#\" onclick=\"hideAllExcept(this.id);\">
				<p><strong><a href=\"javascript:showhide('test');\">" .$row["PoemTitle"]. "</a></strong></p>
				<div id=\"test\" style=\"display:none\">" .$row["PoemText"]. "</p></div>";	
}