I need to get a particular column ‘value’ where it has alot of characters looks like a short paragraph, now i want a string Pretest_Score=25 i.e., it should display 25 in my table. How could be this done?. Please kindly help me with exact sql query. SELECT TRIM(‘value’) FROM mdl_sample
Archive for the ‘Uncategorized’ Category
PHP,MySQL
January 23rd, 2011 
gansai I inserted a single link to database with a single field ‘addlink’, likewise i inserted again & again and now totally i have 5 rows. How can i get all the rows from database and update them. Please help with this. /*——————-Inserting working Successfully */ echo ‘<font size=”4px” face=”verdana”><b>Add a New Link</b></font><br><br>’; if($_SERVER['REQUEST_METHOD']==’POST’) { $add1 [...]
Posted in Uncategorized 
Tags: addlink, Auto, column style, Draft, error, font, form, input type text, link, query sql, server request, td id 
No Comments »PHP Object Based
October 27th, 2010 gansai I need a dynamic template file for the pictures that will be pulled from the database. a. I need a location for them to be stored and code that designates where to place the pictures that were uploaded or taken from facebook. This is going to be object based PHP and I want each module [...]
Posted in Uncategorized Tags: Auto, Draft, dynamic places, dynamic template, information, location, module, PHP, php file, template No Comments »Fckeditor Configuration File
August 15th, 2010 narayanvj The editor comes with a rich set of configurations that makes it possible to customize its appearance, features and behavior. The main configuration file is named “fckconfig.js“. You can find this file in the root of the FCKeditor installation folder.
Posted in Uncategorized, javascript, mysql, php Tags: fckeditor, javascript, mysql, PHP No Comments »Event Registration Joomla
August 8th, 2010 narayanvj Following is the link to list of components for Event Registration in Joomla. http://extensions.joomla.org/extensions/calendars-a-events/events-registration
Javascript Validation for uploading files
August 8th, 2010 narayanvj The below javascript funtion checks the browsing file. For example, If the uploading file should accept only excel and word documents like that, then in that scenario, we can use this function.
Posted in Uncategorized, free software/tools, javascript, php Tags: file, file type, javascript, PHP, validation No Comments »Joomla Podcast Suite
August 6th, 2010 narayanvj Podcast Suite. A component, module, and mambot designed to bring podcasting capabilities to Joomla. Support for iTunes.
Who is online PHP script
August 2nd, 2010 narayanvj We can find out who are online or logged in to the system. This also displayed as members active now at the footer of any site or in any login system. This is integrated in any login system of any site. We will try to learn how such a system works and display the names [...]
Posted in Uncategorized, ajax, free software/tools, mysql, php Tags: database, login, logout, mysql, online, PHP, session, who is online, whois No Comments »Oscommerce reference guide
July 28th, 2010 narayanvj Following is the link to Oscommerce basic. Reference PDF
Posted in Uncategorized, free software/tools, mysql, oscommerce, php Tags: mysql, oscommerce, PHP No Comments »selecting value from a 3tables
July 28th, 2010 harishkumar assume 6th class is a category assigned to a user 1 which is having three sub-categories maths,physics,chemistry. 7th class is also a category assigned to a user 2 which is having three sub-categories english,biology,science but when i need to display userids with their category names………but iam getting output+sub-categories of another category……. ex: 1 6th class [...]
