Commas and MySQL statements

[phplilo]

Lo people,

I am new here as you can prolly tell by my post count tend to hang over at highrankings a lot, and was pointed this way from a mod there (hi Chris).

Anyway - I have come across a prob with mysql queries - when I submit say a string to a varchar field, that contains a comma, I get a mysql error for example:

$query = "INSERT INTO sometable (title) VALUES ('Hello, I am a fish')";
mysql_query($query);

Now short of parsing the mysql data replacing commas with spaces etc, does anyone know whats going wrong here?

Cheers

LiLo

 

[kenrbnsn]

You could try an alternate format for insert:

$q = "insert into sometable set title='Hello, I am a fish'";
$r = mysql_query($q);
if (!$r) echo "Problem with query &lt;$q&gt;<br>".mysql_error();

Commas shouldn't be a problem.

Ken

 

[BitFuzzy]

Try:

$sql = "INSERT INTO yourtable(cname)
VALUES ('Hello, I am a fish')";
$result = mysql_query($sql);

Other than that check the field size for the table/column receiving the data. Make sure it's set to atleast field_type(18) <-- just big enough for the example used/provided

 

[skiflyer]

Yes, commas should not be a problem.. if they are something else is wrong.

However, to help keep you going forward you can use the following to help alot with debugging.

mysql_query($query) or die('<pre>Error in sql:'.$query.'<br />'.mysql_error());

And as a side note, you may find the following function very useful for whatever is actually causing a problem in your query.

If your example is really an example of one going bad, I'm assuming title is a reserved word in MySQL... so you need to enclose it in backquotes. (Note these are not single quotes)

$sql = "INSERT INTO sometable (`title`) VALUES ('Hello, I am a fish')";

mysql_escape_string()

http://us4.php.net/manual/en/function.mysql-escape-string.php

 

[phplilo]

Cheers for the help, after more scrutinising of my code working with the fact that commas were not causing the prob, I have narrowed it down to that I was creating an array from the data and searching it etc... and I was using the comma seperator to split!

So... doh.

 

[ChrisHirst]

Hi Lilo

You'll get no work done now with more forums to play in



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[ChrisHirst]

BTW asp.net is forum855 if you haven't found it already



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[phplilo]

Ta Chris