From: Date: July 23 2004 11:36pm
Subject: Question about Insert Statement
List-Archive: http://lists.mysql.com/win32/15246
Message-Id: <E1Bo7dz-0003Fv-K7@da005.wh01.infopop.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

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