reportingsjr Posted April 4, 2006 Share Posted April 4, 2006 Im like brand new to SQL (have a bit of understanding) and I have some problems and questions:im trying to use mySQL, it wont work. What file do I run?thats all for problems.Questions:Can you put images into tables? So you could like host an image through a table? Im trying to make it so when someone in a group im in can go through fill out a form and the image the selected in that form plus al the other stuff will go into a table. The table will then get echoed through PHP into an HTML table.How do I do this? Or will we just have to upload images from like imageshack? Link to comment Share on other sites More sharing options...
reportingsjr Posted April 5, 2006 Author Share Posted April 5, 2006 Can you put an image into a mySQL table I have code so that the table prints out so this would be the table:+--------+-------------+------------------------------------------+ |pic_id..|Description..| file_location.................................|+--------+-------------+------------------------------------------+|1..........|Sweet!....|C:desktop/my_documents/pics/pk1.|+--------+-------------+------------------------------------------+Could I make it so when file_location for pic_id 1 was posted in an HTML table it would be a picture? I dont want to have to upload a picture to imageshack everytime and have to put the link in there. Help on how I could do this?? Link to comment Share on other sites More sharing options...
aspnetguy Posted April 5, 2006 Share Posted April 5, 2006 You can store images directly in the database (takes a lot of database space) or you can stored the path (a string) to the image in the database and have the images in a folder on the server.MySql is a databae server software. You will have to download it from mysql.com and install it. You then can staqrt running queries on it after you have turned it on.I would recommend getting phpMyDamin for MySql administration or else you will have to use mysql from the command line. Link to comment Share on other sites More sharing options...
aspnetguy Posted April 5, 2006 Share Posted April 5, 2006 merged topics, please avoid posting the same questions more than once Link to comment Share on other sites More sharing options...
reportingsjr Posted April 11, 2006 Author Share Posted April 11, 2006 Ok, im just going to post for help on PHP. How do you put a file into a folder on your server.. Link to comment Share on other sites More sharing options...
aspnetguy Posted April 12, 2006 Share Posted April 12, 2006 Are you running your program on your home pc (localhost) or do you have a hosting account???? Link to comment Share on other sites More sharing options...
reportingsjr Posted April 15, 2006 Author Share Posted April 15, 2006 Im getting a hosting account soon. I already have the scripting though. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now