Ethan Rosenberg wrote:
Dear List -
I have a form. In one field, the customer types the name of a product.
The first seven(7) results of the MySQL query that the entry generates
should be displayed as a clickable drop down list.
How do I do it?
Thanks.
Ethan
MySQL 5.1 PHP 5.3.3-6 Linux [Debia
Dear List -
I have a form. In one field, the customer types the name of a
product. The first seven(7) results of the MySQL query that the
entry generates should be displayed as a clickable drop down list.
How do I do it?
Thanks.
Ethan
MySQL 5.1 PHP 5.3.3-6 Linux [Debian (sid)]
--
On Fri, Mar 24, 2006 at 04:19:10PM +, Alex Major wrote:
> Hi there.
> This isn't a major problem, more of a matter of aesthetics.
> Basically, I have a query which pulls a list of usernames from the database
> (based on their user level).
>
> These users should then listed in this fashion.
>
On 24 March 2006 16:40, Alex Major wrote:
> Thanks, works like a charm (had to make is -2 instead of -1
> as it added a
> space after each result). Hadn't thought of something so simple.
>
> On 24/3/06 16:22, "Bastien Koert" <[EMAIL PROTECTED]> wrote:
>
> > Build it up as a string and remove the
a at the end of the loop
>
> do { $sHTML .= ''.$administrators['username'].', ';}
> while ($administrators = mysql_fetch_assoc($administrators_result))
>
> $sHTML = substr($sHTML, 0, strlen($sHTML)-1);
>
> echo $sHTML;
>
> ?>
>
gt;
Bastien
From: Alex Major <[EMAIL PROTECTED]>
To:
Subject: [PHP-DB] Displaying results from a query properly.
Date: Fri, 24 Mar 2006 16:19:10 +
Hi there.
This isn't a major problem, more of a matter of aesthetics.
Basically, I have a query which pulls a list of usernames
Hi there.
This isn't a major problem, more of a matter of aesthetics.
Basically, I have a query which pulls a list of usernames from the database
(based on their user level).
These users should then listed in this fashion.
Administrators: allydm, alex, mike, dave
Moderators: big 'd', frank, will
Hello,
With some help from the mysql list, I've been able to get this query working
from the command line
SELECT *
FROM outings as o INNER JOIN pics AS p1 ON o.pic1_id=p1.pic_id
INNER JOIN pics AS p2 ON o.pic2_id=p2.pic_id
INNER JOIN pics AS p3 ON o.pic3_id=p3.pic_id
INNER JOIN pics AS p4 ON o.p
