The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
There you go Mod.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Just as you asked!
Anyway.
Does anyone know about MySQL and displaying the data in a table?
I've got a basic script to display it like this (http://www.phi11ip.com/mysql/display.php) but I want to be able to display it out of the rows and something like it shows at the bottom of the page...
Does anybody know how to do anything like this? If you can give me the general idea of what to do with a small example or a link to one I should be able to modify it and get it working...
Thanks.
Page:
phi11ip wrote:
> I know how to do it, just not how. If that makes sense!
Not really, but I think I know what you mean. Good luck with whatever you're building from it.
> I know how to do it, just not how. If that makes sense!
Not really, but I think I know what you mean. Good luck with whatever you're building from it.
Like what I've got at the moment.
I post the article and it's stored in the database, I then have a page of listing all the articles that I've posted.
Using the id=1 or whatever thingy in the title I can then allow people to open up that article.
I know the theory, but it's gonna be a sod to get working!
I should be able to do it though!
I post the article and it's stored in the database, I then have a page of listing all the articles that I've posted.
Using the id=1 or whatever thingy in the title I can then allow people to open up that article.
I know the theory, but it's gonna be a sod to get working!
I should be able to do it though!
I did a script like this a year or so ago. I'd send it to you if I still had it, but I don't.
It didn't take all that long to do. You've got the theory worked out and thats the main part of any script. Coding it shouldn't be a problem at all.
Though I would suggest including some sort of password protection on the script, to stop others from using it to post.
It didn't take all that long to do. You've got the theory worked out and thats the main part of any script. Coding it shouldn't be a problem at all.
Though I would suggest including some sort of password protection on the script, to stop others from using it to post.
I'll use a seperate page for the posting of stuff, I've got this login thing done for it...
Anyway.
http://www.phi11ip.com/mysql/jokes.php (When my site is up again!)
You click the joke (number) and it takes you to another page where it displays the body of text (3x that number).
When done properly it will have the joke text and you click it to view the info.
Anyway.
http://www.phi11ip.com/mysql/jokes.php (When my site is up again!)
You click the joke (number) and it takes you to another page where it displays the body of text (3x that number).
When done properly it will have the joke text and you click it to view the info.
How's it all going?
I've sorted the orignial script. (Main page of my site.) I've also got the jokes script working. (Click jokes!)
So thanks for helping with that. My next task is to work out how to call records from the database and edit them, although that shouldn't be too hard.
Oh, I soooo shouldn't have said that... Get ready for my next problem tomorrow!
But hopefully I'll be able to use the databases to update the football site I made so that it works well. I know what to do and having an understanding of using MS Access will make things far easier than if I didn't understand databases at all.
I'll keep you posted on any major breakthroughs!
So thanks for helping with that. My next task is to work out how to call records from the database and edit them, although that shouldn't be too hard.
Oh, I soooo shouldn't have said that... Get ready for my next problem tomorrow!
But hopefully I'll be able to use the databases to update the football site I made so that it works well. I know what to do and having an understanding of using MS Access will make things far easier than if I didn't understand databases at all.
I'll keep you posted on any major breakthroughs!
Just to let you know, at the footer of each of your pages where you have:
"Site designed by me, if you want stuff, ask me. If you want something like a video, take it. Just host it elsewhere!"
The link for the 'ask me' text contains 'index.php' twice. Hense the 404 when you click it (nice 404 BTW).
"Site designed by me, if you want stuff, ask me. If you want something like a video, take it. Just host it elsewhere!"
The link for the 'ask me' text contains 'index.php' twice. Hense the 404 when you click it (nice 404 BTW).
phi11ip wrote:
> So thanks for helping with that. My next task is to work out how to
> call records from the database and edit them, although that shouldn't
> be too hard.
Just a little pointer ... look into replacing SELECT with UPDATE when you make the MySQL Query.
> So thanks for helping with that. My next task is to work out how to
> call records from the database and edit them, although that shouldn't
> be too hard.
Just a little pointer ... look into replacing SELECT with UPDATE when you make the MySQL Query.
The link must have been broken for ages, still nobody tells me until today! You're the second person to point it to me today!
Must change that!
Must change that!
Excellent.
I've managed to do the edit script now!
So I think I've managed to master the basics of MySQL now. My next task is to make that football site run off of MySQL so that matches can be searched etc etc.
Lots to do but it shouldn't be too bad, it's just basically a lot of entering, viewing and editing of data...
I've managed to do the edit script now!
So I think I've managed to master the basics of MySQL now. My next task is to make that football site run off of MySQL so that matches can be searched etc etc.
Lots to do but it shouldn't be too bad, it's just basically a lot of entering, viewing and editing of data...
Page: