Re: [PHP-DB] drop list inserts

2002-04-18 Thread Barry Rumsey
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

RE: [PHP-DB] drop list inserts

2002-04-18 Thread Gurhan Ozen
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 &#x

Re: [PHP-DB] drop list inserts

2002-04-18 Thread Christian Schneider
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_

RE: [PHP-DB] drop list inserts

2002-04-17 Thread Barry Rumsey
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

RE: [PHP-DB] drop list inserts

2002-04-17 Thread Gurhan Ozen
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 "

[PHP-DB] drop list inserts

2002-04-17 Thread Barry Rumsey
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