Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum
ASC');
if u're trying to use variables like $table in the query (which i
think u are), they need to be in double quotes : not single
quotes. so the line should be:
On Thu, 2 Sep 2004, Torsten Roehr wrote:
mysql_query() will return a result set. There are
different functions to extract the rows from it. I
would recommend mysql_fetch_assoc() - it returns an
associative array of the current row/record set where
the field names of your table become the
On Sun, 5 Sep 2004, Pete Holsberg wrote:
Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum ASC');
while ($row=mysql_fetch_assoc($result))
{
echo $row['lastname'].' '.$row['firstname'].' '.$row['housenum'].'
'.$row['street'];
}
and
On Sun, 5 Sep 2004, Pete Holsberg wrote:
blush I have to learn to keep a 3x5 card with my column
headings nearby!!
But having corrected that, I'm running into another
problem.
Additional blushing CASE-SENSITIVITY, Dummy! ;-) sigh
--
PHP Database Mailing List (http://www.php.net/)
To
On Fri, 3 Sep 2004, Hutchins, Richard wrote:
-Original Message-
From: Pete Holsberg [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 11:59 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Newbie Questions
On Thu, 2 Sep 2004, Torsten Roehr wrote:
I
SELECT firstname, lastname, address FROM TABLENAME ORDER BY lastname
ASC;
Use ASC or DESC to order your query results. When you
iterate over the result as Torsten indicated, everything
will be in the order you specify.
In the database table itself, right? Does it make more
sense to do
On Sat, 4 Sep 2004, Torsten Roehr wrote:
SELECT firstname, lastname, address FROM TABLENAME
ORDER BY lastname ASC;
Use ASC or DESC to order your query results. When you
iterate over the result as Torsten indicated,
everything will be in the order you specify.
In the database
On Thu, 2 Sep 2004, Torsten Roehr wrote:
I think I need just a little push in the right
direction. After I send the above SELECT command, how
do I get the result to appear on a web page?
mysql_query() will return a result set. There are
different functions to extract the rows from it. I
for all the information you'll ever need on sorting
and/or grouping results from a query.
Rich
-Original Message-
From: Pete Holsberg [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 11:59 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Newbie Questions
On Thu, 2 Sep
On Wed, 1 Sep 2004, Pete Holsberg wrote:
On Wed, 1 Sep 2004, Torsten Roehr wrote:
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I want to set up a directory with the following fields:
surname
firstname
spousename
housenumber
street
phone
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, 1 Sep 2004, Pete Holsberg wrote:
On Wed, 1 Sep 2004, Torsten Roehr wrote:
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I want to set up a directory with the following
On Wed, 1 Sep 2004, Torsten Roehr wrote:
Hi Peter, please see my comments below:
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm just getting started with PHP and MySQL (how do you say
that, my ess kew wll, my sequel, ???).
my ess kew wll is the correct
12 matches
Mail list logo