What?
So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's ...
Applies to:
Joomla CMS v2.5.11 (Joomla.org)
jComments v2.3.0 (JoomlaTune.com)
What?
Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. ...
... here and then just built on this.
Method #1
I got this first query from the awesome site that is StackOverflow:
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
Run this command against both databases ...
What?
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this.
How?
Taken from the best forum for programming Qs&As:
http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
... was created to run.
Related Link(s):
Elevated Program Shortcut without UAC Prompt
Avoid UAC prompts by using an elevated program launcher
StackOverflow: Need to elevate permissions ...
... DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases ...
... The example below demonstrates how to get these details and extract data from the database.
How?
Based on a script I found on StackOverflow. Not sure what version they were using so I modified ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.