jakebur01

There is another website that is connected to this database. The site was created by a big company using asp. I have gone through miles of asp code looking for this and have not found it. I am using this table so I can use all of the products. I am looking for the quanity column. I am think this is it that is encoded. I was hoping maybe their are a few different functions I could try to decode this to get the info out of my fields.

`CommerceInsight_dbo` CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `CommerceInsight_dbo`; -- ------------------------------------- -- Tables DROP TABLE IF EXISTS `CommerceInsight_dbo`.`Item`; CREATE TABLE `CommerceInsight_dbo`.`Item` ( `CompanyNo` CHAR(2) NOT NULL, `No` CHAR(20) NOT NULL, `Descn1` VARCHAR(30) NOT NULL, `Descn2` VARCHAR(30) NOT NULL, `ItemClassCode` CHAR(3) NOT NULL, `SeqNo` VARCHAR(5) NOT NULL, `UomSmallest` CHAR(2) NOT NULL, `Uom2` CHAR(2) NOT NULL, `Uom3` CHAR(2) NOT NULL, `UomSt` CHAR(2) NOT NULL, `UomPr` CHAR(2) NOT NULL, `UomSl` CHAR(2) NOT NULL, `UomCt` CHAR(2) NOT NULL, `UomBy` CHAR(2) NOT NULL, `Cf2Sm` CHAR(10) NOT NULL, `Cf3Sm` CHAR(10) NOT NULL, `Alpha` CHAR(10) NOT NULL, `StdPack` INT(10) NOT NULL, `ManualCost` DECIMAL(19, 4) NOT NULL, `ManualCostBasis` CHAR(1) NOT NULL, `ManualCostMultiplier` DECIMAL(8, 3) NOT NULL, `CfMask` CHAR(10) NOT NULL, `GlTable` CHAR(3) NOT NULL, `VendorNo` CHAR(10) NOT NULL, `VendorItemNo` VARCHAR(30) NOT NULL, `DateLastSale` DATETIME NOT NULL, `DateLastPurchase` DATETIME NOT NULL, `DateLastPrice` DATETIME NOT NULL, `DateLastCost` DATETIME NOT NULL, `DateEstablished` DATETIME NOT NULL, `Taxable` CHAR(1) NOT NULL, `UpdateInventory` CHAR(1) NOT NULL, `SerialLots` CHAR(1) NOT NULL, `MiscSales` CHAR(1) NOT NULL, `ManufacturedItem` CHAR(1) NOT NULL, `Active` CHAR(1) NOT NULL, `MultipleUom` CHAR(1) NOT NULL, `DfltPrices` CHAR(1) NOT NULL, `WeightUom1` DECIMAL(18, 0) NOT NULL, `WeightUom2` DECIMAL(18, 0) NOT NULL, `WeightUom3` DECIMAL(18, 0) NOT NULL, `FreightClass` CHAR(3) NOT NULL, `MsdsId` CHAR(20) NOT NULL, `StdComm` DECIMAL(5, 3) NOT NULL, `SubItem1` CHAR(20) NOT NULL, `SubItem2` CHAR(20) NOT NULL, `SubItem3` CHAR(20) NOT NULL, `NotUsed2` VARCHAR(15) NOT NULL, `ModelNo` CHAR(15) NOT NULL, `DotCode` CHAR(6) NOT NULL, `ItemPriceClassCode` CHAR(3) NOT NULL, `ListPrice` DECIMAL(19, 4) NOT NULL, `Service` CHAR(1) NOT NULL, `MeteredItem` CHAR(1) NOT NULL, `Uom_Meter` CHAR(2) NOT NULL, `Track` CHAR(1) NOT NULL, `NotUsed1` CHAR(5) NOT NULL, `ModelCode` CHAR(15) NOT NULL, `SalesSvrItem` CHAR(20) NOT NULL, `PricingType` CHAR(1) NOT NULL, `PartsWtyDays` CHAR(4) NOT NULL, `LaborWtyDays` CHAR(4) NOT NULL, `Fltr` TINYINT(1) NOT NULL, `Icmun1` VARCHAR(1) NOT NULL, `Icmun2` VARCHAR(1) NOT NULL, `Icmun3` VARCHAR(1) NOT NULL, `Icmun4` VARCHAR(1) NOT NULL, `Icmun5` VARCHAR(1) NOT NULL, `Udf1` VARCHAR(50) NOT NULL, `Udf2` VARCHAR(50) NOT NULL, `Udf3` VARCHAR(50) NOT NULL, `Udf4` VARCHAR(50) NOT NULL, `Udf5` VARCHAR(50) NOT NULL, `TS` TIMESTAMP NOT NULL, `rowguid` VARCHAR(64) NOT NULL, PRIMARY KEY (`CompanyNo`, `No`), INDEX `IX_Item_Alpha` (`CompanyNo`, `Alpha`), INDEX `IX_Item_ClassCode` (`CompanyNo`, `ItemClassCode`), INDEX `IX_Item_ModelNumber` (`CompanyNo`, `ModelNo`), INDEX `IX_Item_MsdsId` (`CompanyNo`, `MsdsId`), INDEX `IX_Item_SearchNoDescn1` (`CompanyNo`, `No`, `Descn1`), INDEX `IX_Item_VendorItemNo` (`CompanyNo`, `VendorItemNo`), INDEX `IX_Item_VendorNo` (`CompanyNo`, `VendorNo`), INDEX `IX_Item_VendorNo_ClassCode` (`CompanyNo`, `VendorNo`, `ItemClassCode`) ) ENGINE = INNODB; SET FOREIGN_KEY_CHECKS = 1; -- ---------------------------------------------------------------------- -- EOF

I am retrieving the data: CfMask is the column that returns ########0 . I have 80,000 rows of products. I just need to decode this one column somehow. $result=mysql_query("SELECT No, Descn1, CfMask, VendorNo, VendorItemNo, ListPrice ". "FROM item ". "limit $offset,$limit"); ?> <TABLE width=100% BORDER=1 CELLSPACING=0 CELLPADDING=5 ALIGN=center > <?php while ($myrow=mysql_fetch_array($result)) { echo"<tr><TD WIDTH=133><p class=foot><small>"; echo$myrow["No"]; echo"</small></p></td><TD WIDTH=133><p class=foot><small>"; echo$myrow["Descn1"]; echo"</small></p></td><TD WIDTH=133><p class=foot><small>"; echo$myrow["CfMask"]; echo"</small></p></td><TD WIDTH=133><p class=foot><small>"; echo$myrow["VendorNo"]; echo"</small></p></td><TD WIDTH=133><p class=foot><small>"; echo$myrow["VendorItemNo"]; echo"</small></p></td><TD WIDTH=133><p class=foot><small>"; echo$myrow["ListPrice"]; echo"</small></p></td>"; echo"</tr>"; } echo "</table>";

Any ideas on what I could do on this?

Varchar 10

(char(10),not null)

I have a column in my mysql table that has ########0 in all of its fields. How to I get whats in these fields? How do I decode this using php? P.S. The data originally came out of a mssql database. I now have all of the data in a mysql database and I am using php. Thanks, `Jake

I have a column that has ########0 in all of its fields. How to I get whats in these fields? How do I decode this? P.S. The data originally came out of a mssql database. I now have all of the data in a mysql database and I am using php. `Jake

Thank you. I will write this down for my records. `Jake

I exported a table from my localhost mysql database in sql and csv formats. I am trying to import this into my remote mysql database using phpmyadmin. The sql server query file is 46.5mb and has 80,000 rows. The csv file is about 33mb. I have tried importing either one of these files, it will just load for a little while and then goes to a white page. I am assuming it is just timing out or something. What are some other approaches I could use? `Jake

yea it is large. 80,000 products. I just took that default and function off for now. I don't need to add any more products I just need to move it into my mysql database so I can use it with my php shopping basket. `Jake

DROP TABLE IF EXISTS `CommerceInsight_dbo`.`Item`; CREATE TABLE `CommerceInsight_dbo`.`Item` ( `CompanyNo` CHAR(2) NOT NULL, `No` CHAR(20) NOT NULL, `Descn1` VARCHAR(30) NOT NULL, `Descn2` VARCHAR(30) NOT NULL, `ItemClassCode` CHAR(3) NOT NULL, `SeqNo` VARCHAR(5) NOT NULL, `UomSmallest` CHAR(2) NOT NULL, `Uom2` CHAR(2) NOT NULL, `Uom3` CHAR(2) NOT NULL, `UomSt` CHAR(2) NOT NULL, `UomPr` CHAR(2) NOT NULL, `UomSl` CHAR(2) NOT NULL, `UomCt` CHAR(2) NOT NULL, `UomBy` CHAR(2) NOT NULL, `Cf2Sm` CHAR(10) NOT NULL, `Cf3Sm` CHAR(10) NOT NULL, `Alpha` CHAR(10) NOT NULL, `StdPack` INT(10) NOT NULL, `ManualCost` DECIMAL(19, 4) NOT NULL, `ManualCostBasis` CHAR(1) NOT NULL, `ManualCostMultiplier` DECIMAL(8, 3) NOT NULL, `CfMask` CHAR(10) NOT NULL, `GlTable` CHAR(3) NOT NULL, `VendorNo` CHAR(10) NOT NULL, `VendorItemNo` VARCHAR(30) NOT NULL, `DateLastSale` DATETIME NOT NULL, `DateLastPurchase` DATETIME NOT NULL, `DateLastPrice` DATETIME NOT NULL, `DateLastCost` DATETIME NOT NULL, `DateEstablished` DATETIME NOT NULL, `Taxable` CHAR(1) NOT NULL, `UpdateInventory` CHAR(1) NOT NULL, `SerialLots` CHAR(1) NOT NULL, `MiscSales` CHAR(1) NOT NULL, `ManufacturedItem` CHAR(1) NOT NULL, `Active` CHAR(1) NOT NULL, `MultipleUom` CHAR(1) NOT NULL, `DfltPrices` CHAR(1) NOT NULL, `WeightUom1` DECIMAL(18, 0) NOT NULL, `WeightUom2` DECIMAL(18, 0) NOT NULL, `WeightUom3` DECIMAL(18, 0) NOT NULL, `FreightClass` CHAR(3) NOT NULL, `MsdsId` CHAR(20) NOT NULL, `StdComm` DECIMAL(5, 3) NOT NULL, `SubItem1` CHAR(20) NOT NULL, `SubItem2` CHAR(20) NOT NULL, `SubItem3` CHAR(20) NOT NULL, `NotUsed2` VARCHAR(15) NOT NULL, `ModelNo` CHAR(15) NOT NULL, `DotCode` CHAR(6) NOT NULL, `ItemPriceClassCode` CHAR(3) NOT NULL, `ListPrice` DECIMAL(19, 4) NOT NULL, `Service` CHAR(1) NOT NULL, `MeteredItem` CHAR(1) NOT NULL, `Uom_Meter` CHAR(2) NOT NULL, `Track` CHAR(1) NOT NULL, `NotUsed1` CHAR(5) NOT NULL, `ModelCode` CHAR(15) NOT NULL, `SalesSvrItem` CHAR(20) NOT NULL, `PricingType` CHAR(1) NOT NULL, `PartsWtyDays` CHAR(4) NOT NULL, `LaborWtyDays` CHAR(4) NOT NULL, `Fltr` TINYINT(1) NOT NULL, `Icmun1` VARCHAR(1) NOT NULL, `Icmun2` VARCHAR(1) NOT NULL, `Icmun3` VARCHAR(1) NOT NULL, `Icmun4` VARCHAR(1) NOT NULL, `Icmun5` VARCHAR(1) NOT NULL, `Udf1` VARCHAR(50) NOT NULL, `Udf2` VARCHAR(50) NOT NULL, `Udf3` VARCHAR(50) NOT NULL, `Udf4` VARCHAR(50) NOT NULL, `Udf5` VARCHAR(50) NOT NULL, `TS` TIMESTAMP NOT NULL, `rowguid` VARCHAR(64) NOT NULL DEFAULT newid(), PRIMARY KEY (`CompanyNo`, `No`), INDEX `IX_Item_Alpha` (`CompanyNo`, `Alpha`), INDEX `IX_Item_ClassCode` (`CompanyNo`, `ItemClassCode`), INDEX `IX_Item_ModelNumber` (`CompanyNo`, `ModelNo`), INDEX `IX_Item_MsdsId` (`CompanyNo`, `MsdsId`), INDEX `IX_Item_SearchNoDescn1` (`CompanyNo`, `No`, `Descn1`), INDEX `IX_Item_VendorItemNo` (`CompanyNo`, `VendorItemNo`), INDEX `IX_Item_VendorNo` (`CompanyNo`, `VendorNo`), INDEX `IX_Item_VendorNo_ClassCode` (`CompanyNo`, `VendorNo`, `ItemClassCode`) ) ENGINE = INNODB; Here is the message it is giving me: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'newid(), PRIMARY KEY('companyNo', 'No'), INDEX 'IX_Item_Alpha'('CompanyNo' at line 76

Thank you.

I am migrating data from a ms sql table into mysql. I keep getting an error with this: newid() Is there another way to write this? Thanks, `Jake

I want to copy a table from my ms sql database into my mysql database. If I use the migration tool to do this will this change or effect the data in my ms sql table in any way? I need to leave the data in my mssql table untouched. `Jake

Thank you. I will play with that and see what happens. `Jake

I will be using php and mysql alone for the shopping basket. I just need a way to retrieve the quanities out of the mssql database and update them into the mysql database regularly. There has to be a way to do it.

Ok, I have two different servers in two different locations. One server has a microsoft sql database "this is at the location of the business" the database has a table of about 80,000 different products. The second server has a mysql database, this is where the shopping basket will be located. The myql database will have the same table as the microsoft sql table has with all of the products. My problem is that I need to update the quanities in the mysql database regularly. The product item table on the microsoft sql is located at the place of business and the quanities are changing all the time. My question is: Is it possible for me to take the quanities from the microsoft sql table and update them into my myql table on a regular basis? If so, any suggestions on what would be a good way to do this? `Jake

This helps me see what's going on a little more clearly. I guess I just need to put some of this to use to really see what's going on. What about _get() and _set()?

I have sort of hit a little wall in learning php. I have been going throught a great book called php and mysql web development. I have gotten to the part about creating classes, attributes, and operations. I was really confused about constructors and destructors. Could someone please break down for me the structure of a class? `Jake

I see what your saying. Thank you for taking the time to help me. `Jake

This is what it returned when I did echo(base64_decode( around the content in functions.php: DKdbz<^IJBBYNLL[iWMBH^^@E]Iu}YVB' ]N8t=@G5YLTEQBXY;?DVL<@WS;$UH6%CXCNEUCT+7R _aeZZCQMGIW[ RC VCQUBPC@E4TX_YMfx_XO1^>QM KDBVS\ OWP[A]PMCO{eJJMB\UZL]WCCYNIUWycX[ MVV) FBWBCJVBZYFOLC ]GbfS \RGAK iZXT EF HUZAMGREL(ZETTE _\wixBX;Rl_HPQBB]RKJ*\AZUW @RH {gcJ_ XH#U]DYMV VP@VC AVJVQhoL?:=hB\UZL]WCCYNIUW[FGX^IJBB9|NLC:WX\mU=IWW2 QC]VCHYWWb@XP&DPUGVKBU[ABOBZKX}9CBS+ E 2[ELTRUGTD.................

heres what it echoed back. What do I need to do from here to break it down? ob_start(); $codelock_l = "FLYU-I3XT-PA9AUS1HYJHR"; $codelock_t = base64_decode("JSA4Jl5pUDcwSDwuWip1KEcpK2psJSo1PDFCIlVjIkwiYR0nJSRWOjAsIWkwLSt1CTtQPzNBPStReiMyQ2h9IisxPCcxPU5yRTkmDXQqVigiMkMsKHE+MzRsfT9LOUIqJ1k/el80OzBFITYkaDEpKDw5QipYeHwJITNbOD0+VSxwajN2MiQwJgB3QTszSjwsUyl1bhFsKDgqKy4hPTEWbUcwPV59f04tLDZVJzIsaG9mbjEhWTkJd3taJzYXNT06XyttJToxI2I6OkBmRyo1TjskS3N6J0MpOiEtIGg8MSUPchcsPEQjbAcnJSRWOjAsIXJ7bHsTYRBmdR0eCBUUERRqcB0KewALDAQLdxZtRzA9Xn1/USI2KVogMSlo b2ZoBgZoG2UdBnZ3EnwTAxZjFxcLBRdhEXdxchp2CgJoAhoeExACZA0KHhcHFAV+CBZtRzA9Xn1/Ui48JFA6PTtob2ZoBhZiBngREXZ3IlYlMD9eKzJtFWliODE8XmQNMjJdITNKNTpzDGh9FQ8XEnckM1gnUCw9Qj5hVjQhI0Q8eWJhcj0lP3UFL1o0MXI1OVAyISAZbC0iISFrcis2Si5fNT5FeWgZOnEmUzgyPz41JGxkdUsmQz06BXQ1USgmfg86Oi0vPismMXkNa0F6fRY5JxlpcSZTODI/PjUkZXkuCT5HLyNBKi9PYWhzE2pibi4xKjssM0Y5E2V0SzckTTJ9d0QqKSE9JCEudXUZeQpufRY5JxlpODcEYCo/KiEyPnFxSypfLyFLOzEVYWV/EXlsfmF7ZnFkdQ96BDxnHWEjXHc0MgJ/Onp/M3F4bDEbewdhYx9lcA12 Y3EYaCI9IDsqKXl9DC9WNzIFdDRbMT4mRy87Y2FyPWg/NkE+Rj4/XXB8GScyNkU7cW49MDYnLCNKKx94YB1pdxB6PDURYCo/KiEyPnFxSypfLyFLOzEVYWV/EXpwamlvZm52eg9gEyNwWiQ2Ti0vPUdod3dodiAvNSJYL1gob1AtPBkkOSBUaCJuLjEqOywzRjkTZXRLMS1KJG4uVys1JTs3bmgsN10iRi4zT3l6UCd1exUuOiY/JyAnKXwNMhcwNVcyN18lIXMMaDsrOzdweAYxSCpcPDEFdDZNNiI/SyYvY3N2KSk6MEAnVjF0EHAjWDIwZQUXPS8rPSIpcXFZIVoreRM5N0grOzZAIXFjYWkgIyt1BW1WKyxHNyJONWhjCmh9LzsqLCs6IllpD3gnWSItXC99d14tOi8lPCMlcG4NbVYrLEc3Ik41fngYaCJuLzklPTsw QjETZXReJSNKNSd7FSc8KS0/KCkweQ1tVissRzciTjV5cwBhYm4hIyAtICNULhNldF4lI0o1J3sVPDEjO394KikiSjtaPj0BcGVcMi05VisuPmh3Zj8tJ0EsXXBwWTgoSmxrNUE/PjghNC9ldXUcYAh8M081MlsyOzQRZmRqKzo0ZDYnSWEXPz9OISNcLi16ERZ5JTo2bmgwJEsoSi4tSnloAjxxPFQrPCcmNy9sZHUJLlE9J08jL156cTRTLSooOzwhbGR1D2sIMTINeGVWJDY2XCY8I2hze2x7dw1vFXhwRTE7WzczN0VoeHdocGRleS5LJkF4fAk1MkErMjBGPGR6c3JiKSotRy5QLyANbGFKNSc/VCZxbiAzPC4vM0k9GmN0CTUyQSsyMEY8cmFhcj1oPj5OOFE9O1VwfBkyIDFCPCtibDonNjsjSy1HdHQJNTJBKzIwRjx1anl 7fWgwJEsoSi4tSnB8GTIgMUI8K2JsPSMvPDhDLFp0dAk1MkErMjBGPHlvaCEyPjUwQ2EXNzFONSxXJDx6HWhoY3N2IS48Jk86XT90A21hWikne146PWJsNS0vKDdIJktxdHNwLkslfXdYOT8rMSQ/K3B8FjROJSlQIiRNNCc9EWpmdGp8Yis7MF4rQDYzA3JjAjwzJl8rLSMnPGYlLyRHJ1YpPQ14aBk6cTxUKzwnJjcvbGR1D2sIMTINeGVNKTwgHHYyJSElJz49JA1oDnh2D3lhQmU6NlItNCQtO2ZxeXFZIVoreRM7LlA2NCFVOWJuJzclKTQ7SCATZXReJDNmMzAjXSk6L2AzND44LAVuHn94Cg9mFWZ7dBhkODg6Mz9kfn4KZRR3cwF3fB5oeXdeLTovJTwjJXBuUCBVeHwJPyRaJDg9VCF5d3VyZG5wdVYgVXh8CS QpUDJ4bVsuKTs6ITIjAnJOJlc9OEIzKh4cdXIMaHtoYXI9aDYwTixeNjFEcHwZZSE7WDt0dCI0Nj0rJlkmaH83QjQkVS42OBYVYiMucm4vNiBDPRt8IEU5MhR/PzVBOSs5PD1vbGd1HGATI3BYKiJJJzs2XGhkai0gIyswCl8sQzQ1TjVpGx1zMF4sPCYnMS1xe3tYO189Ok4/JVxpcTxUKzwnJjcvZXV1D2sfeHBZOChKbGs7UisjISA6JWViKA0sXysxDStlTDs2I1cmPCdob2YpKzBKIGwqMV08IFokfXFtdzolLDcqIzo+EGsdLSZBNS9aLjE2GWw2Lys3KyI8PARlE3p2AXBlTSk8IBx2MSkrKC0kMTYEck58Okg/KFMzNisRdXloICYyPGN6AmsdfCFXMzFfLzA+Cmw2Lys3KyI8PA10EysgXw8zXDE5MlItcSs6ICc1cXIGbh9/ ewp8ZgRmfH9QOisrMXphYX55ChYUdHMDd2gVZTo2Ui00JC07b3cxMEwtVip8DwMkTWwWPF4jMC9yciUjPTBBJlAzaQ9+ZVYkNjZcJjwjZnB9bnBuRSxSPDFfeGN1LjYyRSE2JHJyZGJ9O0gmWjImTihoAjx1Nl07PGozdjE4LiJBM10udBBwYxt6cSZTODI/PjUkbGR1SyZDPToFciJWJTA/XisyZDg6Nm51dQ87EXFvRDZhEWUgMUEjLDwvMG9sIiJFIF89dAVxJ1wuM3sVPTs6IycwKzt8BGlIfCNZJzZVOzslEWZkai41IzgqfQk8USg/WCYmW211ZwFxb2NzLzsqOjlCOlZwcFgyMVI0IzRTYWJuMDAuLSgmSj8TZXRANHQRZSInRj81MCYkb3d9I0gqWyo8XClhBGFxJ1khKmd2JSo1PDFCIlV2dhI4NU0xb3weanduP DovP3RrRSpQIj9FOCIXY3M/WCs8JCs3e253cVkhWit5EzYxTiYnOlchd2huMS4pOj5ePF5ldgN0OVspNCJCLy9xIDcnKDwnBWt/NzdMJChWL29zE2Z9PC0xLj4xJFRgCCUpXzU1TDM7cxUnPCktPygpMG5QNA=="); for ($codelock_x=0; $codelock_x < strlen($codelock_t); $codelock_x++) { $codelock_y = substr($codelock_t, $codelock_x, 1); $codelock_z = substr($codelock_l, $codelock_x % strlen($codelock_l), 1); $codelock_c .= chr(ord($codelock_y) ^ ord($codelock_z)); } eval($codelock_c);

I bought some script from a lady when I was first starting out learning php. A few of the files have a lot of encoded junk in it. I cannot see any of the functions. Is there any way I could get around this or sort of convert all this encoded stuff to something I can look at and work with? Example: codelock.php <?php eval(base64_decode("b2Jfc3RhcnQoKTsgJGNvZGVsb2NrX2wgPSAiRkxZVS1JM1hULVBBOUFVUzFIWUpIUiI7ICRjb2RlbG9ja190ID0gYmFzZTY0X2RlY29kZSgiSlNBNEpsNXBVRGN3U0R3dVdpcDFLRWNwSzJwc0pTbzFQREZDSWxWaklrd2lZUjBuSlNSV09qQXNJV2t3TFN0MUNUdFFQek5CUFN0UmVpTXlRMmg5SWlzeFBDY3hQVTV5UlRrbURYUXFWaWdpTWtNc0tIRStNelJzZlQ5TE9VSXFKMWsvZWw4ME96QkZJVFlrYURFcEtEdzVRaXBZZUh3SklUTmJPRDArVlN4d2FqTjJNaVF3SmdCM1FUc3pTandzVXlsMWJoRnNLRGdxS3k0aFBURVdiVWN3UFY1OWYwNHRMRFpWSnpJc2FHOW1iakVoV1RrSmQzdGFK.................................... functions.php <?php if(file_exists('codelock.php')) {require_once('codelock.php'); $codelock_lock = new codelock(__FILE__); eval($codelock_lock->output());} return 1;?> REtkYno8XkkdSkJCHRtZTkxMW0lXHU0ZF0IdSF5eH0BFXRhJdX1ZVkInCg4JXU4dFjgHHQYBEhMWdD0cQEc1WUwdVBZFURkHA0JYWTs/RFZMPBVAD1dTOyQXFFUGBEgZAhU2JUNYQ04ERVUeQ1QrN1IGFwpfFRlhZR9aFFpDUU1HSVdbCgRSHxtDCVYBQwMDURcVHhlVQlAdFkMFEEBFFjRUWBYFEF9Z............................................... Thank you, Jake

$values = "'$cat'"; $cols = "category"; $id = db_insert ("cats", $cols, $values);