IPB forum mysql expert

Biudžetas 501-1000 Eur
Sukurta: 2014-08-01
Baigiasi: 2014-08-08
Siūlo: Nėra
Apibūdinimas: We have an IPB installation using the same database as our wordpress website. Looking for a IPB experienced developer to write an external script and a mysql query that will search based on a keyword on both the wordpress posts table (wp_posts) and the forums topic table (forum_topics) and order results from BOTH tables at the same time (order by date for example).

We do not need a script that orders the result in PHP, because we have too many rows and getting all of the occurrences into the script will use a lot of memory, this is going to be paginated so we only show 10 results at a time.

We have tried joins but there is no relation between the two tables, we tried an outer join, but outer joins aren't supported through mysql. also union will not work since wp_posts and forum_topics don't have the same number of columns"

Budget: $50
Posted On: August 01, 2014 00:21 UTC
ID: 204343561
Category: Web Development > Web Programming
Skills: Array
Country: United States
click to apply

Darbo Tipas(ai):
  • CSS
  • PHP
Duomenų Bazė:
Operacinė Sistema: Linux
Siūlymų Skaičius: 0
Siūlosi Žinutės Kaina Trukmė Įvertinimas Informacija