I need to grab that text file from my database, where attribute id = 64 leaving the "other data" as it is. Then open the txt file in php and put the contents back into that exact field it got them from.
the table name is "mage_catalogsearch_fulltext" for reference
The reason for me doing this is the product descriptions are all inside those text documents, and I need to suck them out and put the actual content into that field rather than the file reference
I am more of a designer but am piecing the php together slowly so far I am connecting to the database and trying to get the files:
$sql = "select 'value' from mage_catalogsearch_fulltext WHERE 'Attribute_id' = 64";
$result = mysql_query ($sql) or die($myQuery."<br/><br/>".mysql_error());
while($row = mysql_fetch_array($result))
This does not do the job however
Any help is greatly appreciated. Simon
Last edited by simonstaton; 10-29-2012 at 06:24 PM.