help. how do i solve this?

volc82

hi. im making an advertising site. and want images to my posts. i have gotten the image uploading and the posting to work. but im not sure how to solve it when im going to get my pictures out so it shows with the posts.

<?
$query = mysql_query("SELECT objects.objid, objects.headline, objects.text, objects.date, objects.price, users.name, users.email FROM objects, users WHERE users.userid = objects.userid ORDER BY objid DESC")or die(mysql_error());
while( $result = mysql_fetch_array($query) )

{
print '<tr><td><div id="box1"><strong>';
print $result['headline'];
if ( session_is_registered('UserLogin') )
{
print ' <a href="edit.php?newsid=' . $result['objid'] . '&action=editnews"><img src="bilder/button_edit.png" border=0 alt="ändra" title="ändra"></a> ';
print '<a href="delete.php?newsid=' . $result['objid'] . '&action=deletenews"><img src="bilder/button_drop.png" border=0 alt="ta bort" title="ta bort"></a> ';
print '<a href="picstore.php?newsid=' . $result['objid'] . '"><img src="bilder/pic.gif" border=0 alt="lägg till foto" title="lägg till foto"></a> ';
}
print '</strong>';
print '<p>';
print nl2br($result['text']);
print '<strong><br>Pris: ';
print $result['price'];
print ',-</strong></p></div><div id="spacer"> </div><div id="box2">';

! Here is where i want the pictures from my binary_data database !

print '</div></p></td></tr>';
}
?>

Here is the code im using to write out the posts.

i added so i get the objects.id from posts added to the pictures database binary_data.objectid so i want to bind them together through that. i have tryed to figure this out myself but however i do i get 2 diff result. either only the posts with pictures shows or post with several pictures shows as many times theres is picture added to it.

please help me solve this. ive tryed but im not skilled enough 🙂

TobyRT

Always try and post code in

tags like this - it makes it easier to read and for us to examine 🙂

<?
$query = mysql_query("SELECT objects.objid, objects.headline, objects.text, objects.date, objects.price, users.name, users.email FROM objects, users WHERE users.userid = objects.userid ORDER BY objid DESC")or die(mysql_error());
while( $result = mysql_fetch_array($query) )

{
print '<tr><td><div id="box1"><strong>';
print $result['headline'];
if ( session_is_registered('UserLogin') )
{
print '&nbsp;<a href="edit.php?newsid=' . $result['objid'] . '&action=editnews"><img src="bilder/button_edit.png" border=0 alt="ändra" title="ändra"></a>&nbsp;';
print '<a href="delete.php?newsid=' . $result['objid'] . '&action=deletenews"><img src="bilder/button_drop.png" border=0 alt="ta bort" title="ta bort"></a>&nbsp;';
print '<a href="picstore.php?newsid=' . $result['objid'] . '"><img src="bilder/pic.gif" border=0 alt="lägg till foto" title="lägg till foto"></a>&nbsp;';
}
print '</strong>';
print '<p>';
print nl2br($result['text']);
print '<strong><br>Pris: ';
print $result['price'];
print ',-</strong></p></div><div id="spacer">&nbsp;</div><div id="box2">';

! Here is where i want the pictures from my binary_data database !

print '</div></p></td></tr>';
}
?>

TobyRT

If you're uplaoding a file, you're obviously going to have some kind of validation attached such as filename and directory structure. You should be able to echo that structure into a variable which basically gives you something along the lines of

$uploaded="http://mysite.com/images/me.jpg"

Then when you add the entry you use a varchar field to hold the image address and simply echo that in the normal way:

echo '<img src="'.$uploaded.'" align="center">';

or whatever code you need

volc82

im using longblob and store the pictures into the database. and if i select both the information from news table and binary_data table it only shows the posts with pictures added to same newsid. is there anyone who know how to print out all the news even if there isnt pictures uploaded with same id... i´ve heared i should use the "while" and check if there is any picture uploaded from there. but im not sure how to do it.