[MySQL Syntax Error]

First of all, I assumed you would be familiar with SMF, simply because this is an SMF forum.

 

Secondly, I didn't specify that this was based on SMF code because it is a syntax error, not an error with the structure or a variable from SMF. So it's not directly related to SMF, it's related to the syntax.

 

But, I do apologize for the misunderstanding.

Why would I be familiar with SMF? You might also mention that your using it instead of simply assuming people would be aware especially considering you posted in MySQL Help.

 

Again I say it is invalid sql. Can we see your actual query, the query that actually gets sent to the database?

 

---

 

This reply, I feel was very rude and not very understanding or kind. And definitely a bad experience for coming to PHP Freaks.

 

Regarding your response.

A) I stated it was a syntax error, not an error with how SMF coded it, which is why I failed to mention this.

B) The syntax error was inside those couple lines of query, which is why I posted them.

 

However, the thing that bothered me most about this post was

C) Thinking that just because a syntax error is reported at that point in the query that it could not have actually been caused by something before that point.

That is quite an assumption, that isn't very nice. I knew it was in these couple lines because I made multiple tests to confirm this. It is also implying that I know nothing about how coding works, which I take as an insult.

 

What am I overlooking?

 

A) Not bothering to tell someone that this is the SMF database abstraction layer and as such it is not directly a mysql question,

B) Not bothering to post the actual syntax error, because that would help someone directly help you.

C) Thinking that just because a syntax error is reported at that point in the query that it could not have actually been caused by something before that point.

 

[MySQL Syntax Error]

I take it that you are not familiar with how SMF works? And yes, that is a small part of the query, but the only part I need help with, and the part that's causing the error.

[MySQL Syntax Error]

Hey everybody!

 

A simple query I am working on is throwing a syntax error out, and I can't seem to find anything wrong with it, I am obviously overlooking something.

	SELECT id, name
	FROM {db_prefix}mainmenu
	ORDER BY name
	WHERE is_top <> {int:true}',
	array(
		'true' => 1,
	)

 

What am I overlooking?

[[SOLVED] Quick navbar if/else statement help]

You're talking about Wordpress and now you're asking about SMF?

 

And you just add it as is. Look at how wp_loginout() is added.

 

No, but there has to be some way to check if a member is an Admin or not.

 

Thanks for the help!

[[SOLVED] Quick navbar if/else statement help]

wp_register() should only show to non-members. If not, modify the source code.

 

There isn't a way to check is someone is an admin, you can check if that person has permission to do something though.

 

Really? How does SMF only show the Admin button to Admins?

 

Also, how would I add "wp_register()" to my source?

 

Thanks for the help!

[[SOLVED] Quick navbar if/else statement help]

Add wp_register(); to wherever you want to show it.

 

How do I get it to show to JUST non-members?

 

Also, how do I show an Admin button to only Admins?

 

Thanks!

[[SOLVED] Quick navbar if/else statement help]

Do you have a member system implemented in your site? If so, what kind of $_SESSION data (and with what array keys) are set when a user is logged in?

 

Member system is, yes.

 

I am fairly new to php, so where do I find what you need to know?

[[SOLVED] Quick navbar if/else statement help]

This is for Wordpress.

[[SOLVED] Quick navbar if/else statement help]

Hey everyone,

 

I would like to make a PHP if else statement so that if a user is NOT logged in it shows a "Login" button, and a "Register" button.

 

When they login the "Register" disappears, and the "Login" becomes "Logout"

 

And if someone is an Admin, for an "Admin" button to be added.

 

Here is my current navbar code:

 

<div class='capsule'>
    <a href='feed:<?php bloginfo('comments_rss2_url'); ?>'>
    <img border='0' align='top' alt='Comments RSS'
        src='<?php print bloginfo('template_directory') . "/images/rss-icon.gif"; ?>'>
    <span title='Subscribe to the RSS feed for the comments on this site'>Comments</span>
    </a>
    </div>

    <div class='capsule'>
    <a href='feed:<?php bloginfo("rss2_url"); ?>'>
    <img border='0' align='top' alt='Site RSS'
        src='<?php print bloginfo('template_directory') . "/images/rss-icon.gif"; ?>'>
    <span title='Subscribe to the RSS feed for the posts on this site'>Site</span>
    </a>
    </div>

    <?php if( $options['showloginout'] == 1 ) { ?>
    <div class='capsule'>
    <?php wp_loginout(); ?>
    </div>
    <?php } ?>

    <div class='capsule'>
    <a href="" target="_blank" title="Forums">Forums</a>
    </div>

    <div class='capsule'>
    <a href="" title="Home" target="_self">Home</a>
    </div>Help would be appreciated! 

 

Help would be appreciated!