Pass string variable into mysql longtext field

Okari

I am trying to pass a string variable into a mysql text field, however it does not change the field in the database:

$current_date = date("Y-m-d");
echo("<br>Current Date is as follows:<br>" . current_date . "<br>");
mysql_query("UPDATE pasta_data SET daily_special = ($logintext) WHERE row_id = '1'");

I have tried putting in different quotation sets, parenthases, etc however nothing has worked so far. Thanks for any help!

Okari

By the way this is a piece of the function, the date IS changed and output in the code, I am interested in the text field of 'daily_special'

DeltaRho2K

Before you run your update query, have you tried echoing $logintext so you can make sure your variable even has data in it?

Also, I know different people (for different reasons) write their code differently:

This is how you wrote the query:

mysql_query("UPDATE `pasta_data` SET `daily_special` = ($logintext) WHERE `row_id` = '1'");

This is how I would write it:

mysql_query("UPDATE pasta_data SET daily_special = '$logintext' WHERE row_id = '1'");

But that's just me ;-)