> Basically in a nutshell... i made a new row in post signature int(1)
And you have a new column (you said row, you meant column) in members
signature text?...
Where are you storing the actual text and how is it related to 1 or 2 or is
it always just 1?...
If I'm confusing you, draw it out on paper (yes, real paper) with pencil and
write tables of posts, people, signatures, whatever with several rows in
each. Draw circles and arrows to describe how the tables relate to each
other. The arrows need to start/end on some kind of unique IDs so each row
can get the right row out of the other table.
> i replaced the normal code of if ($signature == yes) { $message .= blah }
> with if ($signature == yes) { $memsig = "1"; }
>
> and in post i have
> if ($post[signature] == 1)
> $sql = "SELECT * FROM members WHERE username='UserName'";
> $query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
> $msig = mysql_fetch_array($query);
> $msig[signature] = $sig;
That's backwards. You just got $msig from the database, and all the fields
got filled in, including the 'signature' field, in the mysql_fetch_array()
line.
Then, you wipe that 'signature' field element out and shove $sig into it.
Since $sig is probably empty, that's why all your signatures are empty.
> $pagetext = $pagetext
> . "<BR>____________<BR>" . censor(bbcodeparse($sig));
>
>
> can u find any problems with this code at all?
> the two problems im having are...
> 1. it puts a 1 in the db reguardless of choice.
> 2. when it is set to one, it shows _____________ but the signature is
blank.
> Ive even tried to echo it out and its blank, and as far as i know its
right
> thanks in advance.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
