database not connecting

database not connecting to order page

[amythepoet]

Please please, I need help and Now I am not a php programmer and need immediate help!

thank you

[Readie]

Well, not really much to go on here. With no more specific appraisal of the situation the best I can do is direct you to the following functions:

mysql_connect('localhost', 'USER_NAME', 'PASS_WORD');
mysql_select_db('DATABASE_NAME');
mysql_set_charset('CHARSET_USED_WITH_DATABASE');

Replacing the capped words with relevent substitutes.

[amythepoet]

Oops, I thought I fixed it but now here's the scoop

I get this error:

localhost
Error

SQL query:

INSERT INTO (

)
VALUES (
), (
)
MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() VALUES (), ()' at line 1


Now what? I t seems that my web host made back up of the database so now i have two databases and the customer was getting the wrong prices, so I changed both databases to reflect the current prices, but still things are not right and I am not a programer and my programmer flew the coupe years ago!

[Readie]

That means the SQL query you are trying to execute is not worded correctly. If you could paste that we'll take a look at it.

[amythepoet]

I do not know w hat to paste or where to look, but I can pull up both databases and see if I can find something called SQL query one moment, thank you

[amythepoet]

I still do not know where to look, all I know is that if I were to try and edit my products or questionnaires in my database, I would go like this:

www.widgets.com/pma

now when I put in www.widgets.com/pma, the computer adds: /tbl_replace.php

[amythepoet]

I found something called My SQL but I don't know what to do with it

[Readie]

The SQL query would be contained somewhere within the PHP code. Going by the error you posted earlier, it'll be an INSERT query.

[amythepoet]

an INSER query, ok, so I should look at the code on the php page, correct?

[amythepoet]

I f ound this: <!-- BEGIN ORDER FORM INSERT -->

[amythepoet]

Then I found this: <!-- END ORDER FORM INSERT -->

[Readie]

Those are HTML comments.

An INSERT query would look a bit like this:

INSERT INTO something_here (some_column, some_column) VALUES ("Some value", "Some value")

Note: The syntax is a bit flexible, just do a ctrl+F and look for INSERT INTO (Don't force-match the case, can be upper or lower)

[amythepoet]

ok, I will try, right now

[amythepoet]

the words INSERT into are not found, maybe I am looking in the wrong file?

[amythepoet]

I'm looking in my database for the words INSERT INTO, as I said, I am not a programmer, this is greek to me

[amythepoet]

I am looking in something called PHP MY ADMIN, I guess that's the wrong place, I need help

[mack]

What is the name of the php script you are using?

Mack.

[amythepoet]

Name of the script? you got me, I saw something it said apache could th at be it?

[amythepoet]

I don't even know where to look, I have a straight payment form, no shopping cart, and a database, called pma, I don't know what that stands for

[amythepoet]

and tis' very funny, I am on a Mac and when I put in the name of my url, lets say rocketsandwidgets.com, I put rocketsandwidgets.com/pma
and by some magical thing, I get /pma/tbl_replace.php at the end of the line even though I did not put it in there

However, if I am in Firefox, and I put in rocketsandwidgets.com/pma

I just get simply that rocketsandwidgets.com/pma and I am able to see my database and everything is fine then

[amythepoet]

wait a sec, in MY SQL, which is inside of the pma database, I believe I found this:

var querywindow_height = 400;
var querywindow_width = 600;


does that help?

[amythepoet]

I am getting soo tired, that I can barely keep my eyes opened, I think I w ill have to go to sleep and look at this when I get up, ok? ok, thank you

[amythepoet]

Oh, I just found something else, it says MySQL client version: 5.0.51b, I hope that helps