Reply to Re: hm??? integer converting?

Your name:

Reply:


Posted by Kimmo Laine on 07/08/05 15:34

"Chris Hope" <blackhole@electrictoolbox.com> wrote in message
news:dalhce$u6f$1@lust.ihug.co.nz...
> roN @ work wrote:
>
>> roN @ work wrote:
>>> Hi,
>>> I got following Code and get Below Error, why? :(
>>> [Code]
>>> function reportSpam($email_address_and_relay)
>>> {
>>> $connection=mysql_connect(db_server,db_user,db_passwort);
>>> mysql_select_db(db_name);
>>>
>>> $date = date("y-m-d");
>>> $tmp=explode("*",$email_address_and_relay);
>>> $address = $tmp[0];
>>> $relay = $tmp[1];
>>> $query = "insert into blacklist (`Date`,`Address`, `Relay`) values
>>> ('$date','$address', $relay)";
>>>
>>> mysql_query($query) or die(mysql_error());
>>> mysql_close($connection);
>>> echo "reported ".$email_address."<br>\n";
>>> }
>>> [/Code]
>>> [Error]
>>> You have an error in your SQL syntax. Check the manual that
>>> corresponds to your MySQL server version for the right syntax to use
>>> near '.160.97)' at line 2
>>> [/Error]
>>> In Variable $email_address_and_relay there is something like
>>> test@example.com*255.127.53.49 I'd like to explode that and save the
>>> e-mail address and the relay IP in diffrent cols in the same row.
>>> shouldn't it work? :(
>>> table blacklist looks like this:
>>> Date - date
>>> Address - varchar(100)
>>> Relay - varchar(50)
>>> do I have to convert $relay to an integer before I'm gonna save it to
>>> the DB? Yes? How?
>>
>> Sorry, I meant convert it to a String for sure....
>
> Read my other post. You don't need to convert it to a string as it
> should already be a string; you just need to put quotes around the
> value ie
>
> $query = "insert into blacklist (`Date`,`Address`, `Relay`) values
> ('$date','$address', $'relay')";
> ^ ^


And I'm sure Chris meant '$relay' instead of $'relay', but I thought I'd
mention it...

--
Welcome to Usenet! Please leave tolerance, understanding
and intelligence at the door. They aren't welcome here.
eternal piste erection miuku gmail piste com

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация