Could someone please tell me what I'm doing wrong?

cdub1988

I've posted a couple of sets of code for inserting form data into a mysql db......I've successfully setup this same system with a different db and fields, but when I redid the new files with different fields and different table, I can't seem to get the INSERT to work and was wondering where I went wrong in the code......

Could someone please look at these two links and tell me where I went wrong?

First set of code

Second set of code

Thanks!

bubblenut

Could somone tell me what I'm doing wrong?

Shotguning. Please only post your question in one forum. Delete one of them and then I'll read your post.

Read here for more forum guidlines.

Cheers
Bubble

cdub1988

bubblenut-

Sorry about that......I didn't mean to cause a problem on the board.

I'm very new to php and mysql as I'm sure you've gathered and after getting an initial setup working with inserting, editing and deleting records, have been unable to reproduce it with a different db and fields.

I would really appreciate any feedback, and again, I do apologize.

bubblenut

No problem buddy, just trying to keep the boards tidy 🙂

Rather than just giving you and answer (mainly because I haven't the time to look through the code right now) I'll help you debug it yourself.
If you replace this line

$result = mysql_query($query);

with this line

$result = mysql_query($query) or die("Query: ".$query."<br />\nError: ".mysql_error()."<br />\n");

your script will output the query and the mysql_error generated if the query fails. Post back and let us know how you got on.

Cheers
Bubble

cdub1988

OK, I'll give it a shot....thanks!

cdub1988

bubblenut-

I got an error message that said:

Query: INSERT INTO requests (reqdate, first, last, etc., etc., etc.....) VALUES (the values.....)

and then said:

Error: You have an error in your SQL syntax near 'int1, numint1, int2, numint2, int3, numint3, int4, numint4, int5, numint5, int6, numint6' at line 1<br />

I looked at the source doc (insert.php) and there isn't anything on line 1 of that file, so I guess I'm at a loss as to whether it's in the actual INSERT statement syntax or what.

Any ideas?

Thanks!

bubblenut

Yes, the syntax error is in the atual insert statement.
Try placing backticks (`), which are found to the left of the number 1 on a qwerty keyboard, around each of the field names. I think it's because you're using reserved words (albeit with numbers tacked on the end) such as int. Out of interest, why are you using names like int1, int2? Are there no, more descriptive, names which could be used instead? Having such ambiguos names could make the designe difficult to understand in the future.
Could you post up the entire error message (query and mysql error) as well please?

cdub1988

bubblenut-

So use the ticks instead of the single quotes?

I can use longer field names, I just didn't want to do that if I didn't have to.....I can sure change them, though, if it would help.

Here's the error......:

Query: INSERT INTO requests (reqdate, first, last, street, busaddress, city, state, zip, phone, email, howheard, int1, numint1, int2, numint2, int3, numint3, int4, numint4, int5, numint5, int6, numint6, int7, numint7, int8, numint8, int9, numint9, int10, numint10, int11, numint11, int12, numint12) VALUES ('July 27, 2004', 'Jane', 'Doe', '123 Main', '', 'Atchison', 'KS', '66002', '913-367-0987', '', 'live here', 'Amelia Earhart', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
Error: You have an error in your SQL syntax near 'int1, numint1, int2, numint2, int3, numint3, int4, numint4, int5, numint5, int6,' at line 1

Does that help?

Thanks!

cdub1988

bubblenut-

Got the INSERT statement working....I went ahead and changed the field names like you suggested and now I can at least insert records.

I'm going through the update function now to see where the problem is with it.....

Thanks so much for your help.

If I still have problems with the update, can I repost....?

Thanks!

cdub1988

OK, either I've been looking at this code too long, or I'm just missing something (more than likely)......

could someone take a look at this code and tell me if something looks terribly wrong?

I can't seem to find out where it's having the problem, and I'm not getting any mysql error or anything, just the confirmation echo message, but the update is not being made......

any ideas?

Thanks!