Changeset 2446

Show
Ignore:
Timestamp:
09/05/08 03:41:09 (3 months ago)
Author:
tinyau
Message:

Changed single quote to double quote to fix the variable subsitution of {$repeat_questions}.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/htdocs/system/classes/post.php

    r2440 r2446  
    471471        /* Now, let's insert any *new* tag texts or slugs into the tags table */ 
    472472        $repeat_questions= Utils::placeholder_string( count($clean_tags) ); 
    473         $sql_tags_exist= 'SELECT id, tag_text, tag_slug 
     473        $sql_tags_exist= "SELECT id, tag_text, tag_slug 
    474474            FROM {tags} 
    475475            WHERE tag_text IN ({$repeat_questions}) 
    476             OR tag_slug IN ({$repeat_questions})'; 
     476            OR tag_slug IN ({$repeat_questions})"; 
    477477        $params= array_merge( array_keys( $clean_tags ), array_values( $clean_tags ) ); 
    478478        $existing_tags= DB::get_results( $sql_tags_exist, $params ); 
    … …  
    546546             */ 
    547547            $repeat_questions= Utils::placeholder_string( count($tag_ids_to_post) ); 
    548             $sql_delete= 'DELETE FROM {tag2post} WHERE post_id = ? AND tag_id NOT IN ({$repeat_questions})'; 
     548            $sql_delete= "DELETE FROM {tag2post} WHERE post_id = ? AND tag_id NOT IN ({$repeat_questions})"; 
    549549            $params= array_merge( (array) $post_id, array_values( $tag_ids_to_post ) ); 
    550550            $result&= DB::query( $sql_delete, $params );