jason310771

great thank you

OK I have tried various things and still can not get my head around it.. I am wanting to take the content of one field timestamp, time(), and convert it to a standard date format, yyyy-mm-dd 00:00:00 (Y-m-d H:i:s) and have this stored in another field where it current content is 0000-00-00 00:00:00 This query shows the correct results.. SELECT * FROM `table` WHERE `datetime` = '0000-00-00 00:00:00' and this query does not return any errors, but does not change any of the fields. return zero changes. UPDATE `table` SET `datetime` = date(`timestamp`) WHERE `datetime` = '0000-00-00 00:00:00' The two fields are setup like so.. timestamp is int(11) datetime datetime default content 0000-00-00 00:00:00 what am I doing wrong to cause the fields not to correctly update ?

I have been bashing my head all night and still can not figure this one out, I have removed all the font and other sizing code and still the header text is very much larger on a mobile device than that on the pc view. Everything else about the page seems perfect apart from the text. What can I be missing that is causing this to be bigger on the mobile? style3.css body { text-decoration: none; background-color: #8C8C8C; margin: 0; padding: 18px; } h1, h2, h3, h4, h5, h6 { margin: 0em 0em; font-size: 1.5em; } a, a:visited { text-decoration:underline; } a:hover { text-decoration:none; } h1 { color: #164365; } img { border: 0px; } .floatleft: { float: left; } .clear { clear:both; } #main { width:822px; margin:auto; } /* 739px + 83 */ #main-inner { padding:0 17px 5px 17px; border: 0px solid red; min-height:200px; background-color: #FFFFFF; background-image: url(../images/bg-main-bottom-822.....gif); background-repeat: no-repeat; background-position: center bottom; } #main-inner-left { border: 0px solid red; width: 650px; border-right:1px solid #C8C8C8; display:block; float:left; } #main-inner-right { width: 130px; display:block; border: 0px solid red; float:right; text-align:right; padding-top:10px; } #main-inner-right p { color:#164365; padding-right:0px; } #logo { width:822px; background-color:#310101; background-image: url(../images/bg-logo-top-822-burg.....gif); background-repeat: no-repeat; background-position: center top; border-bottom:0px solid #C8C8C8; border-bottom:1px solid #C8C8C8; } #belowMenu { height: 162px; background-color: #FFFFFF; border-bottom:1px solid #C8C8C8; padding:3px 0 3px 0; } div#navbar2 { padding-left: 1px; padding-top:10px; } div#navbar2 ul { margin: 0px; padding: 0px; color: #6F6F6F; white-space: nowrap; } div#navbar2 li { list-style-type: none; display: inline; } div#navbar2 li a { text-decoration: none; padding: 0 4px 0 4px; margin: 0px 1px 0px 1px; color: #0033CC; display:inline; float:left; width:72px; height:22px; background-image: url(../images/bg-button.gif); background-repeat: no-repeat; text-align:center; line-height:22px; } div#navbar2 li a:link { color: #0033CC; } div#navbar2 li a:visited { color: #0033CC; } div#navbar2 li a:hover { color: #6F6F6F; text-decoration:underline; } #footer { margin: 0 auto; clear: both; color:#FFFFFF; text-align: center; padding: 12px; line-height: 18px; width: 810px; } /* 727 */ #footer a:link, #footer a:visited { color: #FFFFFF; text-decoration: none; } #footer a:hover { color: #FFFFFF; text-decoration: underline; } .highlight { padding: 0px; margin: 0px 0px 0px 0px; color: #164365; text-decoration: none; } .highlight a, .highlight a:visited { color: #164365; text-decoration: none; text-indent: 0px; } .highlight a:hover { color: #6F6F6F; text-decoration: underline; text-indent: 0px; } .error{ color: #F00; } .success { color: green; } ul{ list-style: none; } .formField { margin: 5px 5px 3px; font-style: italic; } .formValue { margin: 0 10px 10px; } .formSubmit { margin: 10px 0 0 10px; padding: 0em; } styles3.css div { padding: 0em; margin: 0em; } hr.smallDivider { color: #EDB6B6; height: 0.063em; } /* brown = #A52A2A */ hr.smallDividerTwo { color: #EEEEEE; height: 0.063em; } /* brown = #A52A2A */ .itemDivider { height: 0.063em; border-top: 0.063em dashed #D5D5D5; } .indent { padding-left: 25em; } .center { text-align: center; } .wordwrap { white-space: pre-wrap; /* CSS3 */ white-space: -moz-pre-wrap; /* Firefox */ white-space: -pre-wrap; /* Opera <7 */ white-space: -o-pre-wrap; /* Opera 7 */ word-wrap: break-word; /* IE */ } .pageNumber a:link, .pageNumber a:visited, .pageNumber a:active { color: #ddd; } .pageNumber a:hover { color: #222; } html <!DOCTYPE html> <html> <head> <title>Home - - </title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="keywords" content=""> <meta name="description" content=""> <link href="style3.css" rel="stylesheet" type="text/css"> <link href="styles3.css" rel="stylesheet" type="text/css"> <meta name="ROBOTS" content="INDEX, FOLLOW"> </head> <body> <div id="main"> <div id="logo"> <div style="float:left; padding-top: 12px; padding-left: 1em; border: 0px solid red;"> <a href="index.php"><img height="83" src="../images/300w-150h.gif" alt="" style="display:block; float:left;"></a> </div> <div style="float:right; width: 530px; /*font-size: 1em;*/ text-align: justify; padding-top: 10px; padding-right: 1em; border: 0px solid orange; color: #bd832b;"> blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah blah </div> <div class="clear"></div> <div id="navbar2"> <ul> <li><a href="../0.php">0</a></li> <li><a href="../0.php">0</a></li> <li><a href="../0.php">0</a></li> </ul> </div> <div class="clear"></div> </div> <div class="clear"></div> <div id="main-inner"> <div id="main-inner-left"> <h1>Home</h1> </div> <div id="main-inner-right"><img style="margin-bottom: 20px;" width="0" src="../images/0.jpg" alt=""><br> <p class="highlight"><img style="vertical-align: middle;" src="../images/arrow-on-white.gif" alt="Email Contact"><a href="../contact.php">Email Contact</a></p> <br><br><br> <p style="">.</p> </div> <div class="clear"></div> </div> <div class="clear"></div> </div> </body> </html>

This would be my first app, I was hoping to create this for all phones. I setup a site for someone for their taxi firm, very basic to start due to small funding. But now they are after an app that can have the visitors location (with the users permission) included in the info sent with the request form they submitted. How easy would this be to do without a huge budget being needed to contract another company to code. There are a lot of app building software out that included things to find their location and all with a large price tag, "per year" ! I was looking for a one off payment if needed or a basic setup I could do given time to keep the cost down to a minimum. I still do not know if googleplay and the other charge to store the app ?

I am wanting to create a mobile app, can anyone suggest where I can get information and resources to help me get a basic app that I can learn from to allow me to expand it to a fully featured app. What I am wanting to get to is a basic layout and a basic contact form with the content sent to an email address or a database (mysqli). What is the code like, what can I use to generate the app file that visitors can download, and can I have the file accessable on my own site or does it have to be from googleplay or the like ? I have googled looking for information but only finding the ones that are charging to create and host the app. I wish to code and host it myself if possible. What code can I use, how does it actually work? I am basically looking for the absolute beginners guide to app making.

I see, but what if there are no results in $res, would... $obj = $res->fetch_object(); kick up an error ?

I have been for a few days not converting one of my sites so it uses mysqli from mysql. I have managed with the little help of google that i did find change most of the mysql to mysqli but now got a problem with mysql_results. this is my original code... $res = db_query($mysqli, $sql); if(@$res->num_rows && @mysql_result($res, 0 ,'verified') == "Yes" && @mysql_result($res, 0 ,'suspended') == "No") { if(@mysql_result($res, 0 ,'changeofpasswordcode') != "") { $randomcode = @mysql_result($res, 0 ,'changeofpasswordcode'); } else { $randomcode = createPasswordResetCode(); } // do something } but when i changed it to what i thought it should be i am getting errors... $res = db_query($mysqli, $sql); if($res->num_rows && $res->fetch_object()->verified == "Yes" && $res->fetch_object()->suspended == "No") { if($res->fetch_object()->changeofpasswordcode != "") { $randomcode = $res->fetch_object()->changeofpasswordcode; } else { $randomcode = createPasswordResetCode(); } // do something } the errors are... Trying to get property of non-object on this line... $res->fetch_object()->suspended == "No") { can anyone see what i might be doing wrong to getting the data from the single row from the database ?

SELECT `b`.`ownerRecentCommentDate`, `ic`.`itemid`, `ic`.`userid` AS `poster`, `ic`.`emailNotified`, `i`.`userid` AS `itemOwner`, `u`.`fullname` AS `ownerName`, COUNT(`ic`.`id`) AS `totalCount` FROM `itemComments2` AS `ic` LEFT JOIN `items` AS `i` ON `i`.`itemid` = `ic`.`itemid` LEFT JOIN `users` AS `u` ON `u`.`userid` = `i`.`userid` LEFT JOIN ( SELECT `a`.`itemid`, `a`.`userid`, MAX(`a`.`dateAdded`) AS `ownerRecentCommentDate` FROM `itemComments2` AS `a` LEFT JOIN `items` AS `b` ON `b`.`itemid` = `a`.`itemid` WHERE `a`.`userid` = `b`.`userid` GROUP BY `a`.`itemid` ) AS `b` ON `b`.`itemid` = `ic`.`itemid` WHERE `ic`.`userid` != `i`.`userid` AND `ic`.`dateAdded` > `b`.`ownerRecentCommentDate` GROUP BY `itemOwner` please can this be verified that I have it correct, I believe I have done it. It is returning the result for the only item owner that has a comment. I think getting the item owner query done first then having a separate one for other users that are part of the conversation would be easier.

WOW I have almost done it.... SELECT `b`.`ownerRecentCommentDate`, `ic`.`itemid`, `ic`.`userid` AS `poster`, `ic`.`emailNotified`, `i`.`userid` AS `itemOwner`, `u`.`fullname` AS `ownerName`, COUNT(`ic`.`id`) AS `totalCount` FROM `itemComments2` AS `ic` LEFT JOIN `items` AS `i` ON `i`.`itemid` = `ic`.`itemid` LEFT JOIN `users` AS `u` ON `u`.`userid` = `i`.`userid` LEFT JOIN ( SELECT `a`.`itemid`, `a`.`userid`, MAX(`a`.`dateAdded`) AS `ownerRecentCommentDate` FROM `itemComments2` AS `a` LEFT JOIN `items` AS `b` ON `b`.`itemid` = `a`.`itemid` WHERE `a`.`userid` = `b`.`userid` GROUP BY `a`.`itemid` ) AS `b` ON `b`.`itemid` = `ic`.`itemid` WHERE `ic`.`userid` != `i`.`userid` GROUP BY `itemOwner` the only thing is that it is still counting all comments for the item and not those posted after the owner have last posted. will keep on it, unless someone can spot what i have missed.

this is a complex one. ok i have been playing around all day! I have now got this, which returns part of the results needed apart from it returning all of the messages in the 'count' SELECT `b`.`ownerRecentCommentDate`, `ic`.`itemid`, `ic`.`userid` AS `poster`, `ic`.`emailNotified`, `i`.`userid` AS `itemOwner`, `u`.`fullname` AS `ownerName`, COUNT(`ic`.`id`) AS `totalCount` FROM `itemComments2` AS `ic` LEFT JOIN `items` AS `i` ON `i`.`itemid` = `ic`.`itemid` LEFT JOIN `users` AS `u` ON `u`.`userid` = `i`.`userid` LEFT JOIN ( SELECT `a`.`itemid`, `a`.`userid`, MAX(`a`.`dateAdded`) AS `ownerRecentCommentDate` FROM `itemComments2` AS `a` GROUP BY `itemid` ) AS `b` ON `b`.`itemid` = `ic`.`itemid` WHERE `ic`.`userid` != `i`.`userid` GROUP BY `itemOwner` my way of thinking is to get the most recent date that the 'owner' of the of the item made a comment and only counting the comments after this date is any. then this will return all comments that have been made after the owner made a comment on their items. but my query so far returns the date of the most recent comment no matter who made it. how do i get the most recent date the owner made a comment in that item. then use this date to only count the messages made after it.

I am still lost with how to ask what I am after. But giving you more information about what I will do with the results may help out. I wish to have an email sent out each day to notify each user (seller or not) of any comments made. So if userA adds an item (item1) and then userB asks a question in the comments, then userA has a message waiting, if userA has not read this yet and userC asks another question then userA has two waiting for them, and one message for userB. When the seller opens the comments it sets the `read` to '1' so we know he has read it! The basic results I would like is the userid of each user that has replies to read, and the total number of replies from other users. EDIT: thinking about it, there is not an easy way to find out if the other users have read their own messages, so think i will leave this part out of the confusion. all that is really needed is the userid of all users that have messages (read or not) and the total number of messages. nut not the messages that they posted themselves.

I have tried to do this myself yesterday and again this morning but still unable to get the right results returned. CREATE TABLE IF NOT EXISTS `itemComments` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `dateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `itemid` text NOT NULL, `userid` text NOT NULL COMMENT 'comment author', `comment` text NOT NULL, `ownerRead` tinyint(1) NOT NULL DEFAULT '0', `emailNotified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `reportedby` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ; -- -- Dumping data for table `itemComments` -- INSERT INTO `itemComments` (`id`, `dateAdded`, `itemid`, `userid`, `comment`, `ownerRead`, `emailNotified`, `reportedby`) VALUES (74, '2012-11-16 23:39:22', '383', 'ABC4EF', 'Great for parties and disco\\''s too!!!', 0, '0000-00-00 00:00:00', ''), (88, '2012-12-08 09:46:41', '383', '1', '1', 0, '0000-00-00 00:00:00', ''), (89, '2012-12-08 09:47:48', '383', '100', '2', 0, '0000-00-00 00:00:00', ''); this is what i came up with yesterday.. SELECT `ic`.`id`, `ic`.`userid`, `io`.`fullname` AS `toFullname`, `io`.`email` AS `toEmail`, COUNT( * ) AS `totalCount` FROM `itemComments` AS `ic` LEFT JOIN `users` AS `io` ON `io`.`userid` = `ic`.`userid` WHERE `ic`.`ownerRead` =0 GROUP BY `ic`.`userid` and this morning.. SELECT `ic`.`id`, `ic`.`userid`, `io`.`fullname` AS `toFullname`, `io`.`email` AS `toEmail`, COUNT( * ) AS `totalCount` FROM `itemComments` AS `ic` LEFT JOIN `users` AS `io` ON `io`.`userid` = `ic`.`userid` LEFT JOIN `items` AS `i` ON `i`.`itemid` = `ic`.`itemid` WHERE `ic`.`ownerRead` = 0 AND `ic`.`userid` != `i`.`userid` GROUP BY `ic`.`userid` but it is not showing the results for the comments added by other users for a users items. And I just tried this, which seems to show the correct number of comments for that user, but it is not showing the other users that is part of the conversation. SELECT `ic`.`id`, `ic`.`userid` AS `commentOwner`, `i`.`userid` AS `itemOwner`, `io`.`email` AS `itemOwnerEmail`, `io`.`fullname` AS `itemOwnerFullname`, `io`.`shopName` AS `itemOwnerShopName`, COUNT( * ) AS `totalCount` FROM `itemComments` AS `ic` LEFT JOIN `items` AS `i` ON `i`.`itemid` = `ic`.`itemid` LEFT JOIN `users` AS `io` ON `i`.`userid` = `io`.`userid` WHERE `ic`.`ownerRead` = 0 AND `ic`.`userid` != `io`.`userid` GROUP BY `i`.`userid` basically what i am after is to have results showing each userid, their email and shopName, and how many comments in total for all of their items. but not where they have commented on their own item.

Great thank you,

How do I get the following results.. The userid and the total number of unread messages they have. CREATE TABLE IF NOT EXISTS `privateMessages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `convo_id` int(11) NOT NULL DEFAULT '0', `sent_by` text NOT NULL, `sent_to` text NOT NULL, `subject` varchar(255) NOT NULL, `message` text NOT NULL, `sent_to_deleted` tinyint(1) NOT NULL DEFAULT '0', `sent_by_deleted` tinyint(1) NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `timestamp` datetime NOT NULL, `read` int(11) NOT NULL DEFAULT '0', `emailNotified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `reportedby` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ; -- -- Dumping data for table `privateMessages` -- INSERT INTO `privateMessages` (`id`, `convo_id`, `sent_by`, `sent_to`, `subject`, `message`, `sent_to_deleted`, `sent_by_deleted`, `status`, `timestamp`, `read`, `emailNotified`, `reportedby`) VALUES (84, 83, 'ABC4EF', '1', '111', '22222', 0, 0, 0, '2012-12-07 16:18:50', 0, '0000-00-00 00:00:00', ''), (83, 83, '1', 'ABC4EF', '111', '111', 0, 0, 0, '2012-12-07 16:09:23', 0, '0000-00-00 00:00:00', '');

Wow thank you so much Barand, I shall see if I can learn from this query should I need to use something similar in the future. I have only really used the basic function and this one is way over my head at the moment. Thank again for your help on this. Much appreciated.

ah i think i have worked out where i might be going wrong, it is showing the most recent message of userid '100' in each itemcomment, what i was after is the most recent comment no matter whose comment it was, where userid 100 has taken part in the convosations of that item. i have re-read this over and over before sending to make sure i am explaining this right.

this is getting rather frustrating... lol ok here are all the tables that i have.... could be something i missed out somethere... CREATE TABLE IF NOT EXISTS `users` ( `userid` bigint(20) NOT NULL AUTO_INCREMENT, `account_type` varchar(20) NOT NULL DEFAULT 'user', `banned` char(3) NOT NULL DEFAULT 'No', `shopName` varchar(200) NOT NULL, `fullname` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `postcode` varchar(10) NOT NULL, `password` varchar(50) NOT NULL, `verified` varchar(3) NOT NULL DEFAULT 'No', `suspended` varchar(3) NOT NULL DEFAULT 'No', `verifyCode` varchar(32) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=206 ; -- -- Dumping data for table `users` -- INSERT INTO `users` (`userid`, `account_type`, `banned`, `shopName`, `fullname`, `email`, `postcode`, `password`, `verified`, `suspended`, `verifyCode`) VALUES (101, 'admin', 'No', 'bits', 'emma', 'emma@test.com', 'abc', '', 'Yes', 'No', ''), (100, 'Gadmin', 'No', 'Jason', 'Jason', 'jason@test.com', 'abc', '', 'Yes', 'No', ''), (163, 'user', 'No', 'James', 'James', 'james@test.com', 'abc', '', 'Yes', 'No', ''), (204, 'Gadmin', 'No', 'simons', 'simon', 'simon@test.com', 'abc', '', 'Yes', 'No', ''); CREATE TABLE IF NOT EXISTS `comments` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `dateAdded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `itemid` bigint(20) NOT NULL, `userid` bigint(20) NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ; -- -- Dumping data for table `comments` -- INSERT INTO `comments` (`id`, `dateAdded`, `itemid`, `userid`, `comment`) VALUES (65, '2012-11-02 16:05:59', 349, 101, 'u101 emma i349 c1'), (66, '2012-11-02 16:06:06', 349, 101, 'u101 emma i349 c2'), (64, '2012-11-02 15:55:33', 351, 204, 'i351 u204 simon c2'), (63, '2012-11-02 15:55:21', 351, 204, 'i351 u204 simon c1'), (62, '2012-11-02 15:52:39', 380, 204, 'i380 u204 simon c2'), (60, '2012-11-02 15:50:54', 380, 100, 'i380 u100 jason@test.com c2'), (61, '2012-11-02 15:52:30', 380, 204, 'i380 u204 simon c1'), (59, '2012-11-02 15:50:39', 380, 100, 'i380 u100 jason@test.com c1 e2'), (67, '2012-11-02 16:07:36', 345, 101, 'u101 emma i345 c1'), (68, '2012-11-02 22:04:42', 345, 100, 'lkk'), (69, '2012-11-02 22:07:14', 368, 163, 'jjjjjjjjjjj'), (70, '2012-11-02 22:08:16', 368, 100, 'jasontest'), (71, '2012-11-03 12:28:17', 345, 100, 'gfhjgfhj'), (72, '2012-11-03 12:29:16', 345, 100, '1');

This is what is shown on my page based on the last query. They click on a click to show/hide the rest of the comments and the section below it opens up. I have placed *** *** to show these areas. The first two show correctly. But the last one does not show the correct recent comment, which should be showing... i380 u204 simon c2 by simon on 2012-11-02 15:52:39 report it is currently showing the 'second post' for that item. View Item Comments i345 u100 4'' title' 1 by Jason on 2012-11-03 12:29:16 report click to show/hide aditional comments *** 1 by Jason on 2012-11-03 12:29:16 report gfhjgfhj by Jason on 2012-11-03 12:28:17 report lkk by Jason on 2012-11-02 22:04:42 report u101 emma i345 c1 by emma on 2012-11-02 16:07:36 report *** i368 u100 test t testt test jasontest by Jason on 2012-11-02 22:08:16 report click to show/hide aditional comments *** jasontest by Jason on 2012-11-02 22:08:16 report jjjjjjjjjjj by James on 2012-11-02 22:07:14 report *** i380 u100 test t testt test i380 u100 jason@test.com c2 by Jason on 2012-11-02 15:50:54 report click to show/hide aditional comments *** i380 u204 simon c2 by simon on 2012-11-02 15:52:39 report i380 u204 simon c1 by simon on 2012-11-02 15:52:30 report i380 u100 jason@test.com c2 by Jason on 2012-11-02 15:50:54 report i380 u100 jason@test.com c1 e2 by Jason on 2012-11-02 15:50:39 report

This still seems to return the same results with the last one in the list not being the latest comment in that item-Comment-Group

Hey, Thanks, I just tried the query you gave but this did not work for me. The results are not in date order. I know that the second query works just how it should, so think i should use that as a bases for the first query i need, which needs to get the most recent comment for each of the item convasations that the logged in user has taken part in. so I thinjk what I am after is a way to use the second query but only return one of each itemid where the dateAdded is the most recent date.

I can not seem to get the first query to return the results in 'dateAdded' order. I am after the most recent result in each group to be returned. It seems that the grouping is done in a different way than I expected it to be done in. I guess what I am after is the same as my second query, but them to have them grouped after the ORDER BY `c`.`dateAdded` DESC not before, which is what I think is happening? Can someone give me some clues as to why this might be? or a better solution. SELECT `c`.`id`, `c`.`dateAdded`, `c`.`itemid`, `c`.`comment`, `i`.`userid` AS `itemOwner`, `i`.`title`, `c`.`userid` AS `posterId`, `poster`.`fullname` AS `posterName` FROM `comments` as `c` LEFT JOIN `items` as `i` ON `i`.`itemid` = `c`.`itemid` LEFT JOIN `users` as `poster` ON `poster`.`userid` = `c`.`userid` WHERE `c`.`userid` = '" . mysql_real_escape_string($_SESSION['user']['userid']) . "' GROUP BY `c`.`itemid` ORDER BY `c`.`dateAdded` DESC The second one returns the results as expected, in dateAdded order. SELECT `c`.`id`, `c`.`dateAdded`, `c`.`itemid`, `c`.`comment`, `i`.`userid` AS `itemOwner`, `i`.`title`, `c`.`userid` AS `posterId`, `poster`.`fullname` AS `posterName` FROM `comments` as `c` LEFT JOIN `items` as `i` ON `i`.`itemid` = `c`.`itemid` LEFT JOIN `users` as `poster` ON `poster`.`userid` = `c`.`userid` WHERE `c`.`itemid` = '" . $getCommentTitle['itemid'] . "' ORDER BY `c`.`dateAdded` DESC

I have once or twice seen some PHP site code in the past that you needed a unlock code to use it and the code was completely unreadable. Can anyone suggest how I could do this to my own code ? Any sites that offer this service or software that I can buy to convert my code to this protected format.

We have a custom made shopping cart which is outdated and just not performing well. We have decided to opt for one of the free carts and wondered which one would allow us to import the excel file we have of our product titles, descriptions and prices, alone with the image file name of the products. There are 1000's and this would take months if not years for myself to do. Or very expensive to get a bank of people to entering it manually!! Any suggestions ?

http://blog.silktide.com/wp-content/uploads/2011/05/homepage.jpg

Cookies are not my strong point and I by choice do not use them. But due to the new laws about cookies and that we have to inform visitors before they continue if they consent to having a cookie stored on their pc's or not I need to find a way to stop them being stored but allow for visitors that do. What method or methods could I use to do this without completely removing the Google Analytics. Has anyone got any sites with instruction on how this could be done for a begininer.