troubleshooting Question

It can nonnect to database but i can not get the result

Avatar of teera
teera asked on
6 Comments3 Solutions323 ViewsLast Modified:
what wrong with it it can not show any result


$link = mysql_connect('', 'souser', 'sopass' , 'AOL');
if (!$link) {
   die('Could not connect: ' . mysql_error());

echo 'Connected successfully';

$result = mysql_query("SELECT Code, Name, OnHand FROM WHERE OnHand != 0)", $link;

while($row = mysql_fetch_row($result))
    $Code    = $row[0];
    $Name    = $row[1];
    $OnHand = $row[2];

    echo "Name :$Code<br>" .
         "Subject : $Name  <br>" .
         "Message : $OnHand <br><br>";


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros