You would like to have the id for each row on your page?
In a form you add an
">
tag to each row (i.e. once in your loop). Note the brackets at rowid[]!
That's the way how you get an array named $rowid on the next page via
POST or GET (depending on your form method attribute).
Even better (i
could you provide the table schema please?
after all (apart from the fact that you may have conflicts with the
autoincrement of the id row) your table is not normalized! create
separate tables for albums *and* songs (and ...):
music_albums
album_songs
artists
album_artist (table resolving the
Is it possible to retrieve information form more than one table in one
single mysql_query?
I want to preform a query on one table and retrieve information from a
second table based on the results from the first table.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
E.g. I've got two tables (User and Rights) both contianing UserID, I
want to retrieve some UserID's from the Rights table and use those
UserID's the get the nickname of those users from the User table.
("SELECT UserID FROM Rights WHERE...")
("SELECT NickName FROM User WHERE...")
On Monday 22 April 2002 00:53, Prodoc wrote:
> E.g. I've got two tables (User and Rights) both contianing UserID, I
> want to retrieve some UserID's from the Rights table and use those
> UserID's the get the nickname of those users from the User table.
>
> ("SELECT UserID FROM Rights WHERE
Hello, folks, and I apologize in advance if I break any rules here. This is
my first post on this list and I couldn't find any archive to review
existing posts for the answer to this question.
I'm an advanced HTML/JavaScript/DHTML programmer with relational database
experience using FileMaker an
On Monday 22 April 2002 12:54, Vania Smrkovski wrote:
> Hello, folks, and I apologize in advance if I break any rules here. This
> is my first post on this list and I couldn't find any archive to review
> existing posts for the answer to this question.
http://www.php.net/mailing-lists.php
> a)
From: "Vania Smrkovski" <[EMAIL PROTECTED]>
> host with PHP and MySQL support.
>
> a) How would you change the following the automatically find the tables
and
> run through the iteration.
You should rtfm as php/mysql makes a lot of the torturous
VB/MS/Access methods very simple. All the function