<?php

//Define database connection

$dblink = mysql_connect("localhost","root","") or die("Could not connect");
mysql_select_db("sample") or die(mysql_error());

$query = mysql_query("select * from Customers");

while($row = mysql_fetch_array($query)) {
       
    $name = $row['CustomerName'];
    $cname= $row['ContactName'];
}

    echo '<div>' .$name. $cname. '</div>';
   
   
mysql_close($dblink);
?>

Check your table name if C is in uppercase or lowercase.


On Fri, Jul 26, 2013 at 4:01 PM, Andrew Nduati <nduatiandrew@gmail.com> wrote:
Looks like the same problem ('; } mysql_close($connection); ?>)


On Fri, Jul 26, 2013 at 3:31 PM, Eugene Maritim <kiprotich.maritim@gmail.com> wrote:
Ok! I just tweaked your code a little,
Update the code as suits you!

<?php

//Define database connection
$connection = mysql_connect('host', 'username', 'password');

//Select our database
if(!mysql_select_db('sample')) {
    echo 'Could not connect to the database';
    die();
}//if

$customers = mysql_query('select * from Customers', $connection);

while($profile = mysql_fetch_array($customers)) {
    echo $profile['CustomerName'] . ', ' . $profile['ContactName'];
    echo '<br/>';
}

mysql_close($connection);


On Fri, Jul 26, 2013 at 3:09 PM, Andrew Nduati <nduatiandrew@gmail.com> wrote:
Thanks for the response. The problem is still the same. I've just tried getting rid of the second echo but all I get is a blank screen.
And I've confirmed that the DB has records.


On Fri, Jul 26, 2013 at 1:00 PM, Eugene Maritim <kiprotich.maritim@gmail.com> wrote:
Hey!

Find edited code below:
    1. Swapped the order params of mysql_select
    2. Changed mysql_select.db to mysql_select_db

<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php


//SQL Part
$host="localhost";
$username="root";
$password="";



$conn= mysql_connect($host,$username,$password) or exit("Connection Error".mysql_error());

mysql_select_db('sample') or exit("Database not found");


//Data from the query is stored in $result
$result = mysql_query("SELECT * FROM profiles", $conn);


while($row = mysql_fetch_array($result))
  {
  echo $row['CustomerName'] . " " . $row['ContactName'];
  echo "<br>";
  }
  mysql_close($conn);
  ?>
</body>
</html>



On Fri, Jul 26, 2013 at 2:46 PM, Andrew Nduati <nduatiandrew@gmail.com> wrote:
Good Afternoon Skunks,
        Below is my PHP code that is meant to run an SQL Select query however it doesn't seem to be working. All I'm getting when I open it in the browser ("; } mysql_close($con); ?> ")
Please assist.
Kind regards.



<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php


//SQL Part
$host="localhost";
$username="root";
$password="*****";


$conn= mysql_connect($host,$username,$password) or exit("Connection Error".mysql_error());

mysql_select.db('sample') or exit("Database not found");

//Data from the query is stored in $result
$result = mysql_query($conn,"SELECT * FROM Customers");

while($row = mysql_fetch_array($result))
  {
  echo $row['CustomerName'] . " " . $row['ContactName'];
  echo "<br>";
  }
  mysql_close($conn);
  ?>
</body>
</html>

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--
Regards,

Yegon Victor | Web Specialist/Internet Consultant |