jhenrichs

Implies your going to be having more then one website or perhaps be interacting with multiple websites? Not quite sure. You need to clarify your intentions. What the fuck? I think your saying you want to SELECT data from a table and display it in a textbox? Unless its a random message, displaying in a textbox isn't particularly advisable. Elaboration on this is definitely required. By "queries they load" I would assume you mean "data from the database the end user loads"? From the sounds of it, your database is very simple, not extensive. You need to be far clearer in your descriptions and must stop using "this/that/over there" because we've no idea what your talking about; English may not be your native language and I think we all appreciate that here but we can't help unless your more specific. Finally, what's the problem? I can't really see anywhere you've specified any sort of issue or asked for any sort of help? With regards to the links you've posted you look like your heading the right way but you definitely need to pick up a book and get the basics before attempting anything complex - although this doesn't sound overly complex. Be clearer Define your questions clearly so we can help you as much as possible with the route problem Start reading and post questions about things you don't understand in your book I am not so good at explaining things, I am work for a small telecommunications company and we have service in several towns, so what I am wanting to do is create a database that stores settings for each piece of network equipment in each town, so I will be having multiple html pages to load a SQL query for each piece of equipment that we have, so pretty much it will be multiple html pages connecting to one big database. As for your second statement, if you would have fully read my full post, you would have seen in my third paragraph that I want to be able to update the queries and I am no html expert, but in the years I have been doing html, the only way I have found to edit or submit text would be in a text box, thus explaining why I would want to load the query information into text boxes. Seems logical to me but maybe I am missing something? The main reason for me posting is to see if it is possible, I know its possible to load a SELECT query, what I am unsure of is how to do an UPDATE statement to save any information that they update. I will try to explain it better. Say I have a link that says "ACME Router" they click on that and it will load a query that has information about that device such as IP address, subnet, gateway, name, location, firmware version, etc. Say Johnny updated the firmware and needed to update that field, I want him to be able to update that info in a text box and then hit an update button that will save that updated information back to the database. Maybe putting it that way would make more sense so you are able to understand it better?

This might be in the wrong forum because I have yet to write any code, but I kind of brainstorming/planning at the moment. What I am wanting to do, is to make quite an extensive database for work. I am going to be using php/html to make the actual website and what I am wanting to do is use text boxes to load a query when they go to the respective website, in theory, all I should have to do is have an sql connect statement as well as an sql select statement to select the data that I want, I would then have to map that data to load the data to the text box (if I am correct ) I am thinking the correct statements I would be using are this: http://www.w3schools.com/php/php_mysql_connect.asp AND this: http://www.w3schools.com/php/php_mysql_select.asp The second thing that I would like to be able to do, would be to allow users to edit and save information from the queries that they load. It would be using some kind of update statement like this: http://www.w3schools.com/php/php_mysql_update.asp But I am not sure how I would go about doing that, or if that would even be possible. Any help or links to websites would be a great help, I do have "PHP Solutions: Dynamic Web Design Made Easy" by David Powers on order, so I am hoping that will be of some help.

ok, right now you are my hero!! I did set it to root and null for the password and that made it work! Granted I don't want to leave it at that because I would like it more secure, but I got the page to come up for once! But yes, my code does have the actual database username and password but permission wise I must still have something wrong but I can't find out what.

Hello, I am VERY new to PHP but I am trying to teach myself it so excuse me if I don't make sense. What I am trying to do at the moment, is to create a website with a log-on page, so to start out with, I setup WAMP on a Windows 7 machine, I have that up and going. So my next step was logging into phpMyAdmin and creating a new database named "diode" I then proceeded to go under privlages and then created a username and password with all privlages for that database yet my php code can't access it, so I have no clue what I am doing wrong. I will post my sql connection code below as well as the error message I am getting. PHP Code $connection = mysql_connect("127.0.0.1","username","password") OR die(mysql_error()); $db_select = mysql_select_db("diode",$connection) OR die(mysql_error()); Error Message ( ! ) Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'username'@'localhost' (using password: YES) in C:\wamp\www\index.php on line 3 Call Stack # Time Memory Function Location 1 0.0019 684760 {main}( ) ..\index.php:0 2 0.0019 685048 mysql_connect ( ) ..\index.php:3 Access denied for user 'username'@'localhost' (using password: YES) Any help at all would be greatly appreciated!