PHP: SQL Data in HTML table not getting ordered [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 4 months ago.

Improve this question

I am trying to order my data in two ways. When I click the link the table does not update.

HTML:

echo "<tr>";
echo "<table id='customers'>
<thead>
    <tr>            
        <th><a href='?orderBy=producto'> Producto</a></th>
        <th>Unidad</th>
        <th>Candidad Necesaria</th>
        <th>Precio Objetivo por Unidad</th>
        <th><a href='?orderBy=ctot_obj'>Valor Producto<a/></th>
        <th>Remover Entrada</th>
    </tr>
</thead>

PHP:

$orderBy = array('producto', 'ctot_obj');
$order = 'producto';
if (isset($_GET['orderBy']) && in_array($_GET['orderBy'], $orderBy)) {
    $order = $_GET['orderBy'];
}

$query_ord = $mysqli->query("SELECT * FROM busca ORDER BY '.$order'");

What I am doing wrong?

Scovetta · Accepted Answer · 2017-02-15 04:36:08Z

1

You have a typo:

$query_ord = $mysqli->query("SELECT * FROM busca ORDER BY '" . $order . "'");

answered Feb 15, 2017 at 4:36

Scovetta

3,1421 gold badge16 silver badges13 bronze badges

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

3 Comments

Rocko Over a year ago

Not working. If I echo the query seems legit but apparently the table does not get reorganized.

Scovetta Over a year ago

Run the query output against MySQL directly -- do you get correct output? If so, then could you edit your question and add a code snippet where you iterate through $query_ord and echo the rows/cols? Issue might be there.

Rocko Over a year ago

I fixed it. I had and early query that was creating an endless loop. Thanks!

mith · Accepted Answer · 2017-02-15 04:36:24Z

0

Remove . fron your sql query and try.

$query_ord = $mysqli->query("SELECT * FROM busca ORDER BY '{$order}'");

answered Feb 15, 2017 at 4:36

mith

1,7001 gold badge10 silver badges13 bronze badges

Comments

user3863196 · Accepted Answer · 2017-02-15 04:37:39Z

0

echo ' html code ';

in html code use " instead of '

use # in href or ./

echo '<tr><table id="customers">
    <thead>
    <tr>
    <th><a href="./?orderBy=producto"> Producto</a></th>
    <th>Unidad</th>
    <th>Candidad Necesaria</th>
    <th>Precio Objetivo por Unidad</th>
                <th><a href="?orderBy=ctot_obj">Valor Producto<a/></th>
                <th>Remover Entrada</th>
            </thead>

answered Feb 15, 2017 at 4:37

user3863196

Comments

Mayank Pandeyz · Accepted Answer · 2017-02-15 04:38:36Z

0

To achieve this make some changes in the code. Suppose your page name is details.php, so make following changes:

<a href='details.php?orderBy=producto'>

Now use this orderBy in your query by fetching its values in a variable like:

$orderBy = $_GET['orderBy'];

answered Feb 15, 2017 at 4:38

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Collectives™ on Stack Overflow

PHP: SQL Data in HTML table not getting ordered [closed]

4 Answers 4

3 Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Related