> > 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:
$result=
On Sun, 5 Sep 2004, Pete Holsberg wrote:
> I have to learn to keep a 3x5 card with my column
> headings nearby!!
>
> But having corrected that, I'm running into another
> problem.
CASE-SENSITIVITY, Dummy! ;-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://w
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'];
> }
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 t
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.
> > "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
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
> >
> &
MySQL docs 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] R
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 fr
"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 direct
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
> > >
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
12 matches
Mail list logo
