Image + Text output

[Anon]

Hi folks.

the problem is, that i have 2 databases, one with binary data (pics) second with usual data like name, adress....
if i display only the text OR only the binary data everything works fine, but when i try to display both together errors occure.

--------Output Picture (works fine)---------
<?php
MYSQL_CONNECT("ip", "user", "password");
mysql_select_db("database");
$result = MYSQL_QUERY("select bin_data,filetype from binary_data where id=$id");
$data = MYSQL_RESULT($result,0,"bin_data");
$type = MYSQL_RESULT($result,0,"filetype");
echo $data;
};

?>

when i add the query for the 2nd database:

$output = MYSQL_QUERY("Select * from adress where id=$id");
$name = MYSQL_RESULT($output,0,"name");
echo $name;

the problems starts. i need to display both results together at one site. Maybe someone can help.

Thanks

[jariizumi]

If the binary data is a picture, then first of all, make a getpic.php file or whatever that you can use to do something like

getpic.php?id=10

to grab a picture from the database, and also, make sure you send a "Content-Type: image/gif" or whatever to make sure that brings up an image.

Second of all, make a file that grabs the text, which has:

<IMG SRC="getpic.php?id=<?echo $id?>">
<?
// PHP code to grab the text for $id
?>

The <IMG SRC= will grab the image dynamically, and you get both image AND text in the same page 😉 Hope this helps.