[CI - Database] Select row where..

Please login or create account to add a snippet.

Follow @TagMyCode

Language: PHP

Posted by: Dylan Lopez

Added: Mar 5, 2018 9:12 AM

Tags: codeigniter database query

$sql = "SELECT * FROM `$table` WHERE `ASIN` = '$ASIN'";
$query = $this->db->query($sql);
$result = $query->row_array(); //return array
/*$row = $query->row(); //return 1 row
$row = $query->first_row(‘array’)
$row = $query->last_row(‘array’)
$row = $query->next_row(‘array’)
$row = $query->previous_row(‘array’
$row = $query->row_array(5); //If you want a specific row returned you can submit the row number as a digit in the first parameter:
*/