On Friday 05 October 2007 07:08:25 Neil: esl-lounge.com wrote:
Your code seems to work for a menu change where the uid, I want to be the uid of the member who is navigating the site.
I will also have similar links on members' user pages, profile pages, etc....so for these, the uid wouldn't change, it would always be the uid of that node's author.
I made the following change and it seems to work:
<?php global $user; $node_type = 'story'; if (db_num_rows(db_query("SELECT * FROM {node} WHERE type='%s' AND uid=%d", $node_type, $node->uid))) { print(t("View Story")); } else { print(t("Create Story")); } ?>
Ah, yes. One or more errors did exist. I was even looking at the node table to make sure there was the uid column and still put in the user stuff. The line with "global $user;" is unnecessary and can be removed.
And, actually, if the node type will never change, you can eliminate the line with "$node_type = 'story';" and replace your "if" statement to this:
if (db_num_rows(db_query("SELECT * FROM {node} WHERE type='story' AND uid=%d", $node->uid))) {