Sorting SQL query with the submitting of a form

Question

I have a general understanding of what I would like to do but not sure how to write the SQL.

Users have the ability from changing the sort from ASC to DESC and increase the query limit from 5 to 10.

$result=$mysqli->query("SELECT * FROM table WHERE status = 3 ORDER BY name ASC LIMIT $start_from, 5");

the option box for asc/desc will end up being $sort_order the option box for limit will be $limita

I tried to write it like

$result = "SELECT * FROM wp_pod_tbl_bars WHERE status = 3";
 if(!empty($limita)){$result.="LIMIT $limita, 5";}
 if ($result = $mysqli->query($result)) { 
 while($row = $result->fetch_object()){

but the query ended up empty due to the query being split into different lines.

Any idea what I am doing wrong? ill post more code if needed but this is generally where my issue is.

Dipesh Parmar · Accepted Answer · 2013-03-23 08:16:46Z

1

Put space between status and LIMIT.

$result = "SELECT * FROM wp_pod_tbl_bars WHERE status = 3";
 if(!empty($limita)){$result.=" LIMIT '".$limita."', 5";}
                ---------------^

answered Mar 23, 2013 at 8:16

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

shayward Over a year ago

Wow that little space makes all the difference thanks! Have to wait 10 minutes to accept it as the answer. But I will!

shayward Over a year ago

Yes, I can't believe that space is what stopped it.

Collectives™ on Stack Overflow

Sorting SQL query with the submitting of a form

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related