mailto:j...@newcenturydata.com]
> > Sent: Friday, June 15, 2012 10:19 AM
> > To: mysql@lists.mysql.com
> > Subject: mysqldump not escaping single quotes in field data
> >
> > My backups from a mysqldump process are useless, because the dump files
> > are not escaping
escaping single quotes in field data
>
> My backups from a mysqldump process are useless, because the dump files
> are not escaping single quotes in the data in the fields.
>
> So, O'Brien kills it - instead of spitting out 'O\'Brien'
> it spits out
>
I have mysql 5.5.
I am able to use mysqldump to export data with quotes and the dump had
escape character as seen below
LOCK TABLES `ananda` WRITE;
/*!4 ALTER TABLE `ananda` DISABLE KEYS */;
INSERT INTO `ananda` VALUES
(1,'ananda'),(2,'aditi'),(3,'thims'),(2,
My backups from a mysqldump process are useless, because the dump files are not
escaping single quotes in the data in the fields.
So, O'Brien kills it - instead of spitting out
'O\'Brien'
it spits out
'O'Brien'
I don't see anywhere in the documenta
- Original Message -
> From: "Adarsh Sharma"
> UPDATE website_master SET url= REPLACE( url,'"','');
Yep, that works fine, too, on condition that there are no quotes in the middle
of your value that need to remain where they are :-)
--
Bie
Thanks Johan,
I solved the problem by the below command :-
UPDATE website_master SET url= REPLACE( url,'"','');
Thanks
Johan De Meersman wrote:
- Original Message -
From: "Adarsh Sharma"
I need to remove the quotes in text columns in a mysq
On 11/3/2011 02:29, Adarsh Sharma wrote:
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with ". I want to remove them.
Below is the snapshot :
*ID /URL Country Publication / Description ...a
- Original Message -
> From: "Adarsh Sharma"
>
> I need to remove the quotes in text columns in a mysql table. It has
You could go with regexes - s/^"(.*)"$/&1/ should do (in whatever syntax is
appropriate for the parser you're using); or y
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with ". I want to remove them.
Below is the snapshot :
*ID /URL
Co
Am 20.09.2011 01:23, schrieb Dotan Cohen:
> On Tue, Sep 20, 2011 at 01:48, Reindl Harald wrote:
>> i would use a samll class holding the db-connection with
>> insert/update-methods
>> pass the whole record-array, lokk what field types are used in the table
>> and use intval(), doubleval() or my
On Tue, Sep 20, 2011 at 01:48, Reindl Harald wrote:
> i would use a samll class holding the db-connection with insert/update-methods
> pass the whole record-array, lokk what field types are used in the table
> and use intval(), doubleval() or mysql_real_escape-String
>
By the way, the database co
On Tue, Sep 20, 2011 at 01:48, Reindl Harald wrote:
> i would use a samll class holding the db-connection with insert/update-methods
> pass the whole record-array, lokk what field types are used in the table
> and use intval(), doubleval() or mysql_real_escape-String
>
> so you never write "insert
On Tue, Sep 20, 2011 at 02:09, Hank wrote:
>>
>> I want to be sure that all variables in the query are escaped. I don't
>> trust myself or anyone else to do this to every variable right before
>> the query:
>> $someVar=mysql_real_escape_string($someVar);
>>
>
> But you're doing exactly that right
>
>
> I want to be sure that all variables in the query are escaped. I don't
> trust myself or anyone else to do this to every variable right before
> the query:
> $someVar=mysql_real_escape_string($someVar);
>
>
But you're doing exactly that right before the query anyway with:
$M[username]=mysql_
Am 20.09.2011 00:39, schrieb Dotan Cohen:
> On Tue, Sep 20, 2011 at 01:11, Hank wrote:
>> Best of both worlds:
>>> $username=$_POST['username'];
>>> // do some stuff with username here
>>> $M=array(); // Array of things to be inserted into MySQL
>>> $M[username]=mysql_real_escape_string($userna
On Tue, Sep 20, 2011 at 01:11, Hank wrote:
> Best of both worlds:
>> $username=$_POST['username'];
>> // do some stuff with username here
>> $M=array(); // Array of things to be inserted into MySQL
>> $M[username]=mysql_real_escape_string($username); // Everything that
>> goes into $M is escaped
Best of both worlds:
> $username=$_POST['username'];
> // do some stuff with username here
> $M=array(); // Array of things to be inserted into MySQL
> $M[username]=mysql_real_escape_string($username); // Everything that
> goes into $M is escaped
> $query="INSERT INTO table (username) VALUES ('{$M
On Mon, Sep 19, 2011 at 18:11, Reindl Harald wrote:
> it is not because it is clear that it is sanitized instead hope and pray
> thousands of layers somewhere else did it - for a inline-query the best
> solution, if you are using a framework you will never have the "insert into"
> at this place!
>
Am 19.09.2011 16:55, schrieb Hank:
>>
>> what ugly style - if it is not numeric and you throw it to the database
>> you are one of the many with a sql-injection because if you are get
>> ivalid values until there you have done no sanitize before and do not here
>>
>>
> It's a matter of opinion.
>
> what ugly style - if it is not numeric and you throw it to the database
> you are one of the many with a sql-injection because if you are get
> ivalid values until there you have done no sanitize before and do not here
>
>
It's a matter of opinion. I never said the data wasn't sanitized (it is
On Mon, Sep 19, 2011 at 07:47, Reindl Harald wrote:
> what ugly style - if it is not numeric and you throw it to the database
> you are one of the many with a sql-injection because if you are get
> ivalid values until there you have done no sanitize before and do not here
>
> $sql="INSERT into tab
gt;
> where $id is a numeric variable in PHP and a numeric field in the table,
> I'll include the $id in single quotes in the PHP statement, so even if the
> value of $id is null, alpha, or invalid (not numeric) it does not generate a
> mysql syntax error. Otherwise, without the si
t;
> where $id is a numeric variable in PHP and a numeric field in the table,
> I'll include the $id in single quotes in the PHP statement, so even if the
> value of $id is null, alpha, or invalid (not numeric) it does not generate a
> mysql syntax error
what ugly style - if it is n
On Sun, Sep 18, 2011 at 12:28 PM, Dotan Cohen wrote:
> On Sun, Sep 18, 2011 at 17:44, Brandon Phelps wrote:
> > Personally I don't use any quotes for the numeric types, and single
> quotes
> > for everything else. Ie:
> >
>
> Thanks, Brandon. I understand
On Sun, Sep 18, 2011 at 17:44, Brandon Phelps wrote:
> Personally I don't use any quotes for the numeric types, and single quotes
> for everything else. Ie:
>
Thanks, Brandon. I understand then that quote type is a matter of
taste. I always use double quotes in PHP and I&#x
Personally I don't use any quotes for the numeric types, and single quotes for
everything else. Ie:
UPDATE mytable SET int_field = 5 WHERE id = 3;
SELECT id FROM mytable WHERE int_field = 5;
UPDATE mytable SET varchar_field = 'Test' WHERE id = 3;
SELECT id FROM mytable WHER
Lex Thoonen,all
> UPDATE `jos_content` SET `introtext` = replace(`introtext`," style=\"margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet
> MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;
> font-size: 30px; color: #b4b4be;\">","")
>
> just gives me 0 results...
How
Hi,
I'm trying to replace this:
but
UPDATE `jos_content` SET `introtext` = replace(`introtext`,"","")
just gives me 0 results...
How do I correctly replace and unescape the quote?
Thanks!
--
Lex Thoonen
Pêng Smart Web Design - http://www.peng.nl
Gran Canaria Info - http://www.gran-can
Hi,
I guess the id_file_set is an INT?
The problem si most likely due to the fact you are comparing integer to
string, which forces MySQL to use type conversion. For more information
check http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html
When type conversion occurs MySQL will not be
| table | type | possible_keys | key |
> key_len | ref | rows| Extra |
> ++-++--+---+--+-+--+-+-+
> | 1 | SIMPLE | bite_event_log | ALL | id_file_set | NULL | NULL
> | NULL | 1213328 | Using where |
> ++-+----+--+---+--+-+
I'm really confused. First, I don't understand why quoting my IN()
values here caused them to run significantly slower than the non-quoted
versions... on just this simple contrived example it can be as much as
2.2 seconds vs. 0 seconds to return on a table that has 2.5M rows.
The problem I'm facin
In the last episode (Jul 02), Martin Gainty said:
>
> How do I get mysqldump to turn off quotes e.g from
> INSERT INTO "table"
> to
> INSERT INTO table
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names
--
Dan Nelson
[EM
How do I get mysqldump to turn off quotes e.g from
INSERT INTO "table"
to
INSERT INTO table
Thanks
Martin Gainty
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Se
Hi,
yes, the create database succeeds. It's in a show databases. The error
message is complaining about "`db1`" (i.e. quotes followed by backtick).
I'm actually using rsync to copy the file (faster than ftp for some
reason). But it also failed when I originally ftp'd
;
Note the backticks around the database name.
Looking at dumpfile, I see,
use `db1`
I tried doing the mysqldump with --compatible=ansi which changes the
backticks to double quotes, but get the same error,
ERROR 1049 at line 25: Unknown database '"db1"'.
I can't edit dump
use `db1`
I tried doing the mysqldump with --compatible=ansi which changes the
backticks to double quotes, but get the same error,
ERROR 1049 at line 25: Unknown database '"db1"'.
I can't edit dumpfile as it is 8Gb (ok, I can split it and stuff like
that ... but com
> thanks for your response.
>
> I'm already working on the php "part" but just wondered how "bad" is to
> have backslash in front of quotes.
It's bad in the sense that you will have to predict every single event
(character) from the input and act accor
thanks for your response.
I'm already working on the php "part" but just wondered how "bad" is to
have backslash in front of quotes.
thanks.
-afan
> [EMAIL PROTECTED] wrote:
>> hi to all.
>>
>> battling this problem on several forums and mailing
[EMAIL PROTECTED] wrote:
hi to all.
battling this problem on several forums and mailing lists, I got confused:
when store string that contains quotations (ie afan's "php" shop) in mysql
does it have to be stored with backslashes (afan\'s \"php\" shop) or just
the way it is? my login's telling me
> -Original Message-
> From: Chris White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 09, 2006 11:43 AM
> To: mysql@lists.mysql.com
> Subject: Re: how to store quotes in mysql?
>
> On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
> >
>
On Wednesday 09 August 2006 08:37 am, Kristen G. Thorson wrote:
>
> [ stuff here ]
>
> kgt
I'm confused.. did you read my email? Most of what you said doesn't seem to
correlate with what I said. Can you quote the specific lines that you're
disagreeing with?
--
Chris White
PHP Programmer/DBacil
ES('[bl' ; DELETE FROM table;
SELECT('ah]');
>
> where [] is what the user inputs. Now when displaying, you'll have to
> unescape the slashes generally. Unfortunately I can't remember in PHP
if
> that's because of magic quotes or just the way the db h
TE FROM table; SELECT('ah]');
where [] is what the user inputs. Now when displaying, you'll have to
unescape the slashes generally. Unfortunately I can't remember in PHP if
that's because of magic quotes or just the way the db has it stored. My gut
instinct is the
hi to all.
battling this problem on several forums and mailing lists, I got confused:
when store string that contains quotations (ie afan's "php" shop) in mysql
does it have to be stored with backslashes (afan\'s \"php\" shop) or just
the way it is? my login's telling me the way it is. am I wrong?
ws Character Map (charmap.exe)
J.R.
-Original Message-
From: Brian Dunning [mailto:[EMAIL PROTECTED]
Sent: Monday, December 05, 2005 2:13 PM
To: mysql@lists.mysql.com
Subject: Killing my curly quotes
OK, I'm bad - I have curly quotes in my db that I failed to eliminate prior
to the
OK, I'm bad - I have curly quotes in my db that I failed to eliminate
prior to the insert. Now that they're in there, is there a way to
replace them with straight quotes? Everything I try fails to find them.
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Hello.
>and I want to search for this exact phrase, including double quotes,
You can't do this, because fulltext search operates with "words",
and double quotes not a "word". Also an order of the sequence of
words doesn't have a sence for a fulltext
where match (title) AGAINST ('"plastique ou carton"' in boolean mode)
â Now suppose that in my table, "plastique ou carton" are between
double quotes. I have a search engine in which users can enter an
exact phrase search. So in my code I insert this phrase they want to
fi
Hello.
At first: from your phrase with default values for the FULLTEXT
parameters there is the only one meaningful word - football.
Because 'I', 'on', 'TV' has less than 3 characters. 'like' is
in the stopword list. Quotes '"' - are sk
Hi list,
I'm trying to figure out how to use the exact phrase search in
fulltext boolean mode when the phease to search includes double
quotes.
For instance, what if I want to search this exact phrase :
I like "football" on TV
I think I've tried all the solution I'm awa
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Charset.html
Andrew Mull <[EMAIL PROTECTED]> wrote:
> That is what I was wondering, but not sure how to check/set the proper
> character set.
>
> Thanks.
>
> -Andy
>
> Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
>
>> Hello.
>>
it is consistent, and just
> replace it.
>
> Thanks.
>
>
> Quoting [EMAIL PROTECTED]:
>
> > are you sure that the single/double quotes in your original data were
> > actually the standard ascii characters (decimal 39 (') and 34 (")) --
> > not
When I look at the dump file, I see that one of the invalid characters is
represented as /226 I'll have to look to see if it is consistent, and just
replace it.
Thanks.
Quoting [EMAIL PROTECTED]:
> are you sure that the single/double quotes in your original data were
> actually t
That is what I was wondering, but not sure how to check/set the proper
character set.
Thanks.
-Andy
Quoting Gleb Paharenko <[EMAIL PROTECTED]>:
> Hello.
>
> You can write a script which will walk through all tables and
> update the rows using replace() function. But, I think, you should
> fin
Hello.
You can write a script which will walk through all tables and
update the rows using replace() function. But, I think, you should
find the source of the problem. What odd characters have appeared after
importing? If they are just unreadable, may be the clue is in wrong character
set.
I'm moving a database from one server to another. Both are unix based,
however the original database is on a Solaris box, and the new server is
RedHat.
The database has embedded "s and 's in some of the varchar fields. When I
moved the database, I did a mysqldump, copied the text file to the
In the last episode (Dec 15), Dave Juntgen said:
> > ext_doc_id is a CHAR type, which means that you may have two rows,
> > "0412625", and "412625", both of which match the expression "WHERE
> > ext_doc_id=412625". MySQL can't use an index because it has to
> > convert each field to a number befor
270
Fax : 260.459.6271
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 15, 2004 11:10 AM
> To: Dave Juntgen
> Cc: [EMAIL PROTECTED]
> Subject: Re: To use Quotes or not to, that's the question.
>
> In the last epis
In the last episode (Dec 15), Dave Juntgen said:
> Could someone please explain to me why the second query below is
> faster then the first query? The only difference between the two is
> that ext_doc_id's value is quoted. Index and column information
> follow and the table being queried contains
.mysql.com/doc/mysql/en/RESET.html
The quoting rule is: If it's a NUMBER, don't quote it. Strings get quotes,
so do dates. Database elements (tables, columns, etc. ) whose names are a
reserved word or contain invalid characters (like spaces) or are otherwise
invalid would need to be sur
Hi!
Could someone please explain to me why the second query below is faster then
the first query? The only difference between the two is that ext_doc_id's
value is quoted. Index and column information follow and the table being
queried contains approximately 3.5 million rows.
Thanks!
--Dav
On Wednesday 15 December 2004 15:38, Dave Juntgen might have typed:
> Hi!
>
> Could someone please explain to me why the second query below is faster
> then the first query? The only difference between the two is that
> ext_doc_id's value is quoted. Index and column information follow and the
> t
From: "David Blomstrom" <[EMAIL PROTECTED]>
> --- Chris W <[EMAIL PROTECTED]> wrote:
> > If you plan on using this process again, you may
> > want to track down the
> > source of the problem, but if you aren't going to
The "source of the problem" is the fact that it is common in a CSV file to
rep
--- Chris W <[EMAIL PROTECTED]> wrote:
> If you plan on using this process again, you may
> want to track down the
> source of the problem, but if you aren't going to
> be exporting this way
> again and you just want to fix it, I would just open
> the csv file in a
> text editor and do a search
David Blomstrom wrote:
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quotes
when I saved the file as a csv file. In other words,
they now look like this:
Geobop
Do you have any idea what
This isn't directly related to MySQL, but I thought
someone might have an answer - or maybe there's a way
MySQL can deal with it.
I just saved a spreadsheet (Microsoft Works) as a csv
file and imported it into a database. It worked fine,
except for some links, which acquired double quo
Just by curiosity is there any difference between this 2 queries
select * from users where users_id=10
and
select * from users where users_id='10'
assuming that the users_id column is of type integer primary key (if it
would be varchat I know there is a big difference)
You could always write your own function to do the escaping for you. This following
link is an example written in VB that you could adapt to whatever language you are
using.
http://www.vbmysql.com/samplecode/stripquote.html
Here is another way of doing it if you can link to the libmySQL.dll (o
Matthew Stuart said:
> I am on my first MySQL DB and it is very text heavy because it is a
> news site, therefore there is a great deal of use of the apostrophe
> or as MySQL would see it the single quote. I was hoping to be able
> to use double quotes to overcome the need to consta
[snip]
Are my prayers answered? I have been a bit concerned that I might not
be able to completely fulfill my clients needs because of them being
restricted to the use of single quotes.
[/snip]
Mat,
What is your programming language for the site? If it is PHP you have a
wealth of options for
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe or
as MySQL would see it the single quote. I was hoping to be able to use
double quotes to overcome the need to constantly have to escape the
apostrophe
On Tue, 09 Dec 2003 13:24:03 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
>
>You don't want to filter the quotes from the input string, because they
>exist in the data. (Well, you could filter from both sides, but that's
>inefficient.) What you need to
for for a name that
contains a quote eg a development named King's Reach it is not found.
A)
Now it simply won't match King's Reach whether I include the quote or
not. WHY?? (Have the quotes been converted ie to URL Encoding))
Consider what your query looks like when form.searchtext
Hi Ya.
I seem to have solved my problem if I clean out any punctuation from
my search string (see below (ColdFusion script))
When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes
The LIKE appears to ignore the quotes (which is what I want)
BUT IS THAT A FEATURE OF LIKE
On Mon, 08 Dec 2003 19:07:43 +, zzapper <[EMAIL PROTECTED]> wrote:
>Hi Ya,
>I have a typical select as follows
>
> SELECT * FROM ytbl_development AS t1
> WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
>B)
>Now I can filter any quotes from form.
)
Now it simply won't match King's Reach whether I include the quote or
not. WHY?? (Have the quotes been converted ie to URL Encoding))
B)
Now I can filter any quotes from form.searchtext easy enough, but how
do I filter them the Left Hand Side eg from txtDevName?)
I look forward to
[snip]
> The site is a news based site and has the use of the single quote or
> apostrophe (') through most of it's articles. I think that each
article
> at present is an external .txt file that is pulled in to Oracle. If I
> carried on this method of having an external .txt file would that over
>
Matthew,
I really don't understand the question. Apostrophes must be properly
escaped when text is inserted into the MySQL db, but any perl script will
easily do this for you. You may convert to HTML at the same time.
If the database gives nothing but a path to a *.txt source then your HTML
code
I am going to take over an existing website and in its present format
it is a site powered by an Oracle DB. I will be migrating to MySQL.
The site is a news based site and has the use of the single quote or
apostrophe (') through most of it's articles. I think that each article
at present is an
cc:
11/07/2003 11:30 Subject: single quotes in database
: PHP <[EMAIL PROTECTED]>,
mysql <[EMAIL PROTECTED]>
cc:
11/07/2003 11:30 Subject: si
I am using PHP/MySQL and am having a problem. We have some names and
addresses in the database that have single quotes in them. For
instance. There is a town around here called "Lee's Summit". Also names
like "O'connel". When I pull from the database it skip
Kim Kohen <[EMAIL PROTECTED]> wrote:
>
> I have a bit of a problem with some characters I'm loading from a Filemaker
> Pro database. The single quotes are stored in MySQL as ASCII character 155
> (an 'O' with a tilde over it). I have tried everything I can think
At 15:58 +1000 20-10-2003, Kim Kohen wrote:
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
re
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use to query th
I'm writing some routines which generate SQL queries, and I'm trying to
keep things generic. As such, I have a routine to SQL Escape some text,
such that it can be used in a query without breaking anything. This
routine predominantly consisted of preceeding all single quotes (
Carl,
Friday, May 17, 2002, 7:59:49 AM, you wrote:
CJM> Description:
CJM> According to the documentation at
CJM> http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes
CJM> around a phrase within the AGAINST clause of a full-text boolean mode
CJM> sear
>Description:
According to the documentation at
http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes
around a phrase within the AGAINST clause of a full-text boolean mode
search should match only rows which contain this phrase exactly as
typed. Instead, it appe
Please ignore earlier message -- mySQL stores embedded quotes just fine.
Wyckham Seelig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
The mySQL manual says that embedded double quotes within a single quoted
expression (as in 'O"Hara') need no special treatment. However, when I try
to update a data base field using such an expression, as in:
UPDATE table set col1='O"Hara'
the result I
Hi,
I have a while loop pulling information into an editing form. It labels
variables dynamically as so:
name="schooling
Where $counter is augmented each time through the loop. In order to then
insert these, I need to do an insert of $schooling$counter. Below is the
statement I've been trying to
7; and 'maupertuis' this is tranlated
>>insert into personnel(first_name, last_name) values('jean','maupertuis')
>>which is the correct form.
>>
>>We can test this with a little sql:
>>select ucase(?test?)
>>
>>I try different thing
o personnel(first_name, last_name) values('jean','maupertuis')
> which is the correct form.
>
> We can test this with a little sql:
> select ucase(?test?)
>
> I try different things to solve : concat, '?var?', ... but i don't find
> a way to byp
I try to use the ?var?'s to create a menu for inserting new rows in a table.
for example:
insert into personnel(first_name, last_name) values(?first_name?,
?last_name?)
if i type jean in first_name and maupertuis in last_name the result is
"unknow column
'jean' in 'field list' "because it's tr
Sorry bout the blank one.
try this
Jim Lucas
- Original Message -
From: "Gregory Jon Welling/Parts Trading Inc." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
> This is more of a php problem than my
- Original Message -
From: "Gregory Jon Welling/Parts Trading Inc." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 10:38 AM
Subject: quotes
> This is more of a php problem than mysql, but since I am using them in
> combo.
Gregory,
This is a PHP question, really, but...
If you just echo the $companyname variable, you don't need double quotes around it:
If that is not what you are actually doing, give us the real code you are usign with
$companyname in it, and we'll take it from there.
At 19:38
quotes
when writing the name of your company, (i.e. Limited Liability Company
"Widgetron"). Anyhow, one of the scripts that I am using has
It works great when the person isn't using quotes in the company name, but
when they are the quoted part disappears. If everyone was using qu
Thanks DL,
Seems there was double quotes at the begining of each field due
to importing data into a table using the "Load infile" statement with the
import file being DOS format rather than Unix.
As all know unix lines end with a '\n' only. When I did a test in a
row and
> Does anyone know how to delete double quotes from my entries '"'.
> I thing you can use regular expressions.
Dexter,
The following resources may be of interest to you:
The MySQL Manual, particularly:
7.1 Literals: How to Write Strings and Numbers,
7.4 Functions for Us
1 - 100 of 106 matches
Mail list logo
