将mysql字段值分配给PHP变量[关闭]

Question

I am trying to assign the value of the my below database field (sname) to a php variable (name).but I am getting below error.Can someone help

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or   T_VARIABLE or T_NUM_STRING in /home/a4363282/public_html/pune/upload/upload_file.php on line 6

include './connection.php';
$query = "select * from shops WHERE city='pune' AND Ref=1;
$row = mysql_query($query);
$name=$row['sname'];
echo $name;

Answer 1

Please update you're code to MySQLi or PDO.

<?php
include './connection.php';
$query = "select * from shops WHERE city='pune' AND Ref=1";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
  echo $row['sname'];
}
?>