今天就写了这一个语句!前面上千行的内容都是为它做了嫁衣!
sql="insert into t_house(h_user_id,h_user_name,h_phone,h_avlid_date,h_city,h_address,h_type,
h_class,h_floor,h_year,h_area,h_price,h_payment,h_current,h_face,h_fitment,h_attest,h_paper,
h_fixture,h_resume,h_agent,h_msg_type)"
sql=sql&" values("&m_user_id&",'"&m_name&"','"&m_phone&"','"&now()+m_valid_date&"',
'"&m_city&"','"&m_address&"','"&m_house_class&"'"
sql=sql&",'"&m_house_type&"','"&m_floor&"','"&m_year&"',"&m_area&",'"&m_price&"',
'"&m_payment&"','"&m_current&"','"&m_face&"','"&m_fitment&"','"&m_attest&"',"&m_paper&",
'"&m_fixture&"','"&m_resume&"',"&m_msg_agent&","&m_msg_type&")"
最烦的还是用户自动注册!只是又多了一个槛!算了,只希望这个月底能完成就谢天谢地了!
文章来源:http://computer.mblogger.cn/wucountry/posts/22724.aspx