
Untitled
By: a guest on
Jul 17th, 2012 | syntax:
None | size: 0.93 KB | hits: 14 | expires: Never
MySQL SELECT database entries with the same column value
+----+---------+--------------+
| ID | user_id | meta_key1 |
+----+---------+--------------+
| 1 | 1 | d |
| 2 | 1 | f |
| 3 | 1 | c |
| 4 | 2 | g |
| 5 | 3 | 1 |
| 6 | 3 | 2 |
| 7 | 4 | 4 |
| 8 | 4 | 5 |
| 9 | 4 | 5 |
| 10 | 4 | 5 |
+----+---------+--------------+
$query = mysql_query("SELECT * FROM table_name WHERE user_id='1'");
$row = mysql_fetch_assoc($query);
while($row){
return $row["meta_key1"];
}
d
d
f
c
while($row = mysql_fetch_assoc($query);){
echo $row["meta_key1"];
}
while( $row = mysql_fetch_assoc($query)){
echo $row["meta_key1"];
}
$return = array();
while( $row = mysql_fetch_assoc($query)){
$return[] = $row["meta_key1"];
}
return $return;