A friend of my who is a programmer helped me only after I gave up on the
mailing answering me. So it is fix now. I had to the following...
// This is the actor query
$sql = "SELECT concat_ws(\" \", fname, lname)as actor FROM actormovie WHERE
title = '$title'";
$result = mysql_query($sql);
On Sat, 2002-06-15 at 05:31, Chuck Payne wrote:
...
> // 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 ($m
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 WHER
