Hi, There is a MySQL db I used for my program's index. For updates I open my tables like this;
id cat list
1 cat1 code1, code2, code3.....
2 cat2 code1, code2, code3....
I request list where the cat=cat1, it is OK but when I try to pair each of the code to the variables, but doesn't work.
$connection = mysql_connect("localhost") or die ("Can\'t connect with the SQL server!");
$query = "SELECT line FROM index WHERE cat='".$cat."'";
$result = mysql_query($query, $connection) or die("Error in query: $query." . mysql_error());
$splitter = ",";
$newresult = split($splitter,$result);