View Single Post
  #9 (permalink)  
Old October 6th, 2010, 05:02 PM
DMatt DMatt is offline
Authorized User
Points: 152, Level: 3
Points: 152, Level: 3 Points: 152, Level: 3 Points: 152, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2010
Location: Bra - Italy
Posts: 36
Thanks: 1
Thanked 1 Time in 1 Post
Default

Yes, in edit_character.php is the same, i have just checked

Code:
if ($character_id != 0) {
    $query = 'SELECT
        c.alias, c.real_name, c.alignment,
        l.address, z.city, z.state, z.zipcode_id
        FROM
            comic_character c, comic_lair l, comic_zipcode z
        WHERE
            z.zipcode_id = l.zipcode_id AND
            c.lair_id = l.lair_id AND
            c.character_id = ' . $character_id;
    $result = mysql_query($query, $db) or die (mysql_error($db));
the problem is not in these rows... if you describe to me exactly what's the output generated by the script i help you to found it, or if you want i can post the whole script..

-EDIT-

hey take care about the "AS"... don't include that in the rows!!
Reply With Quote