Jump to content

[SOLVED] insert query


leest

Recommended Posts

OK, thought i had solved this problem but i hadn't.  Anyway the insert query works fine, however i need to put the information in to the mysql database contained in "". 

 

This php code works fine:


$query = "INSERT INTO dashboard_component (module_name, module_parameters, site_id, column_number, position) VALUES 

('text', 'Welcome,((USERNAME))!\r\nDate: ((DATE))\r\nTime: ((TIME))', '$site_id', 0, 1)";

mysql_query($query) or die(mysql_error());

 

now when i re-write the code like this to try and enter the data in to the table within "", it fails, when the page is called, it just returns a blank page.

 


('text', '"Welcome,((USERNAME))!\r\nDate: ((DATE))\r\nTime: ((TIME))"', '$site_id', 0, 1)";

 

Any suggestions will be much appreciated, thanks

 

 

Link to comment
https://forums.phpfreaks.com/topic/115891-solved-insert-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.