Im new to mysql and i need to know how to make tables and such for use, well, because i dont know how, and if i cnat make tables, that aint gonna get me very far . And i need a tutorial that doesnt use a SQL dump file method, becuase the only way i can make tables on my server is with a form in my Control Panel, that loosk similiar to the one in myPHPAdmin. Any links could help.
quite honestly, i've found that the from the mysql command line is really the best way to learn.... it's so easy to toy around with different queries. if you can get to a command line by traditional means, try the untraditional.... http://www.webmasterbase.com/article/627
Well, I've yet to find mysql/php instructions that give you the basics. I don't wish to be a programmer and don't need to know mysql history. All I want to do is to take a code that someone else has generously written and know what to do with it. In other words.... they give you the .php example (easy enough) the the mysql code... BUT, where do I put the mysql code, what do I call it as in xxxx.mysql or what? That's it, just the basics, and not a single instruction site tells you this and if they do it's hidden somewhere in there amongst the gobbldy goop.
For example, users online (which I need!) is 2 pages of code. One .php and one mysql table. God forbid anyone would tell you exactly where to put it on your server and make it work. It's not that hard I know. In fact, it's too simple, but without a map it doesn't work. It's probably 5 minutes of work to do and yet I just have no idea where to put the table and what to name it.
If anyone doesn't mind the fact that I do not wish to be a programmer, could you please give me this tidbit of info? I would so greatly appreciate it. And, in reference to this topic. If anyone does know of a site for mysql/php instruction that give you this kind of very base info, I would appreciate that, too. I just don't have the time to learn a whole other code set. I do currently use php for form to email applications. Took me about 5 minutes to figure that out, so I know this is not hard stuff. Thanks!!!!
if you say it's not so hard, then why not leanr a little more and create the programs you need yourself? Everyone here likes writing their own code, but I doubt anyone will take the precious time out of their day to write an entire script for someone (for free even)... it's just not gonna happen.
As a personal comment, I think you DO have to learn more. What you ask for are not the basics. You need to have more broad knowledge to do what you want to do, not just "write this and do that". If something goes wrong, or if you need to change something, even just a little, What will you do?
Again, that's just one of my personal beliefs (and I do like to learn the most I can about what I do/use).
I don't want anyone to write the code, I have the code... the php and the mysql table, I know what to do with the php, I just don't know what to do with the code I have for the mysql table. From what I have read, it sounds easy enough, but the basics are never in the instructions... i.e. name mysql table "this.xyz" and put it "here" on your server. Once I do it, the rest will comes easy, that's how I learn, trial and error and by doing it, not reading about it from instructions that always assume you've done this before.
Sorry if I came across a board that is exclusively for programmers who already know everything, didn't mean to trample in your domain. But after spending months trying to get one very stupid piece of information, it seems noone else knows either. Thanks anyway.
if you have the dump(code) from a mysql table, then the easiest thing to do would be to have phpmyadmin (most hosts do i think) and there's an option to make a table based on that code. mysql isn't just files name abc.xyz and placed somewhere. there is actual synatax to putting a table somewhere. and it does involve what some might call programming whethere you like it or not. if you don't have phpmyadmin, then it's all command line stuff (even doing mysql through php is command line, in my opinion) and if that's the case, you'll have to learn more than putting a file somewhere.
i'm not here to bash you because you're new or anything like that. i'm new myself. just realize that the reason you haven't found where to put a .mysql file (no such thing as i know it) is because it doesn't work that way.
Thank you. That was actually helpful. As I said, I have not been able to find instructions that give you the basics. A place to start and walk you through it in english. So that you atleast know what questions to ask. Everything I've read so far makes it sound like you simply connect the php to the mysql database you create. If I could just get started I'll figure out the rest. Apparently it's not as simple as they make it sound from what you say. I can appreciate that.
I did not mean to bash anyone either, but when you've read all you can and it still isn't making any sense you go to where someone knows and should hopefully know enough to relay that info in plain english so that atleast something of what you read clicks. If these boards are only for seasoned programmers then it really should say so. It takes a certain amount of courage for a novice to ask a stupid question. Responses should not be made to make that person also feel stupid.
Anyhow, I just wanted to thank the last posters for their trying to be helpful. So long
Most people here aren't trying to make novices look stupid. Occasionally it does feel like you're answering the same questions over and over again so each answer gets less tolerant. That's not to say that it's fair on the newbie but you also have to cut the more advanced programmers a bit of slack.
I think one of the reasons that you've had trouble is because you are looking in the wrong place. Have a dig around for a MySQL tutorial. Although PHP and MySQL tend to go hand in hand most PHP tutorials assume that you already have the basics of MySQL database and table creation so start with the PHP bit - connecting to an existing database. However, a tutorial written especially for MySQL will probably be more useful to you.