Syntax Error?? HELP!!

[Jamez]

I'm trying to use a variable inside the command to query the sql DB, but for some reason it keeps erroring out like the variable wasn't put in.

	mysql_select_db($sqldb);
	$ccca = "Test Category";
	$query = "select * from prods where catname = ".$ccca."";
	$result = mysql_query($query);
	$num_results = mysql_num_rows($result);

I'm pretty sure it's just a simple syntax error? Anyone know a quick fix, thanks 🙂

[Kudose]

$ccca is a string. It's okay to not use single quotes around integers in queries, but not strings.

This should fix your problem.

mysql_select_db($sqldb);
    $ccca = "Test Category";
    $query = "select * from prods where catname = '".$ccca."'";
    $result = mysql_query($query);
    $num_results = mysql_num_rows($result);

[ritu]

If catname is a string then --- >
$query = "select * from prods where catname = '$ccca' ";
$result=mysql_query($query);

this would work.