Help Please

DrivingInfo

I will probably get slated for asking such a basic question! But where or what do I do with the sql code once I have writing the query.:o:o:o:o:o

I’m learning how to build databases for myself and this has me stumped.

ronivek

Well generally you use some form of query browser or alternatively you could write a little snippet of code to execute the query.

You really need to supply a bit more information for me to be of any help; what database software do you intend to use? Are you trying to perform a query in a particular language or context? What exactly are you trying to do?

DrivingInfo

I’m using MySqL.
I can build the admin form but don’t know what I do with the sql query (code).

In the Admin I need to add new, update, delete, and search, I also need to display information from within the database.

Lets say I have a button and need the button to run a query, HOW do i do this WHAT do I do with the query or code.

Even if you could tell me how to tie sql to the form would help.

BostonB

You need to make a connection to the database. The query it and return the results into something like a dataset which you can then bind to a datadrid. Well thats one way.

http://www.homeandlearn.co.uk/NET/nets12p5.html

DrivingInfo

What is the most straight forward way of doing it (the best way with fastest return?)

BostonB

I forgot you are using MySQL, I don't use that myself. Why is speed an issue at this point? Get it working first.

DrivingInfo

BostonB wrote: »

I forgot you are using MySQL, I don't use that myself. Why is speed an issue at this point? Get it working first.

Ill try to work it the way you have suggested.

I don’t want to do the work and then find out that there is a better way of doing it with faster returns on the query.

Thank you

MrVestek

DrivingInfo wrote: »

Ill try to work it the way you have suggested.

I don’t want to do the work and then find out that there is a better way of doing it with faster returns on the query.

Thank you

That's lazy programming right there. Programming is all about trial and error. Get the program working first then work on speed issues.

BostonB

How you write the query and how the database is designed, is likely to have a far greater effect then how you connect to it.

Maybe theres a better way for MySQL and maybe data binding/data grid isn't what you need. But only you will know that answer.

marco_polo

Simplest way is to use the query browser that comes with MySql . You should see it in the program files menu under MySQL. Enter the database, schema, username /password that you want to to connect to.

Once this is done paste your queries in the window and press the execute button.

** Edit ** Ok this seems to be more of a language specific programming issue, and you haven't even stated what language you will be using to create the form that will connect to the DB. Is it .net, java php?

Cantab.

to OP:

Download MySQL and install.

Open a command/terminal window and type: 'mysql'

Away you go.

BostonB

I've just realised the OP may not be programming. I just assumed that since this is the programming forum.

DrivingInfo

I am using MySQL and Use php.
What I don’t understand is how the query is connected to the php document.

ethernet

DrivingInfo wrote: »

I am using MySQL and Use php.
What I don’t understand is how the query is connected to the php document.

The results of your query are stored in an array after you use the special PHP functions to connect to a MySQL server. You pick what you want out of it (loop through it). Think this is what you've asked

Mach

DrivingInfo wrote: »

I am using MySQL and Use php.
What I don’t understand is how the query is connected to the php document.

Ok go down to your local book shop or head over amazon and get Begining PHP an MySQL5 from Apress

marco_polo

Decent basic tutorial here should give you all the basics of php to my sql.

http://www.databasejournal.com/features/mysql/article.php/1469211

thebaldsoprano

Hi OP

If you just want the thing to work and aren't that interested in the details of embedding your SQL in another language I think Dreamweaver might do that.

You'd defo want to double check this though, the only part of Dreamweaver I've seen is when debugging some PHP it generated for a friend of mine.