Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 23-05-2009
Member
 
Join Date: Apr 2009
Posts: 40
WordPress SQL Query to retrieve data

Can anyone provide me the Wordpress SQL queries to retrieve data from the table i have created in my database, but before executing that i need to know how to write the code for the WordPress SQL Query does it require any special editor to write it, could we make changes to the already existing code.
Reply With Quote
  #2  
Old 23-05-2009
Member
 
Join Date: Dec 2008
Posts: 183
Re: WordPress SQL Query to retrieve data

WordPress is a state-of-the-art semantic personal publishing platform with a focus on aesthetics, web standards, and usability. Simply enter your SQL query and click ?Execute SQL?. If it?s a select, describe, show, or explain, an HTML table will be returned with your results.To execute an insert, update, delete, or alter, but after that, your fate is in your own hands. If it?s any other command that modifies data or structure, you?ll get a message about the number of rows affected.
Reply With Quote
  #3  
Old 23-05-2009
Member
 
Join Date: Jan 2006
Posts: 211
Re: WordPress SQL Query to retrieve data

I will suggest you to follow the steps given below this will help you to download the SQL executioner that will execute the SQL query.
  1. Download wp-sql-executioner-1.0.zip (v1.0)
  2. Unzip the file and upload wp-sql-executioner.php to your plugins directory:
    /path/to/wordpress/wp-content/plugins
  3. Activate the plugin (don?t forget!)
  4. Goto Manage > SQL Executioner
Reply With Quote
  #4  
Old 23-05-2009
Member
 
Join Date: Jan 2009
Posts: 143
Re: WordPress SQL Query to retrieve data

Following are the 5 wordpress SQL Query that are very important from the retrieving data from the database.
  • SELECT * FROM wp_users WHERE user_login = ?
  • SELECT post_date, post_name FROM wp_posts WHERE ID = 0
  • SELECT option_name, option_value FROM wp_options
  • SELECT * FROM wp_users
  • SELECT * FROM wp_categories WHERE 0=0
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "WordPress SQL Query to retrieve data"
Thread Thread Starter Forum Replies Last Post
Retrieve selected Data From a Table samualres Software Development 5 30-01-2010 10:04 AM
Problem to retrieve data from a datafile harakim Software Development 4 22-05-2009 12:22 PM
Way to retrieve the data from WD external hdd Sujit15 Hardware Peripherals 4 24-03-2009 06:05 PM
How to access and retrieve data from HDD ? Caden Hardware Peripherals 3 21-02-2009 06:22 PM
EasyPHP : retrieve data Yaropolk Software Development 2 22-11-2008 03:44 PM


All times are GMT +5.5. The time now is 11:37 AM.