PHP MySQL Select Query
Posted: Sun Apr 01, 2012 5:16 am
I am getting [syntax=php]Resource id #7[/syntax] from this query while i am trying to select the posts.
[syntax=php]
$email = mysql_real_escape_string($email);
$r = array();
$r = mysql_query("SELECT
id AS id,
url AS url,
url_key AS url_key,
date AS date,
email AS email
FROM urls WHERE email = '{$email}' ORDER BY date DESC");
while (($row = mysql_fetch_assoc($r)) !== false) {
$r[] = array(
'id' => $row['id'],
'url' => $row['url'],
'url_key' => $row['url_key'],
'date' => $row['date']
);
}
return $r;
[/syntax]
what is the porblem
[syntax=php]
$email = mysql_real_escape_string($email);
$r = array();
$r = mysql_query("SELECT
id AS id,
url AS url,
url_key AS url_key,
date AS date,
email AS email
FROM urls WHERE email = '{$email}' ORDER BY date DESC");
while (($row = mysql_fetch_assoc($r)) !== false) {
$r[] = array(
'id' => $row['id'],
'url' => $row['url'],
'url_key' => $row['url_key'],
'date' => $row['date']
);
}
return $r;
[/syntax]
what is the porblem