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

• Next in forum: Re: Is PhP/mySQL right for this project?
• Prev in forum: Re: Automated file upload to mysql database
• Thread view: Re: problem with select count(*)

[Reply to this message]