y Rumsey <[EMAIL PROTECTED]>
Date: Thu, 18 Apr 2002 12:17:34 +0200
Subject: Re: [PHP-DB] drop list inserts
> Hi Barry,
>
> Barry Rumsey wrote:
> > $query_id = mysql_query("INSERT INTO music_album VALUES
> > (NULL, '$music_artist.id' ,'$album' ,NU
rry Rumsey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 7:35 PM
To: php-db list
Subject: RE: [PHP-DB] drop list inserts
The $music_artist.id is the id from the first page. ( database = music ,
table = music_artist id ). This is what I need, a drop down list of the
artists in table
Hi Barry,
Barry Rumsey wrote:
> $query_id = mysql_query("INSERT INTO music_album VALUES
> (NULL, '$music_artist.id' ,'$album' ,NULL ,NULL)");
> echo " $artist_name and $album has been added to the
>
> Could someone please point out what I'm doing wrong?
>
is the value of $music_
into the
table 'music_album' as $artist_id.
-Original Message-
From: Gurhan Ozen <[EMAIL PROTECTED]>
To: Barry Rumsey <[EMAIL PROTECTED]>, php-db list
Date: Wed, 17 Apr 2002 19:02:52 -0400
Subject: RE: [PHP-DB] drop list inserts
> Hi Barry,
> First of all,
> $quer
lto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 6:23 PM
To: php-db list
Subject: [PHP-DB] drop list inserts
I have the following to pages( just testing them at the moment ):
";
$getlist = mysql_query("SELECT * FROM music_artist ORDER BY
artist_name ASC");
echo "
I have the following to pages( just testing them at the moment ):
";
$getlist = mysql_query("SELECT * FROM music_artist ORDER BY
artist_name ASC");
echo " Artist Name : \n";
while ($row = mysql_fetch_array($getlist)) {
echo ''.$row["artist_name"]."\n";
}
echo " \n";
echo "Album Name : ";
echo