Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter theinchaij

    (@theinchaij)

    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

    Plugin Author Eli

    (@scheeeli)

    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

    Thread Starter theinchaij

    (@theinchaij)

    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

    Plugin Author Eli

    (@scheeeli)

    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

    Thread Starter theinchaij

    (@theinchaij)

    what is your email account?

    Plugin Author Eli

    (@scheeeli)

    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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Woocommerce i try to help myself get more knowledge on SQL but i doesn't work’ is closed to new replies.