Hi,
I am working on a movie database I have two database that I am calling from
but the problem I am having when I ask it to go and fetch all the movies
with the same title, it stops and only shows one.
Here is a basic layout...
if($videoid) {
$result = mysql_query("SELECT * FROM library WHERE videoid=$videoid",$db);
$myrow = mysql_fetch_array($result);
// The Myrows
$title = $myrow[title];
$videoid = $myrow[videoid];
$catergory = $myrow[catergory];
$appraisal = $myrow[appraisal];
// Some where here it's not working.....
$sql = "SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title' ORDER by lname";
$result = mysql_query($sql);
print $sql;
$actor = "";
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= "<A HREF=''>" . $actor . "</A><BR>\n";
}
What am I doing working.
Chuck Payne
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
