[cyberfolli]

I am trying to figure out how to modify this section of code to make the featured listings random. I tried a couple of variations but I keep getting errors

Code:

// Add ORDER BY and LIMIT functions into the SQL
  $sql2 = $sql;

  // Make all featured listings come first
  $sql2.= ' ORDER BY ';

  if (!isset($search['seed']))
   $search['seed'] = 0;

  if (isset($search['order_by']) && $search['order_by'] != 'ANY' &&
     ($search['order_by'] == 'price' ||
     $search['order_by'] == 'date_added' || $search['order_by'] == 'bedrooms' ||
     $search['order_by'] == 'bathrooms')) 
   $sql2.= ' ' . $search['order_by'] . ' ';
  else
   $sql2.= ' featured, RAND(' . $search['seed'] . ') ';

  if (isset($search['order_by']) && $search['order_by'] != 'ANY' 
  && isset($search['order_by_type']) && $search['order_by_type'] != 'ANY' &&
  ($search['order_by_type'] == 'DESC' || $search['order_by_type'] == 'ASC' )) 
   $sql2.= $search['order_by_type'];

  $sql2.=  ' LIMIT ' . $results_page . ', ' . $conf['search_results'];

[alxkls]

what errors? sql or php errors?
post the errors
echo the complete sql query and see if something is wrong with it

[cyberfolli]

There are no errors .. i am asking how to change the sql statement to display random information

[alxkls]

in other words a list of random results? thats plainly sql:

Code:

select * from my_table order by rand( ) limit 10

[cyberfolli]

if I change this

Code:

 $sql2.= ' ORDER BY ';

to this

Code:

 $sql2.= ' ORDER BY RAND( ) LIMIT 10 ';

I get this error



Critical Error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'featured, RAND(0) LIMIT 0, 12' at line 1

[alxkls]

post the complete query

edit:
NOT

Code:

RAND(0)
//nor
RAND( )
//SIMPLY
RAND()

also when you put limit-just limit 12, not limit 0, 12