Posted by Nancy on 02/27/06 03:03

"David Haynes" <david.haynes2@sympatico.ca> wrote in message
news:yXrMf.35896$XG1.23443@fe81.usenetserver.com...
> Nancy wrote:
>
> One thing that occurs to me is that the line:
> $data_listing = '<tr><td>' . $data_select . '</td>
> > <td>' . $count . '</td>
> > <td>' .
> $data_count_values['data_radius'] . '
> > mi.</td>
> > <td>' . $data_date_formatted .'</td></tr>';
>
> over-writes any previous value of $data_listing.
> Is this what you intended?

No. I want it to add to, not overwrite. Will $data_listing .= fix that?

> Suggestions:
> Why not make your queries more readable/maintainable?

This is an excellent suggestion, thank you very much David.

> $sql = <<< SQL
> SELECT
> data_query_no,
> data_query_id,
> data_store_no,
> data_count,
> data_return_code,
> data_return_message,
> data_select,
> data_query_date,
> data_zip4,
> data_radius
> FROM data_count_request
> WHERE data_store_no = '$store_no'
> SQL;
>
> $data_count_query = db_query($sql);
>
> -david-
>

[Back to original message]