Breaking News: Grepper is joining You.com. Read the official announcement!

PHP MySQL Select PDO::query() Order By ASC DESC

Sensei answered on July 17, 2024 Popularity 4/10 Helpfulness 1/10

answer PHP MySQL Select PDO::query() Order By ASC DESC

PHP MySQL Select PDO::query() Order By ASC DESC

Comment

<?php
$sql = 'SELECT id, firstName, lastName, email, city, state FROM customers ORDER BY city ASC, state DESC';
foreach ($conn->query($sql) as $row) {
    print $row['id'] . "\t";
    print $row['firstName'] . "\t";
    print $row['lastName'] . "\n";
    print $row['email'] . "\n";
    print $row['city'] . "\n";
    print $row['state'] . "\n";
}
?>

Popularity 4/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: mysql pdo php select

Link to this answer
Share Copy Link

Contributed on Jul 17 2024

Sensei

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

PHP MySQL Select PDO::query() Order By ASC DESC

Contents

More Related Answers

PHP MySQL Select PDO::query() Order By ASC DESC

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.