Jump to content

Search the Community

Showing results for tags 'MYSQL'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Welcome
    • Announcements & News
    • New Arrivals
  • Web Development
    • Programming
    • Database Development
    • Server Administration
    • Hosting & Domains
    • Frameworks
  • Web Design
    • HTML & CSS
    • Graphics & Multimedia
  • Desktop Discussion
    • Linux Development
    • Windows Development
    • Mac/Apple Development
    • Hardware Discussion
  • Marketing & Business
    • Advertising, Marketing, Monetization & Social Media
    • Search Engine Optimization & Traffic Building
    • Buy, Sell or Trade
  • Prodjex Web Development Applications, Tools and Plugins
    • IP.Board Applications and Plugins
    • Web Tools
  • The Developer Dump
    • General Chat


  • Community Calendar

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 16 results

  1. Recently a client buy a VPS at 1&1 and I moved the Worpress site from old shared hosting (Bluehost) to new VPS. The site is extremely slow and I don't know how to fix this meaning where to attack, if I should optimize something in Apache, if I should install some plugin to avoid this or something else so I need some advice. Some data around that WP: Database hold around 35k posts I have disable W3C Total Cache plugin since I think is miss configured and can slow down the site I have not using any image compressor like thimbthumb (this was installed in first but due to s
  2. An application I've been troubleshooting has had major performance issues last week. I spent a few hours on it banging my head against a wall. Finally after doing some research I found that a lot of the database tables were created years ago in the MyISAM storage engine. After reading further I saw that for this application at least, InnoDB made much more sense. I'm actually not sure why you would ever use MyISAM anymore really... The server itself was showing massive MySQL connections at any give time, 20k-30k! There were not near that many people online so I was confused as to what
  3. The simplest way of selecting random rows from the MySQL database is to use "ORDER BY RAND()" clause in the query. SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1; The problem with this method is that it is very slow when your tables contain thousands of records. I was wondering if you knew any workarounds to speed things up?
  4. A few years ago the free database system best known by developers was purchased by Oracle company, it continues for free, however I wonder if it is still considered free software?
  5. Can any one tell me how to add(sum) two columns from two different tables but from same database. please send me exact query if you know..
  6. I have a column within my MySQL table that holds city and states for records. The dataset looks like the following: Clay County, AL Cleburne County, AL Coffee County, AL Colbert County, AL Conecuh County, AL Coosa County, AL Covington County, AL I need to just select the state name for all of the records. Since I know this is not user input and the data is all clean/structured as above I can trim off what I don’t need with the following command: select right(trim(cityStateField), 2); This then returns the needed resu
  7. These are two different commands with different outputs when added to a SQL query. MySQL “in” command for example: select * from assets a left outer join assetInterests ai on a.id = ai.assetID where orgID = 2011 and deviceID in (11) and interestID IS NULL In the table I have the following deviceID’s: 11 11 11 11,9 The result set will only return the top 3. The 11,9 result will be missing. Why is that? 11 is in that column. The issue is that “in” I could say and deviceID in (1,3,11) and any column that had just the 1 or 3 or 11 will
  8. My server has a site that's getting a lot of traffic lately and I'm seeing some mysql errors coming up in the IP.Board logs. It says it's an error with mysql not the software. Anyone know how to fix the error: Error: 23 - Out of resources when opening file
  9. Is it important to close your database connection at the end of your PHP file? I assumed it closed as soon as the page was done executing, so what would be the benefit in including it in your code?
  10. I'm inserting into my MYSQL database via a PHP page. For some reason it keeps losing the formatting and line breaks. What do I need to change to retain these? It's inserting into a MEDIUMTEXT field. Current Code: mysql_query("INSERT INTO projects (UserID, Title, Description, CreateDate) VALUES ('$userid', '$ProjectName', '$ProjectDescription', '$Date')"); This data is coming from the page before where the user enters the data in a <textarea> field from a html form.
  11. I'm not sure what to call what I'm trying to do so hard to run a Google search on it. I have a spot where I want to assign team members to a project. There is an input box where I can type their names. As I start typing their name I would like it to query the users table and show possible results, then I can click their name and they are added, then I can start typing another persons name and add multiple people.
  12. I have a jQuery date picker that passes the date format dd-mm-yyyy to my page that inserts data into the database. My table tructure requires a date format of yyyy-mm-dd. Is there an easy way to change the date format in the jQuery Datepicker?
  13. My below code isn't returning data for <h1><?php echo($query['id']); ?><h1> What am I missing? <?php //Connect to the Database $host = localhost; $username = db_user; $password = 'pass'; $connect = mysql_connect($host,$username,$password); //Select the Database $db = 'db_pm'; mysql_select_db($db); //Query the needed data $query = "select id,userid,title,description from projects where id=1"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); ?> <link href="../assets/front.css" rel="stylesheet" type="text/css" /> <?php inclu
  14. This following will allow you to upload a .csv file via a web form then insert that data into a MYSQL database. I had a request for it this morning and so now that I have it created I figured I would share. Let me know if you see anything that would be an improvement. Step 1 - Create Web Form <form enctype="multipart/form-data" action="uploader.php" method="POST"> <input type="hidden" name="MAX_FILE_SIZE" value="100000" /> Choose a file to upload: <input name="uploadedfile" type="file" /><br /> <input type="submit" value="Upload File" /> </form>
  15. So I could do this in MSSQL, but how is this done in MYSQL? I data in field "order_items" like: 121x1 134x4 1001x2 163x1 What I want to do is select everything before the "x".
  16. I'm trying to figure out how to use this code, but it's not working right. This query works fine: $var1= $_POST['user']; $var2 = $_POST['order']; //Connect to the Database $host = localhost; $username = user; $password = pass; $connect = mysql_connect($host,$username,$password); //Select the Database $db = 'devwp'; mysql_select_db($db); //Query the Needed Data $query = 'select distinct pm.meta_value from wp_shopperpress_orders o inner join wp_posts p on left(o.order_items, instr(o.order_items, "x")-1) = p.id inner join wp_postmeta pm on p.id = pm.post_id'; $result = mysql_query($query
  • Create New...