Re: Need some Help! [:)]

> 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