Posted by Mark on 10/20/05 17:53

Justin Koivisto wrote:
> Mark wrote:
>
>> Hello
>>
>> new to php, and a problem:
>>
>> $sContentId = $_GET["sContentId"];
>>
>> $db = mysql_connect("mysql.xxx.nl","xxx","xxx") or die ("Error");
>>
>> mysql_select_db("keyone", $db);
>>
>> // here is goes wrong
>> $sql2 = "SELECT * FROM sContentTbl WHERE sContentId=$sContentId";
>>
>> echo $sql2."<br>";
>> $producten = mysql_query($sql2);
>> mysql_close($db);
>>
>> I do only want the (1) item out of the sContenTbl where the value is
>> specified bij $sContentId. But i do get this:
>>
>> SELECT * FROM sContentTbl WHERE sContentId=\'6\'
>>
>> If i choose to do it like this (test):
>>
>> $sql2 = "SELECT * FROM sContentTbl WHERE sContentId=6";
>>
>> then it works fine.
>>
>> So what do i do wrong?
>
>
> Before using $_GET['sContentId'] in the query, ensure that it is an
> integer value without any quotes.
>
> functions to help:
> is_numeric
> intval
>
> if you need to find the number within the variable string value and of
> these can help:
> str_replace
> substr
> strpos
> preg_match
> preg_replace
>

Thanks, that was the problem. I made a mistake and changed the integer
into an string in the page before this one... so a couple of hours lost,
but glad to have the sollution :0)

thanks

• Next in forum: php 5.0.5 segfaults apache2 on ubuntu, 5.0.4 ok
• Prev in forum: Re: [PHP] Re: No redirect with header() [solved]
• Thread view: Re: Problem with SELECT

[Reply to this message]