query from db not working
Posted: Wed Jun 06, 2007 1:52 pm
feyd | Please use
when I want to execute it it does nothing, and if I replace values that are in sessions
it works perfectly.
How can I get it working retrieved from db with sessions inside query?
regards ddragas
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi all
I'm having problem with query retrieved from database.
this is query inserted into db with addslashes
[syntax="sql"]
SELECT
SUM(izostanci.neopravdano) AS neopravdano,
ucenici.prezime,
ucenici.ime
FROM
ucenici
INNER JOIN izostanci ON (ucenici.id = izostanci.ucenik)
WHERE
(izostanci.skola = '" . $_SESSION["odabrana_skola"] . "') AND
(izostanci.sk_god = '" . $_SESSION["odabrana_skolska_godina"] . "') AND
(ucenici.aktivan = '1')
GROUP BY
ucenici.prezime,
ucenici.ime
ORDER BY
neopravdano DESC Code: Select all
SELECT
SUM(izostanci.neopravdano) AS neopravdano,
ucenici.prezime,
ucenici.ime
FROM
ucenici
INNER JOIN izostanci ON (ucenici.id = izostanci.ucenik)
WHERE
(izostanci.skola = '1') AND
(izostanci.sk_god = '1') AND
(ucenici.aktivan = '1')
GROUP BY
ucenici.prezime,
ucenici.ime
ORDER BY
neopravdano DESC
How can I get it working retrieved from db with sessions inside query?
regards ddragas
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]