Page 1 of 1

Need help With Database

Posted: Mon Jan 19, 2004 12:04 pm
by cpwalton
Hi there,

I have used PHP & MySQL a lot on my website, however, i have had someone else do the programing for me.

I just recently found a free database protal that works well for what I am trying to do. However, it does not have a file upload feature where I can assign a picture to an item and have it displayed.

I am hoping that someone might be able to help me with this. I am thinking that there has to be a way to add a script or something that would allow me to assign a picture to an item.

The database is located at
http://baseportal.com/cgi-bin/baseporta ... alton/main

If you look, everything else is nice, but I really need pictures so people can see what they are looking at.

If anyone has an idea or wants to help, please let me know. I would be willing to pay someone for their help.

Contact me at cpwalton@yahoo.com with any ideas.

Stephanie
cpwalton@yahoo.com

Posted: Mon Jan 19, 2004 1:03 pm
by nutstretch
are your images in the same place as your database?

What i did to keep the size of my database down was to put the path of the images in the database in the image field and then used

while ($row = mysql_fetch_array($resultID, MYSQL_ASSOC))
{

print "<tr>";
print "<td>".$row['ID']."</td>";
print "<td>".$row['Name']."</td>";
print "<td>".$row['gender']."</td>";
print "<td>".$row['brand']."</td>";
print "<td>".$row['colour']."</td>";
print "<td><img src=\"".$row['image']."\" ></td>";

print "</tr>";

}
(This is in a table) and that shows the image along with the rest of the data in that record.

NOt sure if it will work with what you are doing. I am a newbie too

Posted: Mon Jan 19, 2004 3:09 pm
by cpwalton
I don't think that worked. My database is remotely hosted and the only thing I can do is alter the html file. Any other suggestions would be very much appreciated.

One perfect solution for you

Posted: Mon Feb 02, 2004 8:09 pm
by codetalker
WebDB application builder - http://www.allaboutweb.ca

Build database web site with most features: add, update, delete, browse, sort,search, image upload.