SELECT*,MATCH(name) AGAINST ('"a 4" a4 a4* a-4* junkers' IN BOOLEAN MODE) as relevance FROM `mytable` WHERE MATCH(name) AGAINST ('"a 4" a4 a4* a-4* junkers' IN BOOLEAN MODE) HAVING relevance > 0.2 AND id > 0 AND qty >= 1 AND status != '%Sold%' AND (name like '%a4%' OR name like '%a-4%' or name like 'junkers')...
Skills: mysql programming, php, database, mysql administration
I have a query that is pulling data from multiple tables like this:
SELECT * FROM product, product_description, product_special WHERE product.product_id > 0 && product.product_id = product_description.product_id OR product.product_id = product_special.product_id ORDER BY date_added DESC LIMIT 0,100
I'm searching for a writer who knows guitars to create high quality content for a blog aimed at beginner to intermediate guitarists. Only submit your best work. You don't have to be Bonamassa, just a good writer who knows enough to write intelligently about guitars. If you are a great guitarist, so much the better.
I need a header graphic for my facebook page for retrogamerjapan.com based on my current header at retrogamerjapan.com. I like my current header graphic font and color and retro scanlines, but I think the overall design needs a little more pop. Maybe less little characters and more background stuff?
I need the definitive how to hook up your Famicom in the States article, complete with pictures and if you can, video. I'm going to put up a blog on retrogamerjapan.com soon that will answer a lot of the questions I get and this is a big one. I'd like to put the video on my youtube channel and link it to the article.
I need some changes to the product display page. I've included a jpeg of what I want.
Added 16 APR 2012, 21:08 PM ...
I'm looking for an English speaking php/mysql guru to help add cc transactions to an existing ecommerce site. The current php code is procedural and not pretty, but it works. I need a coder willing to resist the urge to recode everything and instead help make this current issue work.