Re: Problem with PHP, but I know it MySQL

2002-06-16 Thread Zak Greant
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 ($myrow =

Re: Problem with PHP, but I know it MySQL

2002-06-16 Thread Chuck \PUP\ Payne
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);

Problem with PHP, but I know it MySQL

2002-06-14 Thread Chuck Payne
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