[tr_ellis1973@msn.com]

I am new to this. all I want to do is insert either an image or the path of the picture and have it be pulled up into the the web page. I have never done this before. I tried to upload the image into the database but that doesn't seem to work so would the path in the just pull up the picture. the database consists of the following rows.
Name
ingredients
instructions
category
Image.

What I want is to just display the image as the page loads so that It won't show the link.

[ShocK]

You mean you just want a page with an image on it? So you go to a page and it's there?

[Mate]

If you want to store your images within a MySQL database/table, use the data type BLOB.

There's a good tutorial here that might point you in the right direction.

[tr_ellis1973@msn.com]

I'm wanting to load everything into a database and pull everything throu sql queries. and bam the picture is showing.

[d3iti]

Hello,

I think it is not very suitable to save images in the database because you can overload the server database and your website may be suspended/canceled.

Is better than in the database you save the link to the image file. Then stored in a server folder the image files.

It's just an opinion.

[tr_ellis1973@msn.com]

then with that then would i save the link in the database or on the web page itself? cause what i'm doing is a drink recipe website.

[grace1004]

You can save the path for images. For example, in case photo_l.jpg is in images folder in public_html
directory, the path saved in DB table would be--images/photo_l.jpg.
To call the image path, you need to make a query similar to below:

$query = "select * from table_name where Name='$name'";
$result= mysql_query($query);
$row = mysql_fetch)_array($result);

For displaying images, you can use <img> tag as shown below:

<img src="<?=$row['image']?>" width="100" height="120" border="0">

[tr_ellis1973@msn.com]

can I put a path in the database then pull it up that way like say a row called pic with images/maritinglass.jpg?

[grace1004]

The following example shows a table structure in my database:



At the top, the table name is displayed as--Table: guestbook. If you click 'Structure' tab,
you can see the table structure. My 'guestbook' table consists of 4 fields or columns--comm_id,
name, comment and datetime. So, what you are saying 'a row called pic', means actually a field
or column called pic.

In my case, $row = mysql_fetch_array($result)--means one line of data expressed in an array having
4 elements (fields).

the database consists of the following rows.
Name
ingredients
instructions
category
Image.

The above shows your table schema. Here, $row['Image'] is the field (an element of the array), where
the image path to be saved. So, you can save the path in 'Image' field as images/maritinglass.jpg.

Added later:

You can save the image path by making an update query similar to below:

$query = "update table_name set Image = 'images/maritinglass.jpg' where Name='$name'";
mysql_query($query);

[tr_ellis1973@msn.com]

then my next question. then my image or pic row still should be blob or should I change it to text. char, varchar or etc. or just keep it the same as blob?

cause what I have now is just one page where it pulls up all the data in the table on one single page and I just wanna make one single page.