WordPress.org

Ready to get started?Download WordPress

Forums

ELI's SQL Admin Reports Shortcode and DB Backup
[resolved] Woocommerce i try to help myself get more knowledge on SQL but i doesn't work (7 posts)

  1. theinchaij
    Member
    Posted 1 year ago #

  2. theinchaij
    Member
    Posted 1 year ago #

    sorry for add wrong at link this from i start http://stackoverflow.com/questions/9878985/need-to-get-productdata-out-of-mysql-database and this it my website on report http://www.hi-phones.com/?p=1373

  3. Eli
    Member
    Plugin Author

    Posted 1 year ago #

    I'm not sure that I understand your english too well, sorry, but I think I understand you SQL...
    I think you want to try something like this:

    SELECT p.id, p.post_title, m.meta_key, m.meta_value
    (FROM wp_posts p
    INNER JOIN wp_postmeta m
    ON p.id = m.post_id)
    INNER JOIN wp_postmeta t
    ON p.id = t.post_id
    WHERE
    AND t.meta_key='_rentable' AND t.meta_value='yes'
    AND m.meta_key='_price'

    ... but I am not sure where to get the extra description that you want to add to the title. I would need to see your database to do more.

    Please let me know if you need more help. You can contact me directly on my blog or send email to: wordpress at ieonly dot com

  4. theinchaij
    Member
    Posted 1 year ago #

    here this my wp_posts database http://www.hi-phones.com/?p=1813
    and here this my wp_postmeta database http://www.hi-phones.com/?p=1815

  5. Eli
    Member
    Plugin Author

    Posted 1 year ago #

    Sorry, but that doesn't help much. those pages are really messy with all the HTML in the those table dumped onto them. It looks like the data you are looking for is in the post content which will be really hard to parse out for you needs. Maybe you would be happy with the whole content field though?

    This is looking like a real job though, not just a little free advise. If you want to bring me on-board this project you can contact me directly and provide a WP Admin login. Email me directly if interested:
    wordpress at ieonly dot com

    Aloha, Eli

  6. theinchaij
    Member
    Posted 1 year ago #

    what is your email account?

  7. Eli
    Member
    Plugin Author

    Posted 1 year ago #

    wordpress at ieonly dot com
    or you can leave a comment on my blog and I'll get back you directly.
    blog links in the plugin sidebar in your WP admin.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic