RE: help with insert +php

2006-09-02 Thread Dinçer Akay
Hi, Protect your database http://www.php.net/manual/en/function.htmlspecialchars.php PHP Security Consortium http://phpsec.org/ Protect SQL Injection Attack See more http://www.php.net/manual/en/function.mysql-real-escape-string.php The query sent to

Re: help with insert +php

2006-09-01 Thread Gaston Sebastian Marengo
#x27;email1'],$_post['email2'],$_POST['$web'],$_POST['casilla'],$_POST['observaciones'])"; -Original message----- From: Marcelo Fabiani [EMAIL PROTECTED] Date: Fri, 01 Sep 2006 15:27:19 -0300 To: Jerry Schwartz [EMAIL PROTECTED] Subject: Re: h

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
Chris W escribió: Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there an

Re: help with insert +php

2006-09-01 Thread Chris W
Marcelo Fabiani wrote: Here is the code: . . . $result = mysql_query($sq)or die ("problema Leyendo Tabla");; . . . Why are there two ; at the end of that line? I'm really not sure what if anything that will do but I would remove it just in case. Also are there any triggers on this

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
John Meyer escribió: Try this $retval = mysql_query($sql) or die(mysql_error()) To at least get an idea of what MySQL thinks is the error. The is no error in the insert it adds the row, but in addition add's two more rows with no data, only the auto_increment ; Example: Adds 1 Marcelo

Re: help with insert +php

2006-09-01 Thread dpgirago
> [EMAIL PROTECTED] escribió: >> Marcelo, >> >> The usual advice is to echo out the query string and examine it for syntax. >> Assuming it has form data in it for the variables, then try copying/pasting >> it into the mysql client and run it from there. Let us know how that goes. >> >> David >> >

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
[EMAIL PROTECTED] escribió: Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David Already done that

Re: help with insert +php

2006-09-01 Thread dpgirago
Marcelo, The usual advice is to echo out the query string and examine it for syntax. Assuming it has form data in it for the variables, then try copying/pasting it into the mysql client and run it from there. Let us know how that goes. David -- MySQL General Mailing List For list archives:

Re: help with insert +php

2006-09-01 Thread Marcelo Fabiani
Jerry Schwartz escribió: I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.879

RE: help with insert +php

2006-09-01 Thread Jerry Schwartz
I don't see the form. Unless one of your included files sets the values of your variables, this code will insert a row of empty strings every time it executes. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 ---