学习如何从MYSQL中读取数据

Question

I'm trying to learn php and mysql, I was trying to read data from my database where i was following something online and encounter an error(s) here is my code

<?php
  include 'includes/conn.php';

   $query =sprintf("Select * from customer");
   $result = mysql_query($query);

   if (!$result) 
   {
   $message  ='from you see this then it's not connecting!'.mysql_error() ."
";
      $message .= 'everything' .$query;
      die($message);
   }   

    while ($customer = mysql_fetch_assoc($result))
    {
       echo $row['cust_id'];
       echo $row['fname'];
       echo $row['lname'];
       echo $row['gender'];
       echo $row['dob'];
    }
mysql_free_result($result);
?>

//this is where i was trying to make a connection with the database

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$db ='telmar_php';
$con = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);
?>

Answer 1

Replace

$message  ='from you see this then it's not connecting!'.mysql_error() ."
";

here your string is single quotation marks in it's is causing the problem

with

$message  ="from you see this then it's not connecting!".mysql_error() ."
";