User Profile

Collapse

Profile Sidebar

Collapse
unlawfulpub
unlawfulpub
Last Activity: Dec 24 '06, 05:26 AM
Joined: Dec 13 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • unlawfulpub
    replied to how to increment character value
    in Perl
    -

    $dbh = DBI->connect('dbi:m ysql:dbname,use r, pass);
    #prepare and execute SQL statement
    $sqlstatement=" SELECT reg_id, category_id, category_name FROM table1 where category_id = \'$category_id\ ' ";
    $sth = $dbh->prepare($sqlst atement);
    $sth->execute ||
    die "Could not execute SQL statement ... maybe invalid?";

    print "<table border = 0>";...
    See more | Go to post

    Leave a comment:


  • unlawfulpub
    started a topic how to increment character value
    in Perl

    how to increment character value

    Sorry guys just wanted to learn. I have a database. When I do the search using mysql suppose i have 100 records I wanted to keep the first second ... in the loop to be retrain.
    like an integer you may use $count = $count + 1;
    then in the second round count value would be 2.
    In this case I wanted the character to retain the old value incrementally
    ex. first loop. kind = a
    second. kind = a , b
    3rd....
    See more | Go to post

  • unlawfulpub
    started a topic how to show all records
    in Perl

    how to show all records

    Hello guys,
    I have one database name using mysql it is like user registration. I have separated the table for personal information and diffirent table with the qualification also diff to
    country, industry, category, qualification and more...
    they are in separate table. I want to find a record with these condition
    country = usa
    industry = FMCG
    category = Administration
    qualification =CPA
    ...
    See more | Go to post
No activity results to display
Show More
Working...