Posted by J.O. Aho on 02/09/07 18:05
stjepko wrote:
> I have code like this one. And and need to ORDER by rednibr ASC. Please how?
> tnx
> --------------------------------------------------------------------------------------
> <?php
>
/* Modify query for ORDER */
$sqlpodartikli = "SELECT * FROM podartikli WHERE artiklid=".$row[id]." ORDER
by rednibr ASC";
> $result2 = mysql_query($sqlpodartikli);
> if($result2)
> {
> while($row2 = mysql_fetch_array($result2))
> {
> ?>
> <tr>
> <td><?php echo $row2[rednibr]; ?></td>
> <td><?php echo $row2[opis]; ?></td>
> <td><?php echo $row2[proizvodjac]; ?></td>
> <td><?php echo $row2[sifra]; ?></td>
> <td><?php echo $row2[cijena]; ?></td>
> </tr>
> ------------------------------------------------------------------------------------------------------
Take a couple of hours of sleep and continue work on your php-script when you
feel fresh again.
--
//Aho
[Back to original message]
|