On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote:
> You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large
> text...
> On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald
> wrote:
>
>
>> Am 18.11.2014 um 10:48 schrieb thufir:
>> > I'm trying to store a web page to table "pages
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald
wrote:
>
> Am 18.11.2014 um 10:48 schrieb thufir:
> > I'm trying to store a web page to table "pages" (whether or not that's a
> > good idea for a separate thread, please). W
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to table "pages" (whether or not that's a
good idea for a separate thread, please). What would be a suitable type
for the field which stores the actual page source?
text = 64 KB including all spaces and meta chars
signat
I'm trying to store a web page to table "pages" (whether or not that's a
good idea for a separate thread, please). What would be a suitable type
for the field which stores the actual page source?
When running my java application, the MySQL errors are as so:
run:
[java] [EL Info]: 2014-11-
I'm seeing this more and more
I'm hearing the justification that its easier to put an pre-formatted anchor
tag or href but you're right
if html is stored in the DB then javascript can easily follow
of course the overseas contractors sticking in href to their own sites sure
does&#
assuming php from your sig strip_tags
http://www.php.net/manual/en/function.strip-tags.php
shannon
On Aug 2, 2008, at 5:16 PM, Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code in insert
statements?
I have a client with a comments form that is being
Doubt this can be done easily if at all.
Accept only text and no html. But even that should be the job of the form
validator
--Original Message--
From: Skip Evans
To: mysql@lists.mysql.com
Sent: Aug 2, 2008 14:16
Subject: Blocking HTML code in inserts?
Hey all,
What is the most
Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code in insert statements?
I have a client with a comments form that is being bombarded with people
inserting references to their own sites, etc, and I need an effective
way to filter basically any HTML tags at all
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote:
> Hey all,
>
> What is the most effective way to block HTML code
> in insert statements?
>
> I have a client with a comments form that is being
> bombarded with people inserting references to
> their own sites, etc,
Hey all,
What is the most effective way to block HTML code
in insert statements?
I have a client with a comments form that is being
bombarded with people inserting references to
their own sites, etc, and I need an effective way
to filter basically any HTML tags at all.
Thanks,
Skip
AM
> To: mysql@lists.mysql.com
> Subject: how ti put several records of one mysql table in one row of
> html table?
>
> hi,
> I have "standard" organizations table with org_id, name, address,
> city,... columns.
>
> CREATE TABLE `organization` (
> `organiz
Hi,
I think "GROUP_CONCAT" will do it.
-Raj.
-Original Message-
From: afan pasalic [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 16, 2007 11:49 AM
To: mysql@lists.mysql.com
Subject: how ti put several records of one mysql table in one row of
html table?
hi,
I have
12 | 2005-04-01 |
|8200 | 14 | Small Member |
|8200 | 16 | 1-4 |
|8200 | 21 | Retail |
+-+------+--+
I have to make a list (on screen, as html table) of organizations with
Dan and Paul,
I develop at home on Ubuntu Linux and deploy at work over FreeBSD Unix
(an iMac running OS 10.4). The command line tip you suggested worked
fine on Linux, so I'm assuming that I can get it to run here at work as
well when I get the time to try it. Thanks again.
John "Another Brick
EMAIL PROTECTED]
Cc: MySQL
Subject: Re: --xml or --html output to file
Hi John -
using --xml or --html as an argument and redirecting to a file seems to
work
here. As in,
mysql -u me -psecret -D database --html -e "select * from that_table" >
~/test_file.html
HTH,
Dan
On 5/8/07, J
At 6:09 PM -0400 5/8/07, John Kebbel wrote:
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays f
Hi John -
using --xml or --html as an argument and redirecting to a file seems to work
here. As in,
mysql -u me -psecret -D database --html -e "select * from that_table" >
~/test_file.html
HTH,
Dan
On 5/8/07, John Kebbel <[EMAIL PROTECTED]> wrote:
When I try using
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the terminal.)
I tried using the pager to
At 15:55 -0500 5/18/06, Steve wrote:
Hi everyone...
how do I enter html code into my database???
Like any other string.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi steve, you just have to double quotes your insert!
On 5/18/06, Steve <[EMAIL PROTECTED]> wrote:
Hi everyone...
how do I enter html code into my database???
Hi everyone...
how do I enter html code into my database???
Except that that page says:
A ''' inside a string quoted with '"' needs no special treatment and
need not be doubled or escaped. In the same way, '"' inside a string
quoted with ''' needs no special treatment.
So the double quotes inside single quotes should work.
And indeed, I tested this:
mys
Hello.
Use backslashes to escape double quotes. See:
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
LMS wrote:
> Hi,
> I can't save this:
>
>
> UPDATE [table] SET [filed]='
> id="{ID_CAMPO}">{ID_VALOR}
--
For technical support contracts, goto https://order.mys
Hi,
I can't save this:
UPDATE [table] SET [filed]='
{ID_VALOR}'
WHERE id = [n];
in a VARCHAR(255) field, it only saves:
{ID_VALOR}
why?
Thanks...
Marcelo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
clint lenard wrote:
can anyone help me with this question? (about using Smarty)
No doubt -- but that "anyone" would likely be on a Smarty-specific
(or at least PHP-oriented) mailing list, eh? :-)
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1) 4
can anyone help me with this question?
On 9/12/05, clint lenard <[EMAIL PROTECTED]> wrote:
>
> Hey Douglass,
>
> Curious about using Smarty (taking the Crash Course and bookmarked a
> couple of other tut's)... One of the advantages of using a DB to store the
> H
Hey Douglass,
Curious about using Smarty (taking the Crash Course and bookmarked a couple
of other tut's)... One of the advantages of using a DB to store the HTML
Sites was the opportunity to give the user an automated Zip file of their
site if they wanted to download it and create thei
r about a week looking
> for an answer to this...
>
> I'm trying to design a Database that would hold HTML sites in the DB itself
> and use PHP to call for the HTML file - which would be populated with
> Content from another table in MySQL. I was told I could put HTML into
>
clint lenard wrote:
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Conte
Wow, thanks for all of the Information guys! I've learned alot and now I've
actually been doing more brain storming... I've been reading all of these
emails over and over - and they're helping me understand more!
What I'm trying to do is save "User Sites" in MySQL and use PHP to pull them
out t
Jasper Bryant-Greene wrote:
John Trammell wrote:
$input = "This is the \n input";# value from user
$saved = "This is the input"; # value in database
$recovered = "This is \n the \n input"; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not app
John Trammell wrote:
$input = "This is the \n input";# value from user
$saved = "This is the input"; # value in database
$recovered = "This is \n the \n input"; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not applying
nl2br() before saving th
un 9/11/2005 2:15 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: Re: HTML in MySQL?
Hello!
> But once you have done that, you can never recover the origional text.
> Try it on this email if you doubt it.
Why? Why not to use regular expressions?
> Use addslashe
database, and converting it back after reading from the database, is
more work and more error-prone, compared to not doing this conversion.
You can easily do the conversion when you output the data, _if_ the
output format is html, _and_ you actually want "hard" linefeeds in your
h
Hello!
> But once you have done that, you can never recover the origional text.
> Try it on this email if you doubt it.
Why? Why not to use regular expressions?
> Use addslashes($htmlCode) and execute query normally.
> $slashedHtmlCode = addslashes($htmlCode);
The problem is not in the executi
ters.
>
> Agree, I was wrong.
>
> > And i would highly recommend *not* replacing them with
> > tags as you write them into the database. This is asking for trouble on
> > so many levels.
> >
> > The database will cope with carriage returns and newlines just like
ble on
so many levels.
The database will cope with carriage returns and newlines just like any
other character, so will have no problems.
HTML is just string; treat it as such and don't give it anymore credit
than that and you'll be fine.
If you need to output a HTML string (not
ls.
>
> The database will cope with carriage returns and newlines just like any
> other character, so will have no problems.
>
> HTML is just string; treat it as such and don't give it anymore credit
> than that and you'll be fine.
If you need to output a HTML string (
Amen. Translating user input into HTML is great until you need to read
the data *out*, and someone decides the output should be formatted as
RTF or PDF or text. Best to store it as you got it, IMO.
> -Original Message-
> From: Alan Williamson [mailto:[EMAIL PROTECTED]
> Sen
e any
other character, so will have no problems.
HTML is just string; treat it as such and don't give it anymore credit
than that and you'll be fine.
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mai
Hello, Clint!
> I'm trying to design a Database that would hold HTML sites in the DB itself
> and use PHP to call for the HTML file - which would be populated with
> Content from another table in MySQL. I was told I could put HTML into
> MySQL... so my main question would be:
clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want to
be sure... do I need to strip the slashes and special characters out and
add them when they're called... or..? I'm just trying to get a clear
picture of exactly what needs to be done with this particu
David and Jasper - thank you both! I will play around with this more now
that you have explained my biggest questions!
Thanks guys,
Clint
:-)
On 9/9/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
>
> clint lenard wrote:
> > Thanks Jasper for the info! This may sound stupid - but I just w
Hi Clint,
Another possibility is to actually run the mysql client with a --html
option and let mysql do the work for you
eg : prompt $ echo "SELECT some_stuff FROM table" | mysql -u xyz -pxxx
--html
This generates a block of html for a table with the data encapsulated
within, then it
..
thanks!
On 9/9/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
>
> clint lenard wrote:
> > Hi guys, I'm fairly new to MySQL and I've searched for about a week
> looking
> > for an answer to this...
> >
> > I'm trying to design a Databas
clint lenard wrote:
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Conte
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in My
archived. Many of them
have hundreds of pages but I'm only involved in a few of them etc. What I'm
looking for is a way of
storing,identifying code nuggets. I currently do this in flat text files but
these are better suited
to recording say a "cute mysql query" etc than a wodge
At 02:46 PM 5/27/05, zzapper wrote:
Today I designed a fairly cute error404.php page, which I'd like to reuse
in future.
Currently I rely on remembering that I created such a page for say ACME
Carpets.
Now and again my memory fails to remember which site I developed a piece
of HTML,PHP
ory fails to remember which site I developed a
> piece of HTML,PHP,Perl,Javascript
> for and I spend more time going thru CD backups etc than it would
> take to start again. I've
> postulated using MySql as a store for such pages. but is a database
> suitable for stor
Hi,
Today I designed a fairly cute error404.php page, which I'd like to reuse in
future.
Currently I rely on remembering that I created such a page for say ACME Carpets.
Now and again my memory fails to remember which site I developed a piece of
HTML,PHP,Perl,Javascript
for and I spend
Hi.
When you output field data inside html pages,
browser can interpret the tags inside fields (hackers usually use
such things).
Try to use htmlentities() and htmlspecialchars() to escape all '<' and '>' chars in
data.
Regards.
"leegold" <
Just put the href into the database.
When you output it to html in PHP wrap it wth the rest.
$href=$sql->data['href'];
echo "The Link\n";
leegold wrote:
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a subs
I have to put html links inside varchar and text fields. They have to be
(somehow) fulltext searchable (of course a substring, %keyword% search,
would pick them up - I realize that) and they have to render as
clickable links when I output the fields via PHP. How would I do this?
Is this more of a
hi.
I want to create the one-page per chapter style of HTML docs on my local
hard disk.
how do I do this?
I have create the single page html document, but I can't find any docs
on the split one.
TIA
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday, Aug 18, 2004, at 13:59 US/Eastern, Steve Edberg wrote:
At 08:37 AM 8/18/04, leegold wrote:
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user&#
On Wed, 18 Aug 2004 11:37:03 -0400
"leegold" <[EMAIL PROTECTED]> wrote:
> Question I have wondered about: Is it a good practice to put html in
> a text field, then (eg. via php) when the marked-up text renders in
> a user's browser it's good looking html. If n
At 08:37 AM 8/18/04, leegold wrote:
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user's browser it's good looking html. If not, then I'd just sandwitch
field content in a when it
Question I have wondered about: Is it a good practice to put html in a
text field, then (eg. via php) when the marked-up text renders in a
user's browser it's good looking html. If not, then I'd just sandwitch
field content in a when it's rendered. Though, seems like it
wo
Hi All
I have a spate of questions about mysql fields but I'll start with this one as
its probably the simpliest of mistakes I am making, I am using php echo to
retrieve records echo "$fieldrecord"; where the field have yet the page
it is displayed in does't show the break looking at the source t
At 07:52 PM 6/25/04, Kyle Texan wrote:
I want to take 1 field in a mysql table and use that
information to populate an html form select field
instead of writing the html code, that way when data
changes in that mysql field the form will always be in
sync with the table?
You need to use a
I want to take 1 field in a mysql table and use that
information to populate an html form select field
instead of writing the html code, that way when data
changes in that mysql field the form will always be in
sync with the table?
--
MySQL General Mailing List
For list archives: http
sized word , for example?
And is this something that can only be done with XML?
I do recall reading that XML is a very flexible
language that lets you create your own codes, styles,
etc. Am I correct in guessing that the pros prefer XML
to HTML or XHTML when working with MySQL?
If so, that's anoth
David Blomstrom wrote:
You mean I can make up a name for a "semantic tag,"
designating every nicknname or every
emphasized word , for example?
Yep, XML lets you create your own DTD/schema -- though sometimes it
makes sense to use (or leverage) an existing one.
And is this something that can only b
can only be done with XML?
I do recall reading that XML is a very flexible
language that lets you create your own codes, styles,
etc. Am I correct in guessing that the pros prefer XML
to HTML or XHTML when working with MySQL?
If so, that's another thing for me to learn. I've
found
can only be done with XML?
I do recall reading that XML is a very flexible
language that lets you create your own codes, styles,
etc. Am I correct in guessing that the pros prefer XML
to HTML or XHTML when working with MySQL?
If so, that's another thing for me to learn. I've
found
David Blomstrom wrote:
Some time ago, I posted a question about using HTML in
MySQL tables.
Someone suggested this is a bad strategy, asking what
I would do if I later decided to change the italicized
words to bold, for example.
I'm just trying to figure out what the options are, as
we
Some time ago, I posted a question about using HTML in
MySQL tables. For example, if I put the following in a
table cell...
Cowboy State (reinforced by logo depicting
cowboy on bucking bronco), Big Wyoming
It will be displayed as...
Cowboy State (reinforced by logo depicting cowboy on
bucking
Josh Trutwin writes:
>Javascript is a client-side language, the code is executed by the user's
>browser. It has no way to connect to the database server and run queries
>so you need to use a server-side programming language like Java (JDBC),
>PhP, Perl, etc. Tomcat is a decent servlet engine wi
Josh Trutwin writes:
>Javascript is a client-side language, the code is executed by the user's
>browser. It has no way to connect to the database server and run queries
>so you need to use a server-side programming language like Java (JDBC),
>PhP, Perl, etc. Tomcat is a decent servlet engine with
.
-Original Message-
From: My Sql
To: [EMAIL PROTECTED]
Sent: 5/5/04 11:18 AM
Subject: Html and mysql..
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it is
possible, we have to right in javascript.
ofcourse we can write it using JDBC
On Wed, 5 May 2004 09:18:01 -0700 (PDT)
My Sql <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have got one serious doubt.
> Can we access mysql database from the front end html. If it all it
> is possible, we have to right in javascript. ofcourse we can write
> it using JDBC(provid
Javascript is a client side language. I seriously doubt it alone would do
anything for you.
My Sql <[EMAIL PROTECTED]>
05/05/2004 12:18 PM
To: [EMAIL PROTECTED]
cc:
Subject: Html and mysql..
Hi all,
I have got one serious doubt.
Can we access
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it is possible, we
have to right in javascript.
ofcourse we can write it using JDBC(provided we have a servlet engine integrated with
a webserver).
My question is can we access mysql database
Hi all,
I have some questions I thought people might be able to enlighten me on.
I have a database of website content that I have inherited that is
full of standards-killing html (about 500 website pages; long story). I
would like to change that, but its a job that is a little too big for
The double quotes have meaning in HTML. You might be confusing the parser. Try
replacing your double quotes with ".
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I seem to be having some problems regarding HTML in Longtext fields - I
think it is something to do with the fact that I have items in double quotes
in the field.
As an example, the html will have double quates along the lines of:
When I pull the field out of the database via the Application
On Thursday 18 December 2003 17:46, Paul Godard wrote:
> Hi
>
> I build a online catalog linked to mysql db.
>
> Now my client wants the site on a cdrom.
>
> What is the fastest way to convert the product pages into static html
> format?
--
wget --mirror ?
--
MySQL
Hi
I build a online catalog linked to mysql db.
Now my client wants the site on a cdrom.
What is the fastest way to convert the product pages into static html format?
--
Kind regards, Paul.
Gondwana
[EMAIL PROTECTED]
http://www.gondwanastudio.com
--
MySQL General Mailing List
For list archives
Dear Prashant,
This list is for MySQL questions, rather than PHP questions. Please try
the PHP general mailing list ([EMAIL PROTECTED]).
Cheers!
--
Zak Greant
MySQL AB Community Advocate
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
> -Original Message-
> From: Prashant A [mailto:[EMAIL PROTECTED]
> Our Site is running on Linux/Apache/PHP/MySQL Combination.
> I am unable to retrieve the Values passed from HTML
> FORM(test1.html) in a PHP Page(test1.php)
>
> Is it something to do with the Web S
To: <[EMAIL PROTECTED]>
thnyou.com> cc:
Subject: Unable to Retrieve HTML Form
Values(
Dear Sir
Our Site is running on Linux/Apache/PHP/MySQL Combination.
I am unable to retrieve the Values passed from HTML FORM(test1.html) in a PHP
Page(test1.php)
Is it something to do with the Web Server Settings or any thing else...?
The code is as follows;
Test1.html
Test
This site:
http://www.everydaysoftware.biz
Has a complete MySql and Html development environment running on the browser
site itself, with debug, edit, run capability.
To gain access to the development environment, click Develop on the left from
of the opening page.
The environment is
t; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, August 08, 2003 5:31 PM
Subject: RE: Can MySQL 4.0.14 store HTML? Among other things
> [snip]
> Hey. I'm New (as you probably can tell), and I was wondering if MySQL
> 4.0.14
> can store HTML, PHP, JavaScript an
Hey. I'm New (as you probably can tell), and I was wondering if MySQL 4.0.14
can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it would
be stored as a string, and if outputted by PHP, would it output as HTML? (Or
JavaScript, PHP, or Flash)
Thanks!
--Machiste&#x
Yes, you can store HTML, Javascript, and Flash code in MySQL (since they are
processed by the client web browser).
And yes, you can store PHP code in MySQL, but since this has to be processed
on the server side you need to use the eval() function to execute it once it
is retrieved from the
[snip]
Hey. I'm New (as you probably can tell), and I was wondering if MySQL
4.0.14
can store HTML, PHP, JavaScript and/or Flash. Can it? I'm assuming it
would
be stored as a string, and if outputted by PHP, would it output as HTML?
(Or
JavaScript, PHP, or Flash)
[/snip]
Yes, you
the excellent book:
"Web Database Applications" by Oreilly.
It is the perfect beginners guide for this area.
Good luck.
-Original Message-
From: Machiste' N. Quintana [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 3:29 PM
To: [EMAIL PROTECTED]
Subject: Can MySQL 4.0.1
t; dbh.execute("UPDATE rss_item SET cached = '1' WHERE url =
> %s",(url,))
> - Have you tried this with *short* HTML documents? What happens?
>This would help you determine whether it's a length-of-data issue.
> - Let's see an actual error message (at
At 20:49 -0700 7/17/03, Nick Arnett wrote:
My hair... I am ready to tear it out. I've been working with Python and the
MySQLdb module for a long time, thought I couldn't get snagged by anything,
but today I just can't seem to persuade the blasted thing to let me stick an
HTML doc
My hair... I am ready to tear it out. I've been working with Python and the
MySQLdb module for a long time, thought I couldn't get snagged by anything,
but today I just can't seem to persuade the blasted thing to let me stick an
HTML document (a string) into a TEXT column. I'
of arachnid!
Renee :)
-Original Message-
From: Tore Bostrup [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 1:58 PM
To: [EMAIL PROTECTED]
Subject: Re: I'm not sure if this is HTML question or PHP...
The technique you are looking for is usually referred to as "recordset
pag
tchin'" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 11:48 AM
Subject: I'm not sure if this is HTML question or PHP...
> I've had great success with my first PHP/mySql project. It's a catalog to
> showcase my embroidery des
I've had great success with my first PHP/mySql project. It's a catalog to
showcase my embroidery designs. My embroidery database is working, the php
code I embedded in my FrontPage2002 pages is working great, I can click on
my admin button and upload info into the database.
Because of the pictur
on 01/13/2003 2:10 PM, Scott Haneda at [EMAIL PROTECTED] wrote:
>> How do you know this isn't simply a failure of your terminal window
>> to display the character properly? That's the most likely problem
>> here, not that your data are stored incorrectly.
Correct you are, the data in MySql was c
abase, one table, and say one field, varchar(14) and
in it I put hello®, I use html input form elements and a middleware called
WebSiphon, I have also done this in php with phpmyadmin as well, the
character shows up on display in the Browser as a "registered mark", as well
as in phpmyad
rtain, I just did a dump to a text file and here were
the results... As you can see the pesky Æ is in place of the ®, which really
makes no sense to me, as in a browser is displays as a ®, but if I do a
string replace on the ® it does not see it as one, so it wont replace it
with the html entity
14) and
in it I put hello®, I use html input form elements and a middleware called
WebSiphon, I have also done this in php with phpmyadmin as well, the
character shows up on display in the Browser as a "registered mark", as well
as in phpmyadmin, all good so far.
Now, in my shell in the m
You have it right. But if the user searches for new power boats, and
doesn't specify a make, make should not appear in your WHERE clause. The
query has to be different depending on the criteria that have been
chosen (or not chosen, as the case may be). Prior to executing the
query, look at all
1 - 100 of 151 matches
Mail list logo
