Hi guys,

I don't know PHP so I got someone to write this code for me:

PHP Code:

<?php
    $query_string = '
        SELECT *,name FROM '.$wpdb->prefix.'term_taxonomy
        JOIN '.$wpdb->prefix.'terms
        ON '.$wpdb->prefix.'term_taxonomy.term_id = '.$wpdb->prefix.'terms.term_id
        WHERE '.$wpdb->prefix.'term_taxonomy.taxonomy = "post_tag" and '.$wpdb->prefix.'terms.name like '."'A%'".'    ORDER      by  '.$wpdb->prefix.'terms.name ASC ';

    $post_tags = $wpdb->get_results($query_string);
    ?>
    <div class="abc">
        <ul>
    <?php
    foreach($post_tags as $key => $tag) {
        $newletter = substr($tag->name, 0, 1);
        if($newletter !== $letter && $key != 0) { ?>
        </ul>
    </div>
    <?
}
?>

But it gives the following error:

Parse error:  syntax error, unexpected $end

Could someone please fix the syntax or whatever it is that's wrong so it doesn't give the error any more.

You're missing a closing brace }

Originally Posted by NullPointer

You're missing a closing brace }

Stupid question: but where should I put the closing brace (this is how clueless I am about PHP)...

Originally Posted by Towhid

Stupid question: but where should I put the closing brace (this is how clueless I am about PHP)...

Between the last ending } and ?>, so it should look like this:

}
}
?>

Great, it works now! Thanks to both of you