Posted by Ian B on 10/31/05 11:32

I use multi-line strings like that all the time. Obviously I use curly
braces, quotes etc correctly (by the second or third attempt) but
there's nothing to stop you using lines like


db_query("CREATE TABLE {$sys['test_db_table_prefix']}idx (
idx_uid MEDIUMINT NOT NULL AUTO_INCREMENT,
idx_added_user VARCHAR(255),
idx_added_dtm DATETIME,

idx_type VARCHAR(255),
idx_category VARCHAR(255),
idx_subcat VARCHAR(255),

idx_name VARCHAR(255),
idx_company VARCHAR(255),
idx_phone VARCHAR(255),
idx_email VARCHAR(255),

idx_street VARCHAR(255),
idx_area VARCHAR(255),
idx_town VARCHAR(255),
idx_near VARCHAR(255),
idx_region VARCHAR(255),
idx_country VARCHAR(255),

idx_area_search VARCHAR(255),
idx_skill_search VARCHAR(255),

idx_other1 VARCHAR(255),
idx_other2 VARCHAR(255),
idx_other3 VARCHAR(255),
idx_other4 VARCHAR(255),
idx_other5 VARCHAR(255),
idx_other6 VARCHAR(255),
idx_other7 VARCHAR(255),
idx_other8 VARCHAR(255),
PRIMARY KEY (idx_uid)
)
");

• Next in forum: Re: How to store session variables between visits?
• Prev in forum: How to store session variables between visits?
• Thread view: Re: My function returns true but my code does not execute

[Reply to this message]