Filter Records by Author

Hi Perch

Yeah, you can't use that particular code snippet as is. Here's how you can change it to only get distinct values:

<form method="post" action="blog_list.php">
<h3>&nbsp;Filter by Author</h3>
<select name="createdBy.fullname">

<?php $authors = array_unique(getListOptions('bridlington_blogs', 'createdBy.fullname'));
<?php foreach ($authors as $value => $label): ?>

<option value = "<?php echo $value;?>" <?php selectedIf($value, @$_REQUEST['createdBy.fullname']);?>>

<?php echo $label; ?></option>

<?php endforeach ?>

</select>
<br/>
<div align="center">
<input type="submit" name="search" value=" Show Blogs "/>
</div>
</form>

This should work, provided that you change the table and variable names to whatever you're using.

Hi, Claire -

Thanks for this. Unfortunately, no matter which combination of $tablename and $fieldname I use, the getListOptions() function always throws the same error:

Unknown optionsType ''!

I have no idea what's wrong?!

:0(

Perch

Doh!

Of course, the getListOptions() $fieldname must be a list type field!

OK. Now that we've got that sorted... :o)

Claire, your ammendment to the code doesn't help me much I'm afraid!

:0/

Perch

Hi Perch

Apologies, I assumed that would do the job. Not to worry though - it's still possible to get the right records using a quick MYSQL query. It'll look something like this:

<form method="post" action="blog_list.php">
<h3>&nbsp;Filter by Author</h3>
<select name="authornum">

<?php $authors = mysql_select_query("SELECT DISTINCT num, fullname from {$TABLE_PREFIX}authors JOIN {$TABLE_PREFIX}bridlington_blogs ON {$TABLE_PREFIX}bridlington_blogs.createdBy = {$TABLE_PREFIX}authors.num");
<?php foreach ($authors as $record): ?>

<option value = "<?php echo $record['num'];?>" <?php selectedIf($record['num'], @$_REQUEST['authornum']);?>>

<?php echo $record['fullname']; ?></option>

<?php endforeach ?>

</select>
<br/>
<div align="center">
<input type="submit" name="search" value=" Show Blogs "/>
</div>
</form>

I'm assuming your authors table is called 'authors', so you'll have to change it if it isn't. This is more advanced stuff so it may not work exactly right out of the box. Try it out and let me know if it works?

Hi, Claire -

Thanks for your help. I've spiced it up with a little jScript.

<?php $authors = mysql_select_query("SELECT DISTINCT {$TABLE_PREFIX}accounts.num, fullname from {$TABLE_PREFIX}accounts JOIN {$TABLE_PREFIX}gallery ON {$TABLE_PREFIX}gallery.createdByUserNum = {$TABLE_PREFIX}accounts.num"); ?>

<form method="post" action="?user=<?php echo $record['num'];?>">
<h3>Filter by Author</h3>

<select name="authorNum" onChange="top.location.href = this.form.authorNum.options[this.form.authorNum.selectedIndex].value; return false;">
<?php foreach($authors as $record): ?>
<option value = "?user=<?php echo $record['num'];?>" <?php selectedIf($record['num'], @$_REQUEST['authornum']);?>>
<?php echo $record['fullname']; ?></option>
<?php endforeach ?>
</select>
</form>

Is there a way of re-writing this in jQuery?

:0)

Perch

Hey Perch

You could rewrite this in jQuery, yeah, but is there any particular reason why you'd want to, if this works as is?

Hi, Claire

no reason other than to learn a bit more about jquery!

:0)

Perch