1
PHP / explode, mysql_query
« : 24 Февраля 2003, 22:47:02 »
shto ja delaju ne tak?
danyje v baze takije:
$templates.directions - "/1/2/3/4/5/6/7/"
$registry ja poluchiaju tozhe - "/3/5/32/43/"
$registry = explode ("/", $row_track["templates"]);
$size = sizeof($registry);
for ($i=1; $i<$size;$i++)
{
$result = mysql_query("SELECT * FROM $templates, $orders WHERE $orders.latest > \'$dead\' AND
$orders.pref_reg = $templates.id AND
$templates.directions LIKE \'%/$registry[$i]/%\'
ORDER BY date DESC");
}
mysql_count_rows($result) vsio vremia pokazyvajet 0, shto nado popravit?
spasibo
danyje v baze takije:
$templates.directions - "/1/2/3/4/5/6/7/"
$registry ja poluchiaju tozhe - "/3/5/32/43/"
$registry = explode ("/", $row_track["templates"]);
$size = sizeof($registry);
for ($i=1; $i<$size;$i++)
{
$result = mysql_query("SELECT * FROM $templates, $orders WHERE $orders.latest > \'$dead\' AND
$orders.pref_reg = $templates.id AND
$templates.directions LIKE \'%/$registry[$i]/%\'
ORDER BY date DESC");
}
mysql_count_rows($result) vsio vremia pokazyvajet 0, shto nado popravit?
spasibo