|
|
Posted by Kimmo Laine on 12/19/05 14:12
"Ben" <sdvs@qcsq> wrote in message
news:M8ednbrca5ajADveRVnygQ@scarlet.biz...
> Hi,
>
> I have a problem with this query:
>
>
> $link = mysql_connect("localhost", "root", "pw");
> $dbsel = mysql_select_db('mydb', $link);
> $lol='bibi';
>
> $sql = "select count(*) as totuur from studres where where dag>= curdate()
> AND logon='" . $lol . "'";
You have WHERE twice in "...from studres where where dag...", try what
happens if you remove the extra where. This is one of the reasons why sql
keywords should be written in CAPITAL letters. It's easier to spot the error
if you write:
"SELECT COUNT(*) AS totuur FROM studres WHERE WHERE dag>= CURDATE() AND
logon='$lol'"
--
"En ole paha ihminen, mutta omenat ovat elinkeinoni." -Perttu Sirviφ
antaatulla.sikanautaa@gmail.com.NOSPAM.invalid
Navigation:
[Reply to this message]
|