Basic PHP/MySQL job
$30 USD
Pagado a la entrega
Hi,
I have this code:
************************************************
foreach ($exploded_keywords as $value) {
$i++;
if ($i == "1") {
$first_sql_term = "(CASE WHEN name LIKE '%" . $value . "%' AND retailer = '" . $retailer . "' THEN 1 ELSE 0 END)";
$second_sql_term = "WHERE name LIKE '%" . $value . "%'";
}
if ($i != "1") {
$first_sql_term = "" . $first_sql_term . " + (CASE WHEN name LIKE '%" . $value . "%' AND retailer = '" . $retailer . "' THEN 1 ELSE 0 END)";
$second_sql_term = "" . $second_sql_term . " OR name LIKE '%" . $value . "%' ";
}
}
$sql = "SELECT *, (" . $first_sql_term . ") relevance FROM products " . $second_sql_term . " ORDER BY relevance DESC LIMIT 1";
$query = mysql_query($sql);
$row = mysql_fetch_array($query);
************************************************
This gives me the results I want, but because I have used a foreach statement I cannot order them depending on their relevance score. I need a freelancer who can get the same results but order them by their relevance score.
Nº del proyecto: #2599615
Sobre el proyecto
7 freelancers están ofertando un promedio de $30 por este trabajo
sir i am having an experience of 3+ in php mysql and i am quite sure that i can do this waiting for your response