> You should not have quotes around the column names.
Yea. that was the problem...
'color' a was trivial error !
i got it at home after office hours!!! Seems that a break is necessary when
things go wrong !!!
Thnx
Nadim Attari
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Craig:
I don't see a reply to your question in today's posts.
"Backticks" or "tick marks" allow you to use reserved words for column names. Interval is a reserved word.
Hope you weren't waiting this long for a response.
Doug Thompson
Craig Hoffman wrote:
Why is it when I have this ` tick mark i
Ok, I'll consider it... But just, please, could you give me an example code
of what I want to do?
Thanks a lot.
"Bruno Santos" <[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
> Daniel Crespo wrote:
>
> >Hi everybody...
> >
> >Anyone knows how to store a file (any type) in MySQL?
Hello,
New and improved Metastorage documentation materials were released with
the intention of helping developers to get started with this software
development productivity tool and quickly deploy their PHP applications.
Besides the Metastorage reference manual that already existed and was
im
On Mar 23, 2004, at 1:42 AM, Hans Lellelid wrote:
After a long period of quite intense development, the Propel team is
pleased to announce the release of Propel 1.0.0-alpha1.
I haven't studied the project thoroughly yet, but I must say that your
website looks very nice. Especially when you compar
After a long period of quite intense development, the Propel team is
pleased to announce the release of Propel 1.0.0-alpha1.
Propel is an object persistence layer for PHP5 based on Apache Torque.
In practical terms, Propel allows you to use objects instead of SQL to
read and write rows in your data
Desi wrote:
I need a module in PHP to get the rates from this
service, the tools are in XML but I need the module
in PHP, to give the size and the weight and get the
rate from this module.
If you have work with this, please help me, or tell me
if you can made it, how much will cost, and the time
y
You have also this IDE : http://www.codecharge.com
--
Click below to answer / cliquez ci dessous pour me repondre
http://cerbermail.com/?MQkxTL4vUP
"Michal Masa" <[EMAIL PROTECTED]> a écrit dans le message de
news:[EMAIL PROTECTED]
> Hi,
> We plan to write a simple DB with app. 10 tables. Are t
I need a module in PHP to get the rates from this
service, the tools are in XML but I need the module
in PHP, to give the size and the weight and get the
rate from this module.
If you have work with this, please help me, or tell me
if you can made it, how much will cost, and the time
you can send
From: "Brock Jimmy D Contr DODHSR5" <[EMAIL PROTECTED]>
> When you want to display this value from the database onto your webpage
use stripslashes
>
> stripslashes($row['q']; // this will remove the backslash that was
inserted from addslashes
You don't need to use stripslashes on the data pulled
Rene,
Here are my thoughts:
In general don't ever use "select * ..." yes it works fine but it's cleaner
to always spell out the columns you expect. Also you are often returning
data you don't need (overhead for the server). If you ever alter or add a
column you could mess up your code but not g
In your sample code the value is being truncated because size="2" -- so only 2
characters are being assigned to $_POST['Q']
Addslahses should work...
Based on your example here is how (I changed the size to 50:
And my user enters:2 " copper tubing
$q = addslashes($_POST['Q']; // new valu
-{ Rene Brehmer }- wrote:
I'm working with PHP 4.3.0 w. MySQL 4.0.14b on Windows XP
I've written my own (pretty advanced actually - or it will be once I get
the code completed) forum system (why? because I wanted to learn how to
handle relational databases with PHP/MySQL, and then I just decided
I'm working with PHP 4.3.0 w. MySQL 4.0.14b on Windows XP
I've written my own (pretty advanced actually - or it will be once I get
the code completed) forum system (why? because I wanted to learn how to
handle relational databases with PHP/MySQL, and then I just decided to
complete the thing) .
Why is it when I have this ` tick mark in my query it works fine, but
when I remove them it I get an error?
___
This tells to mysql to NOT treat the word as the reserved word that it
_may_ be, but use it literally. and interval, i believe, is a reserved
word. It is much like escaping
Why is it when I have this ` tick mark in my query it works fine, but
when I remove them it I get an error?
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 'interval, heartrate, morning_hr, hr_for_inter
From: "matthew perry" <[EMAIL PROTECTED]>
> Actually I think the problem is before you can use either addslashes or
> mysql_escape_string() functions. The value with " or ' never reaches
> the database. I think I need a way to ignore quotes for input values in
> HTML.
>
> Say I have this:
>
> A
Filip de Waard wrote:
On Mar 22, 2004, at 12:17 PM, Jimmy Brock wrote:
Matt, love your show!
Use the addslahses function to escape ' " \ characters. See
http://php.net/addslashes for details.
Actually, you shouldn't use addslashes, but a database specific
function like mysql_escape_string().
Nadim Attari wrote:
insert into cashmire ('itemcode', 'collection', 'promotion', 'bestSeller',
You should not have quotes around the column names.
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-
You are also trying to insert '8400' (characters) into a mediumint
(price)?
--Original Message-
> Hi,
>
> I have a table:
>
> CREATE TABLE `cashmire` (`id` smallint(3) unsigned NOT NULL
> auto_increment,
> `itemcode` varchar(25) NOT NULL default '', `collection` char(2) NO
Your field name is 'colour', you are inserting into 'color' ?
--Original Message-
> Hi,
>
> I have a table:
>
> CREATE TABLE `cashmire` (`id` smallint(3) unsigned NOT NULL
> auto_increment,
> `itemcode` varchar(25) NOT NULL default '', `collection` char(2) NOT
> NULL
> defa
I have a table:
CREATE TABLE `cashmire` (`id` smallint(3) unsigned NOT NULL auto_increment,
`itemcode` varchar(25) NOT NULL default '', `collection` char(2) NOT NULL
default 'cl',
`promotion` char(1) default 'n', `bestSeller` char(1) default 'n',
`newArrival` char(1) default 'n', `size` varcha
Hi,
I have a table:
CREATE TABLE `cashmire` (`id` smallint(3) unsigned NOT NULL auto_increment,
`itemcode` varchar(25) NOT NULL default '', `collection` char(2) NOT NULL
default 'cl',
`promotion` char(1) default 'n', `bestSeller` char(1) default 'n',
`newArrival` char(1) default 'n', `size` varch
On Mar 22, 2004, at 12:17 PM, Jimmy Brock wrote:
Matt, love your show!
Use the addslahses function to escape ' " \ characters. See
http://php.net/addslashes for details.
Actually, you shouldn't use addslashes, but a database specific
function like mysql_escape_string().
http://phundamentals.nyp
Matt, love your show!
Use the addslahses function to escape ' " \ characters. See
http://php.net/addslashes for details.
Jimmy Brock
"Matthew Perry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I am trying to allow my users to enter quotes in their strings. For
> instance inste
25 matches
Mail list logo