array list retrieved

[Anon]

Hello,

When I input CloneName like "novel", it should get lot of data retrievel. But I seemed to only get first CloneName and its releted fields.

My code like

$query = " Select * from Seq where CloneID = '$CloneID' ";

$result = safe_query ($query, $link);
if(!result) { die ("No such $query");
exit( ); }
if($row = mysql_fetch_array($result))
{

    echo ("<table border=1>");

   echo ("<tr aling=left>\n");
    echo ("<td width='300'>");    
    echo("CloneID: .$row["CloneID"];
    echo ("</td>");
    echo("</tr>");
    echo ("<tr aling=left>\n");
    echo ("<td width='300'>");
    echo ("5' sequence: " .$row["seq5"]);
    echo ("</td>");
    echo("</tr>");
    echo("<tr align=left>\n");
    echo ("<td width='300'>");
    echo ("3' sequence: " .$row["seq3"]);
    echo ("</td>");
   echo("</tr>");
    echo("</table>");

}

thanks,

HP

[junebug]

okay, first of all you can drop the exit() out of the first if statement. when you use the die function, the script dies at that point.

second, you also need to make it $result in the first if statement and not result.

third you need to loop your fetch results. you are only asking for one row of data. try this:

if(isset($result))
{
while($row = msyql_fetch_array($result))
{

echo ("<table border=1>");

echo ("<tr aling=left>\n");
echo ("<td width='300'>");
echo("CloneID: .$row["CloneID"];
echo ("</td>");
echo("</tr>");
echo ("<tr aling=left>\n");
echo ("<td width='300'>");
echo ("5' sequence: " .$row["seq5"]);
echo ("</td>");
echo("</tr>");
echo("<tr align=left>\n");
echo ("<td width='300'>");
echo ("3' sequence: " .$row["seq3"]);
echo ("</td>");
echo("</tr>");
echo("</table>");
}
}

give that a shot and see if it works.

[Anon]

Hi

Thank you so much. It works now. That is great!

I want to use CloneName (string) to retrieve data, generally people don't type exactly CloneName because of many reasons, so I want to use

Code following:

//

$query = " Select CloneID, AccNum, ImageNum, library, CloneName from
sequence where CloneName like '$CloneName' ";

//

Then retrieve data using previous code. I can retrieve data using CloneName='$CloneName' , but CloneName like '$CloneName' now working.

Do you have any suggestions?

HP

[Anon]

Hi,

Thank you so much. It works now. That is great!

I want to use CloneName (string) to retrieve data, generally people don't type exactly CloneName because of many reasons, so I want to use

Code following:

//
$query = " Select CloneID, AccNum, ImageNum, library, CloneName from
sequence where CloneName like '$CloneName' ";

//

Then retrieve data using previous code. I can retrieve data using CloneName='$CloneName' , it works. However, CloneName like '$CloneName' is not working.

Do you have any suggestions?

HP