500 errors mean the script couldn't complete, or failed to provide http headers to httpd. You are printing the correct header, so that's not the issue.

You have weak taint mode on, but you haven't detainted $Value. With warnings and strict on, the warnings from that will cause perl to not execute. Also, by using strict, you need to declare your variables lexical with my, or explicitly global with use vars . . .; or our. Again, that will prevent execution.

You are giving only one argument to DBI::connect. Maybe you just erased the $user and $passwd args before posting (wise!), but if they are missing in the real script the connection will fail.

You should also make sure that values fed to $sth are correctly quoted. You have attempted to do so with single quotes, and that might work for most $Values, but it is cleaner to use a placeholder, 

$sth = $dbh->prepare("SELECT * FROM stock WHERE name=?");
$dbh->execute($Value);

[download]

You should check to see if the database connection succeeds. Testing definedness or truth of $dbh is sufficient for that.

After Compline,
Zaxo

In reply to Re: Cannot run a simple script?help im new by Zaxo
in thread Cannot run a simple script?help im new by ginda

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.