Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Dynamic Values in a Menu

Dynamic Values in a Menu

Thread began 4/07/2011 2:03 pm by hbibizadeh396670 | Last modified 4/08/2011 10:36 am by Jason Byrnes | 2128 views | 11 replies |

4/07/2011 2:03 pm | #1 hbibizadeh396670

Dynamic Values in a Menu

Hi

I have made an admin end for my comment system.

I filter the posts on pages using a unique field in the database.

This works as follows, when a person submits a comment they submit a value defined by a hidden field.

As a result, comments from the same page have the same value in the field of the database. For example 1

However this has created a small problem.

In the admin, I would like to use the field to allow the admin to search for comments based on a particular page.

As a result, I have a dynamic menu/list set up to show the value of the database field.

The problem is, posts from the same page have the same value in the database field. Creating multiple posts in the database field with the same value.

the problem is that the same value or comment page, appears multiple times.

How to I only allow the unique values to display in the menu/list.

Thanks in advance.

If this is not possible do you have any ideas on how I could do this

thanks

4/07/2011 2:08 pm | #2 Jason ByrnesWebAssist

add a group by clause to the recordset:

SELECT * FROM tblName GROUP BY columnName

4/07/2011 2:39 pm | #3 hbibizadeh396670

Could you expand on this.

Im not too sure I understand

Thanks

4/07/2011 3:45 pm | #4 Jason ByrnesWebAssist

you need to use the GROUP BY argument in your recordset:
GROUP BY columnName

where columnName is the name of the column you dont want to have repeated values for.

4/07/2011 4:26 pm | #5 hbibizadeh396670

Ok that works but now the search does not work, it just returns with everything

Not sure why

4/08/2011 6:49 am | #6 Jason ByrnesWebAssist

please send a copy of your pages so i can see the code and a link where i can see the problem in a browser to investigate.

4/08/2011 8:37 am | #7 hbibizadeh396670

Hi yep sure

I attached the files and the links below

Link to comment page

Comment.php

Link to admin search

siteezy_comments_Search.php

The database only has two files, if you search. Each seach only should retun one result

Please note: I have not made a design yet just building the system

thanks

4/08/2011 8:39 am | #8 hbibizadeh396670

Sorry forgot to attach the files.

here they are

thanks

4/08/2011 8:57 am | #9 Jason ByrnesWebAssist

to help troubleshoot:

change the following code:

php:

<div class="WADAResultDescription"><?php echo $row_WADAsiteezy_comments["Comment"]; ?></div>

to:

php:

<div class="WADAResultDescription"><?php echo $row_WADAsiteezy_comments["Comment"]; ?>||<?php echo $row_WADAsiteezy_comments["UniquePage"]; ?></div>

and add the following code just after the <body> tag:

php:

SQL: <?php echo($query_limit_WADAsiteezy_comments); ?><br />

4/08/2011 9:22 am | #10 hbibizadeh396670

Thanks for the help

I think I did it right.

I added it on the results page?

I did the code but it seems to have given me an error.

SQL: SELECT CommentID, CommentName, UserEmail, Comment, UniquePage, TimeStamp, URL FROM siteezy_comments WHERE ((UniquePage = 0)) ORDER BY TimeStamp DESC LIMIT 0, 10

at the bottom of the page?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.