View previous topic :: View next topic |
Author |
Message |
croatius
Joined: 02 Oct 2007 Posts: 34 Location: pumpaona
|
Posted: 06.10.2007 19:26 Post subject: Problem s $_GET u SQL query |
|
|
Code: | if (@$_GET['cat']) {
$articleresult = $connector->query('SELECT * FROM `articles` WHERE `article-category` = ' . $_GET['cat'] . ' LIMIT 10');
while ($row = $connector->fetchArray($articleresult)) {
echo $row['article-title']; //test
} |
Ne mogu sloziti da mi npr $_GET = "rijec" radi, osim ako $_GET = broj. Tj radi jedino sa znamenkama inace dobijem mysql error. Moze malo help? |
|
|
Back to top |
|
|
maXimus
Joined: 05 Dec 2005 Posts: 55 Location: Zagreb
|
Posted: 06.10.2007 23:15 Post subject: |
|
|
pa ako se radi o stringu onda on mora u navodnike ići, dakle nedostaju ti navodnici prije i poslije $_GET-a
još si i sam donekle napisao
Quote: | $_GET = "rijec" vs $_GET = broj |
|
|
|
Back to top |
|
|
PaNtHeR
Joined: 17 Sep 2003 Posts: 161
|
Posted: 06.10.2007 23:23 Post subject: Re: Problem s $_GET u SQL query |
|
|
Dobro kaže maximus, trebaš eskejpati navodnike, mislim da treba biti ovako:
Code: | if (@$_GET['cat']) {
$articleresult = $connector->query('SELECT * FROM `articles` WHERE `article-category` = \'' . $_GET['cat'] . '\' LIMIT 10');
while ($row = $connector->fetchArray($articleresult)) {
echo $row['article-title']; //test
} |
|
|
|
Back to top |
|
|
croatius
Joined: 02 Oct 2007 Posts: 34 Location: pumpaona
|
Posted: 07.10.2007 17:34 Post subject: |
|
|
tenk ju |
|
|
Back to top |
|
|
|