使用双引号的MySQL SELECT在php中打印时遇到问题

Question

If anyone has any ideas on how to help me out with this, when I run it usually just creates a never ending table.

<?php

$link = mysql_connect('localhost', 'blah', 'blah') or die('Could not connect: ' . mysql_error());

mysql_select_db('blah') or die('Could not select database');

extract($_GET);

error_reporting(error_reporting() & ~E_NOTICE );

$query = "SELECT `city`.`month`,`city`.`cost`, `comcast`.`cost`, `electric`.`cost`, `city`.`cost` + `comcast`.`cost` + `electric`.`cost` AS \"Total\" FROM `city`, `comcast`, `electric`";



    echo "<table border = '1'>

          <tr>

          <th>Date of Bills</th>

          <th>City Bills</th>

          <th>Comcast Bills</th>

          <th>Electric Bills</th>

          <th>Total Bills</th>

          </tr>";



$dave= mysql_query($query) or die(mysql_error());



while ($row = mysql_fetch_array($dave,mysql_ASSOC)) {

        echo "<tr>";

        echo "<td>" . $row[`city`.`month`] . "</td>";

        echo "<td>" . $row[`city`.`cost`] . "</td>";

        echo "<td>" . $row[`comcast`.`cost`] . "</td>";

        echo "<td>" . $row[`electric`.`cost`] . "</td>";

        echo "<td>" . $row[`\"Total\"`] . "</td>";

        echo "</tr>";





    }







//SELECT `city`.`month`, `city`.`cost`+ `comcast`.`cost`+ `electric`.`cost` AS "Total" FROM `city`, `comcast`, `electric`

// Free resultset

mysql_free_result($result);



// Closing connection

mysql_close($link);

?> 

Answer 1

replace ` with ' when displaying data:

while ($row = mysql_fetch_array($dave,mysql_assoc)) {

    echo "<tr>";

    echo "<td>" . $row['month'] . "</td>";

    echo "<td>" . $row['costCity'] . "</td>";

    echo "<td>" . $row['costComcast'] . "</td>";

    echo "<td>" . $row['costElectric'] . "</td>";

    echo "<td>" . $row['Total'] . "</td>";

    echo "</tr>";
}

and change your query to:

$query = "SELECT `city`.`month`,`city`.`cost` as costCity, 
                 `comcast`.`cost` as costComcast, 
                 `electric`.`cost` as costElectric, 
                 `city`.`cost` + `comcast`.`cost` + `electric`.`cost` AS \"Total\" 
                  FROM `city`, `comcast`, `electric`";

Also I would look into JOINS and you are missing closing table tag </table>

Since you are selecting all data from 3 tables without using joins it multiples so if your tables contain 2 rows in each you get result 2*2*2 = 8.

NOTE: do not use mysql_* functions. Try using prepared statements PDO or MySQLi_*