RE: [PHP] Unknown Table i field list

2010-10-12 Thread Tommy Pham
-Original Message- From: Kranthi Krishna [mailto:kranthi...@gmail.com] Sent: Monday, October 11, 2010 5:40 PM To: Gary Cc: php-general@lists.php.net Subject: Re: [PHP] Unknown Table i field list echo $query; before $result = mysqli_query($dbc, $query); might be of help

Re: [PHP] Unknown Table i field list

2010-10-11 Thread Ashley Sheridan
On Mon, 2010-10-11 at 15:46 -0400, Gary wrote: I used, and have always used phpmyadmin to create the tables. As I say, it is not the first time doing this, but I believe it is the first time getting the error. To Alexander, yes I had, ,in fact I simply C/p the script from anohter

Re: [PHP] Unknown Table i field list

2010-10-11 Thread sueandant
Have you tried : $query = INSERT INTO formcom(fname, lname, email, comment, ip) VALUES ('$fname','$lname','$email'.'$comment','$ip') or die('error in query'); tholland - Original Message - From: Gary gp...@paulgdesigns.com To: php-general@lists.php.net Sent: Monday, October 11, 2010

Re: [PHP] Unknown Table i field list

2010-10-11 Thread a...@ashleysheridan.co.uk
That's the same query. One thing I did notice (and I wasn't sure if it was a typo as I saw a few in the original post) but you've used a period instead of a comma to separate the values in the query. It shouldn't produce the error you're seeing, but sometimes you never know! Thanks, Ash

Re: [PHP] Unknown Table i field list

2010-10-11 Thread Gary
sueandant hollandsath...@tiscali.co.uk wrote in message news:4c8c262adea3459d815fe3e70ae10...@sueandantpc... Have you tried : $query = INSERT INTO formcom(fname, lname, email, comment, ip) VALUES ('$fname','$lname','$email'.'$comment','$ip') or die('error in query'); tholland -

Re: [PHP] Unknown Table i field list

2010-10-11 Thread Gary
Ashley I have used the concatenation before and I believe that since I closed the INSERT INTO with a , I needed to add the . for the VAULES. My post is laced with typo's, I just came back from an impromtu hosptial stay and they had given me the good stuff,so I was a little cloudier than

Re: [PHP] Unknown Table i field list

2010-10-11 Thread Kranthi Krishna
echo $query; before $result = mysqli_query($dbc, $query); might be of help to understand what is going wrong copy that query and execute in phpMyAdmin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php