From: Date: July 24 2004 5:04am
Subject: Re: Question about Insert Statement
List-Archive: http://lists.mysql.com/win32/15248
Message-Id: <20040724030440.30661.qmail@web60807.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1723690210-1090638280=:30622"

--0-1723690210-1090638280=:30622
Content-Type: text/plain; charset=us-ascii

use \"$leaName\" instead and the rest of variables

Danny Willis <danny.willis@stripped> wrote: My question/problem I am having is that there may be cases where I do not
have all the fields full. From my experimentation and interpretation of the
documentation if the fields are full and I end up with a query looking like
this:
INSERT INTO $db_s_leagues (leaName, leaEmail, leaOwner, Address, City,
State, Zip, DateStarted) 
VALUES('$leaName','','$leaOwner','$leaAddress','$leaCity','$leaState',$leaZi
p,)

The query fails due to the "''" and the ",)"

Is there a way to work around this issue so I don't have to code up some
funky error checking in my php code to check and adjust for any empty data?

Here is the query I am working with:

INSERT INTO $db_s_leagues (leaName, leaEmail, leaOwner, Address, City,
State, Zip, DateStarted) 
VALUES('$leaName','$leaEmail','$leaOwner','$leaAddress','$leaCity','$leaStat
e',$leaZip,$leaDateStarted)

Thanks,
Dan 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=tatarespecia@stripped




		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
--0-1723690210-1090638280=:30622--