I have recently taken on a project to convert an old shopping cart site (custom developed) to a modern SEO friendly site here is my problem the current site utilizes URL's like the below http://www.domain.com/page.php?id=XX i would like to convert…
I have a problem with my code. I am currently loading my list of accounts through a database and generating a table with Codeigniters library, table. $this->load->library('table'); $this->db->select('firstname, lastname, accountname, registerdate, birthdate, email'); $this->db->from('accounts'); $query = $this->db->get(); $template = array('table_open'…
help me understand why i am getting different COUNTS Query 1 SELECT Count(*) FROM `foo` WHERE `status_id` = 2 AND `updated_at` < Date(Now() - INTERVAL 1 day) AND `number` LIKE 'A390%' OR `number` LIKE 'A391%' OR `number` LIKE 'A392%' results…
First post on stackoverflow. I have been following this site for a long time, and usually find what im looking for. But this has me perplexed. Let me set the stage. I am developing a web driven program. I have…
I am geting data stored as ¥à¤¨à¥ à¤à¤°à¤¨à¥ in mysql . It works fine in localhost but in remote mysql (in plesk) it is not working. i have used the following: request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); in servlet and con=DriverManager.getConnection("jdbc:mysql://localhost:3306/projectkkm?useUnicode=yes&characterEncoding=UTF-8","root",""); in database connection…
I have a profile page where user can edit their profile, I have provided them a skill form where they can enter skill name & percentage of how much you are perfect in it like-> Skill1 percentage 86% Add more…
I'm hoping someone could help me with this problem. I have 2 table: Courses +------------+--------------+ | Field | Type | +------------+--------------+ | id | int(11) | | name | varchar(255) | +------------+--------------+ Files +------------+--------------+ | Field | Type | +------------+--------------+…
I am using Prestashop Related Product PRO plugin that is really helpful when it comes to show some random products from the same category but it is using default Prestashop ORDER BY RAND method and when I enable this method…
I am trying to rework an old implementation of osCommerce and re-introduce data from the old database to the new one. I exported the data from the old tables using phpMyAdmin. When I tried to import them to the new…
I want to run a php script every 5 minutes that processes some simple mysql queries to identify potential errors and in case an error is recorded as a database entry the php script sends out an email. From my…