Put single quotes around the strings in your sql statementS:
$sql2 = "SELECT id FROM store_name WHERE name = '".$name[$i]."'";
^ ^
if this does not help, print out the query strings.
Daniel McCullough wrote:
I get this error.
Unknown c
I get this error.
Unknown column 'B' in 'where clause'
From this code.
$sql = "SELECT * FROM store";
$result = mysql_query($sql) or die(mysql_error());
$store = mysql_fetch_array($result);
$count = mysql_num_rows($result);
$id = $store['id'];
$name = $store['name'];
$address = $store['address'];
2 matches
Mail list logo
