I forgot to mention there will likely be more than the one "file" that
relates to a task.
-----Original Message-----
From: Bruce Levick
Sent: Friday, January 10, 2003 2:40 PM
To: php-db@lists.php.net
Subject: Relationship or not.
I have a bit of a challenge on and only being a newbie I will need to
call on some experienced PHP'ers.
I have two tables in a databse. "Tasks" and "Files". They relate to each
other via Tasks.ID and Files.FID.
I have successfully created an uploading form which adds images to a
directory and records the files details into the "files" table. So I can
now display the results If I need to from the "files" table.
My challenge is this.
I have created a Result set which displays all the "Tasks". This
displays through a repeated row and so on.
What I need to do is some sort of an if statement in each task display.
If (there are "files.fid" that relate to this "tasks.ID"){
Display results !!! //Calls on some HTML/PHP and attatchs "file" info to
a generic image to click on. }
Else {
Display Nothing !!!
}
So to put it simple. I need to display all the tasks (got that) and also
the file info that realtes to each task. I am unsure of how to code this
relational stuff. A bit out of my reach at the moment.
Cheers
Bruce
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
