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);
$actor = "";
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= "<A HREF=''>" . $actor . "</A><BR>\n";
}
where you set $actor = "", it needs to be $actors, then the while loop
should look like this;
$actors = "";
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actors .= "<A HREF=''>" . $actor . "</A><BR>\n";
}
then when putting the info in the table, in the cast part you want to put
$actors and not $actor. What is happening is that $actor is being reset
every time you go through the loop.
Thanks anyway, but I felt no was going to help me, since no answer after a
day.
Chuck
On 6/15/02 10:42 PM, "Zak Greant" <[EMAIL PROTECTED]> wrote:
> 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 = mysql_fetch_array($result)) {
>> $actor = $myrow[actor];
>> $actor .= "<A HREF=''>" . $actor . "</A><BR>\n";
>>
>> }
>>
>> What am I doing working.
>
> Hi Chuck,
>
> What happens if you run the query in the mysql command line client?
---------------------------------------------------------------------
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
