Helpful Information
Category: SQL
SQL -> Array


Im trying to get some results from a DB cell into an array.

Table name = stores

Cell 1 = Employee Number
Cell 2 = Stores

Cell 2 will contain something like 1 | 2 | 3 | 4 and I want it to output into an array when I search on cell 1..

Any ideas folks?


If you are wanting to make the value into array of numbers then try this:


// Assume $result is your mysql_fetch_assoc() array..

$result['cell_2'] = explode('|', $result['cell_2']);


privacy (GDPR)