Hello All, im writing a phone book program (TK) and im using MS access database for user deatils (fullname,phone,ext,mobile,e-mail) here is my "trouble" code: 

sub copy_entry 

{

$copy_text = $dude->get();
chomp($copy_text);

$queryHandle = $dbshop->prepare(" SELECT * FROM Department WHERE ( Ext
+  = '$copy_text' OR Mobile = '$copy_text' OR [E-Mail] = '$copy_text' 
+OR [Full Name] = '$copy_text' OR [Direct Number] = '$copy_text' ) ");
$queryHandle->execute()
             or die $DBI::errstr;

while (my @row = $queryHandle->fetchrow) {


$dude2->insert("end", $row[0]);
$dude3->insert("end", $row[1]);
$dude4->insert("end", $row[2]);
$dude5->insert("end", $row[3]);
$dude6->insert("end", $row[4]);
                        
                     }

$queryHandle->finish();

[download]
my probelm is when there are more then 2 table name a like (ex, full name = johnm, johnd) it will display it in the same table (row[0]) as follow : in Coulmn (Fullname) in the 1'st table row[0] will looke like : " johnm johnd". row1 will also display the ext number the same (Ext) "113 114" and so on... my question is how can i seperate them into 2 (or more in case of 3,4,5 names a like) seperate lines each user with his own details.

In reply to Perl TK by Aboveyou

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.