PHP - Pull Only One Image From Database

Good afternoon:

I have added a database field to a table that has quiz questions in it.
the field I have added is for images and I have entered the image url that is stored on the server in an image folder.

Please could you tell me how I can include the image in the request by adding to the code below:

$Questions = $DB->query("select * from ".TABLE_PREFIX."quiz_questions where q_forquiz='{$Quiz['qid']}' order by qqid");

while($Question = $DB->fetch_array($Questions)){
$Q[$Question['qqid']] = $Question;
}

Fields in table quiz_questions:
qqid
q_question
q_type
q_params
q_forquiz
q_questionimages - This is the field I added.

Thank you for helping.
Amilo

Hi, I've read a lot of places that it's not recommended to store binary files in my db.
So instead I'm supposed to upload the image to a directory, and store the link to that directory in database.

First, how would I make a form that uploads the picture to the directory (And what kinda directories are we talking?).

Secondly, how would I retrieve that link? And I guess I should rename the picture..

I'd appreciate any help, or a good tutorial (Haven't found any myself).

Hello,
Five images will be displayed inside a division.
There will be a previous and next button/link.
If someone click the next button the next image will be added in that div and the first image will be gone from that div.
The previous button/link will do the same thing.

Is it possible with php?
I am confused if it's a javascript or ajax question.

Thanks.

hello friends,

while clicking the form all the information goes to database, I have one image upload field,
when cliking the submit button, i would like 'image name' to go in database and file to go in
/upload folder, i have tried this for hours and gave up,

if anyone help me in this, i would be very greatful

Ok i have been trying for a few days now with no success to show a image from my database but as this is the first time i have tried to use databases im having no luck, my problem is this...

I have an image gallery that shows a list of differnt galleries with the number of images inside it, like this....  General (10)

I have a form that allows me to add new galleries to the list and upload an image to be shown in the gallery list, i simply added a field in the categories table and called it category_img. I would like to make the list of galleries look better by having an image for each one like this....



This is the code that generates and displays the list of galleries/categories but it is WAY to advanced and confusing for me to work out what to do, i have tried all sorts but only ever destroys what i already have or just does nothing at all, the closest i have got was displaying the name of the image, but no actual image.

Code: [Select]
<?php
                // initialization
$result_array = array();
$counter = 0;

$cid = (int)($_GET['cid']);
$pid = (int)($_GET['pid']);

// Category Listing

if( empty($cid) && empty($pid) )
{
$number_of_categories_in_row = 1;

$result = mysql_query( "SELECT c.category_id,c.category_name,COUNT(photo_id)
FROM gallery_category as c
LEFT JOIN gallery_photos as p ON p.photo_category = c.category_id
GROUP BY c.category_id" );
while( $row = mysql_fetch_array( $result ) )
{
$result_array[] =      
     '<p><a href="gallery.php?cid=' . $row[0] . '">' .      
     $row[1] . '</a> (' . $row[2] . ')</p>';                  
 }      
mysql_free_result( $result );

$result_final = "<tr>\n";

foreach($result_array as $category_link)
{
if($counter == $number_of_categories_in_row)
{
$counter = 1;
$result_final .= "\n</tr>\n<tr>\n";
}
else
$counter++;

$result_final .= "\t<td>".$category_link."</td>\n";
}

if($counter)
{
if($number_of_categories_in_row-$counter)
$result_final .= "\t<td colspan='".($number_of_categories_in_row-$counter)."'>&nbsp;</td>\n";

$result_final .= "</tr>";
}
}


i could really do with some help as trying to learn this stuff is really hard when i have to work in my living room with children running around, my head has not stopped hurting in days.

I need to pull all the mysql data by the order of it's date/time . How can I write the code?

I'm using this as a serverside script and I'm not a php person. But i believe the below code will not pull the data. Will it work if I remove the text marked in red?

$query = "SELECT * FROM  sub_db WHERE the_code = '".$abc."'" ORDER BY timestampz ASC";

Hi all-
I need some help figuring out a select query... I have a view made from two tables with a user ID as the common key. I need to retrieve all rows from the view where the email address is NOT equal to the session variable stated [EMAIL].

I built it using what I thought was a fairly simple query, and what it gives me back are any rows where the EMAIL field has a value (not equal to the session variable) which is fine.. but I ALSO need to get the other rows where the email field has NO value assigned to it currently.

How can I write this?

Hi,
I have a search results page that return the results based on "Make" & "Model" of vehicle.

The question is, can an image be echoed onto that results page based on which make and model has been searched for?

The image is stored in a field called "Image_Van"  so would need to display that depending on the row in that database that has been selected from Make & Model...

Hope this makes sense!


<?php

//info bars colour
$color_info="#D6D685"; // Almost Silver //FFFFCC
$color1="#E9E9E9";// Light Blue
$color2="#EAD5FF";// Light Blue


//include function library code

include_once("func_lib.php");

// use the user_connection include file's connectDB function

include_once("usr_conn.php");

if (!connectDB())

{


echo "<p>Unable To Connect To Database</p>";

return;
}

//test that make and model are passed in, if they are assign them
if (($_GET ['make'] == "MAKE") or ($_GET ['model'] == "MODEL"))

{
$errMessage =  "<br><br><b><font class=small>Your search hasn't returned any results, please re-enter your search again.</font></b><br><br><a href=van_accessories.php>Search again</a><br><br>";


}


else


{
// get search values for make and model, removing " and ' chars
$strMake = mysql_escape_string($_GET ['make']);















$strModel = mysql_escape_string($_GET ['model']);















}















// set the Prod_Type that is to be shown regardless of car make and model















$strDefaultProd = "XD";































//write query string that will pased in paging links















$strQuery = "make=".$strMake."&model=".$strModel."&";















//echo $strQuery;















//grab the page number that we're on















$page = mysql_escape_string($_GET ['page']);































//$strMake = "FIAT";















//$strModel = "Uno";































//create sql query















$sqlSelect = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Prod_REF, Product_Desc, Price_ExVat, image_name, Image_Van FROM products";

                                                                                        //change this back to 'FILL THIS IS IN' to switch accessories off!

$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Default_Code = 'SA')";


//$criteria = " WHERE Car_Make = '".$strMake."' AND Car_Model = '".$strModel."'";







// assign the basic sqlquery



$sqlquery = $sqlSelect . $criteria;



//echo $sqlquery; #debug











//get the result set



$result = mysql_query($sqlquery);



$count = mysql_num_rows($result);



$full_count = $count;















//set max number of records per page



$records_per_page = 999;







//Next figure out how many pages you'll have.



$total_pages = ceil( $count / $records_per_page );







/*















This just sets up a page variable which will be past in a "next" and "prev"















link.  The first link to this page may not actually have $page so this just















sets it up.















*/































if ( $page == "" ) { $page = 1; }































//echo "<br>page number".$page; #debug















































# this will set up the "First | Prev | " part of our navigation.















if ( $page == 1 ) {















    # if we are on the first page then "First" and "Prev"















    # should not be links.















    $naviagation = "<font color=\"#666666\">First</font> | <font color=\"#666666\">Prev</font> | ";















} else {















    # we are not on page one so "First" and "Prev" can















    # be links















    $prev_page = $page - 1;















    $navigation = "<a href=\"van_steps_results.php?".$strQuery."page=1\">First</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$prev_page."\">Prev</a> | ";















}































# this part will set up the rest of our navigation "Next | Last"















if ( $page == $total_pages ) {















    # we are on the last page so "Next" and "Last"















    # should not be links















   // $navigation .= "<font color=\"#666666\">Next</font> | <font color=\"#666666\">Last</font>";















} else {















    # we are not on the last page so "Next" and "Last"















    # can be links















    $next_page = $page + 1;















    $navigation .= "<a href=\"van_steps_results.php?".$strQuery."page=".$next_page."\">Next</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$total_pages."\">Last</a>";















}































/*















The final thing to do is your actual query, but first we have to figure out















what the offset will be.















*/















$offset = ( $page - 1 ) * $records_per_page;















//echo "<br>offset".$offset; #debug


//create sql query


$sqlSelect = "SELECT Car_Make, Car_Model, Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat, Link, image_name, Image_Van FROM products";


$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Car_Model = 'all' AND Default_Code = 'SA')";


$limit = " ORDER BY Priority ASC, Prod_Code ASC, Prod_ID ASC LIMIT $offset, $records_per_page";

// assign the basic sqlquery
$sqlquery = $sqlSelect . $criteria . $limit ;

//echo $sqlquery;

//get the result set

$result = mysql_query($sqlquery);
// if no matches found from query
if (!$result || (mysql_num_rows($result) == 0)){
//echo ("<b><font class=small>No matches were found.</font></b>");
}
// display the results
else{
// use rowcount to display total results found

$count = mysql_num_rows($result);

//echo $count;

//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Results Page:</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
<!--script src="js/jquery.lint.js" type="text/javascript" charset="utf-8"></script-->
<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" title="prettyPhoto main stylesheet" charset="utf-8" />
<script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>


<!--  start header graphic html -->

<style type="text/css">
<!--
.table {
border: 0px none;
border-collapse: separate;
}

BODY
{
}
A
{
    COLOR: #003366;
    TEXT-DECORATION: none;
}
A:hover
{
TEXT-DECORATION: underline;
color: #900;
}
.small
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.std
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR: #000000;
}
.header
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
.bigheader
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: BOLD;
    COLOR:#FFFFFF;
}
.error
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR:#FF0000
}
.headertable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#FFFFFF;
    BACKGROUND-COLOR:#000066;
}
.stdtable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#000066;
}
.style16 {font-size: 11px}
.style7 { color: #CC0000;
font-style: italic;
}
.small1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.header1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
a:link {
color: #900;
}
-->
</style>




<div align="center">
  <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td background=""><table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
        <tr>
          <td bgcolor="#003366">&nbsp;</td>
        </tr>
      </table>

        <!--END header-->
        
        <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
              <tr>
                <td><div align="center">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td class="arial11"><table width="100%" border="0" cellpadding="10" cellspacing="0">
                        <tr>
                          <td width="33%"><p><img src="2003/results.gif" alt="" width="238" height="43" /></p>
                            <p>&nbsp;</p>
                            <p>&nbsp;</p></td>
                          </tr>
                        </table></td>
                    </tr>
                  </table>
                </div></td>
              </tr>
            </table>
              <table width="950" border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#FFFFFF">
                <tr align="center" valign="top" class="std">
                  <td colspan="7"><hr width="500" size="1" />
                    <?php















if (isset($errMessage)){















echo $errMessage;















}















// if no matches found from query















if (!$result || (mysql_num_rows($result) == 0))















echo ("<b><font class=small>No matches were found.</font></b><br><br>");































// display the results















else{















// use rowcount to display total results found















echo("<br><p><em><font class=vehicle>Search Results for " . $strMake . "&nbsp;" . $strModel .".</em> Total Matches Found = " . $full_count . "</p>"); //*debug















echo $navigation;



}




/*



With your navigation built you can just echo that out any where you want it



to appear.



*/



//echo $navigation;



?></td>
                </tr>
                <?php



$title =  "<tr align=\"center\" class=\"headertable\" height=\"32\">";


$title .= "<td width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"1\" /></td>";

    $title .= "<td width=\"60\">Make</td>";



    $title .= "<td width=\"60\">Ref No.</td>";



    $title .= "<td width=\"550\">Title/Description</td>";



    $title .= "<td width=\"73\">Price Ex VAT</td>";



    $title .= "<td width=\"73\">Price Inc VAT</td>";



    $title .= "<td width=\"60\"><img src=\"2003/basket.gif\" width=\"21\" height=\"14\"></td>";



    $title .= "</tr>";































//set the counters for the records results display screen















$cnt = 0;















$headercount1 = 0;















$headercount2 = 0;















$headercount3 = 0;















$headercount4 = 0;















$headercount5 = 0;















$headercount6 = 0;















$headercount7 = 0;



























while ($row = mysql_fetch_assoc($result))















{































//cut the prod_type variable















//get the length of the variable















$strLength = strlen ($row["Prod_Type"]);















//assign first 2 characters of variable















$strPrefix = substr($row["Prod_Type"], 0, 2);















//debug















//echo "\n prefix :" . $strPrefix;















//assign remaining characters of variable















$strSuffix = substr($row["Prod_Type"], 2, $strLength);















//debug















//echo "\n suffix :" . $strSuffix;































































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=center><td colspan=7 class=small>";










//set bg cell color diff for BH make
switch ($strPrefix)
{
case "BH":
$color=$color2;
break;

default:
$color=$color1;
break;
}//end switch


switch ($strPrefix)
{

   case "BH":

        if ($headercount1 == 0)

{

echo "<img border=0 src=2003/searchheaders/step.jpg></td></tr>";
echo $title;
}
$headercount1 ++;

//$headercount1


       break;

  // REMOVE ALL THIS COMMENTING IF NEEDED TO SHOW THE ROOF BARS!  case "RB":

     //  if ($headercount2 == 0)
// {
// echo "<img border=0 src=2003/searchheaders/NOTUSED.jpg alt=Roof-Bars></td></tr>";
// echo $title;
// }

// $headercount2 ++;

//$headercount1

       break;

case "BX":
        if ($headercount3 == 0)
{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Roof-Boxes></td></tr>";
echo $title;
}
$headercount3 ++;

//$headercount1

       break;
case "BR":


        if ($headercount4 == 0)

{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Bike-Racks></td></tr>";

echo $title;

}


$headercount4 ++;

//$headercount1

       break;
case "SR":
        if ($headercount5 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Ski-Rack></td></tr>";
echo $title;
}

$headercount5 ++;


//$headercount1


       break;
case "CR":

        if ($headercount6 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Canoe-Rack></td></tr>";



echo $title;
}


$headercount6 ++;

//$headercount1

       break;

case "XD":

 if ($headercount7 == 0)

{


echo "<img border=0 src=2003/searchheaders/towbar.jpg alt=General-Accessories></td></tr>";
echo $title;

}



$headercount7 ++;


}















//end header image selection and close the table row.















//echo "</td></tr>";































// if (($cnt++)%2)
// {
// $color="#E9E9E9"; // Almost Silver
// }
//     else
// {
// $color="#E9E9E9";// Light Blue
// }































//print a product row if the prodtype isn't set to INFO



$pop_link = "";







if ($strSuffix != "INFO"){







//test to see if an image exists for the product



if ($row["Link"] <> NULL){



$pop_link = "&nbsp;&nbsp;&nbsp;<a href=\"products/".$row["Link"]."?iframe=true&width=650&height=500\" rel=\"prettyPhoto\" >More information >>>></a>";



}







echo "<tr class=stdtable align=center height=25>";


//DISPLAY THUMB IMAGE IF ONE WAS LISTED IN THE image_name FIELD
$p_Image_Van = htmlspecialchars($row["Image_Van"]);
//echo "p_Image_Van:$p_image_name";
if ($p_Image_Van != "")
echo "<td bgcolor=$color width=\"95\"><img src=\"images/product_images/$p_Image_Van\" border=\"0\" /></td>";
else
echo "<td bgcolor=$color width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"50\" border=\"0\" /></td>";


echo "<td bgcolor=$color width=\"60\">". htmlspecialchars($row["Prod_Make"]) .




"</td><td bgcolor=$color width=\"60\">" . htmlspecialchars($row["Prod_REF"]) .















"</td><td bgcolor=$color align=left class=\"infolink\" width=\"550\">" . htmlspecialchars($row["Product_Desc"]) .







$pop_link .







"</td><td bgcolor=$color width=\"73\">&pound;" . number_format(htmlspecialchars($row['Price_ExVat']), 2) .















"</td><td bgcolor=$color width=\"73\">&pound;" . number_format((calcVAT (htmlspecialchars($row['Price_ExVat']))), 2) .















"</td><td bgcolor=$color width=\"60\"><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=7 bgcolor=$color_info><em><strong>" . htmlspecialchars($row["Product_Desc"]) . "</strong></em></td></tr>";















}















}















































//******************************************************************************************************







/*







//get all porducts from the database that are marked with prod_type XD regardless of car make and model















$sqlSelectDefault = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat FROM products";















$criteriaDefault = " WHERE Prod_Type LIKE '".$strDefaultProd."%'";















$limitDefault = "ORDER BY Priority ASC, Prod_Code ASC";































// assign the basic sqlquery















$sqlqueryDefault = $sqlSelectDefault . $criteriaDefault . $limitDefault ;















//echo $sqlquery;































//get the result set















$resultDefault = mysql_query($sqlqueryDefault);















































// if no matches found from query















if (!$resultDefault || (mysql_num_rows($resultDefault) == 0)){















//echo ("<b><font class=small>No matches were found.</font></b>");















}















// display the results















else{















// use rowcount to display total results found















$countDefault = mysql_num_rows($resultDefault);















//echo $count;















//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug















}































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=left><td colspan=6 class=small>";































echo "<img border=0 src=2003/searchheaders/general.jpg alt=General-Accessories>";































echo "</td></tr>";































while ($rowDefault = mysql_fetch_assoc($resultDefault))















{































//cut the prod_type variable















//get the length of the variable















$strLengthDefault = strlen ($rowDefault["Prod_Type"]);















//assign first 2 characters of variable















$strPrefixDefault = substr($rowDefault["Prod_Type"], 0, 2);















//debug















//echo htmlspecialchars($rowDefault["Prod_ID"]);















//echo "\n prefix :" . $strPrefixDefault;















//assign remaining characters of variable















$strSuffixDefault = substr($rowDefault["Prod_Type"], 2, $strLengthDefault);















//debug















//echo "\n suffix :" . $strSuffixDefault;















































if ($strSuffixDefault != "INFO"){















$color="#E9E9E9"; // Almost Silver















//print a product row if the prodtype isn't set to INFO















echo "<tr class=stdtable align=center height=25 ><td bgcolor=$color>". htmlspecialchars($rowDefault["Prod_Make"]) .















"</td><td bgcolor=$color>" . htmlspecialchars($rowDefault["Prod_REF"]) .















"</td><td bgcolor=$color align=left>" . htmlspecialchars($rowDefault["Product_Desc"]) .















"</td><td bgcolor=$color>?" . number_format(htmlspecialchars($rowDefault['Price_ExVat']), 2) .















"</td><td bgcolor=$color>?" . number_format((calcVAT (htmlspecialchars($rowDefault['Price_ExVat']))), 2) .















"</td><td bgcolor=$color><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $rowDefault["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=6 bgcolor=$color><em>" . htmlspecialchars($rowDefault["Product_Desc"]) . "</em></td></tr>";















}















}











*/



?>
                <tr align="center">
                  <td colspan="7" class="small1"></td>
                </tr>
                <tr>
                  <!-- <tr align="center" class="headertable" height="32">















          <td width="145">Product Name</td>















          <td width="178">Ref No.</td>















          <td width="280">Description</td>















          <td width="73">Price Ex VAT</td>















          <td width="73">Price Inc VAT</td>















          <td width="60"><img src="2003/basket.gif" width="21" height="14"> </td>















        </tr>-->
                  <td colspan="7" height="1" bgcolor="#003366"><img src="colour_spacer.gif" width="756" height="1" /></td>
                </tr>
            </table></td>
          </tr>
        </table>
        <p><br />
          </p>
        </p>
        <div align="center"><br />
        </div>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td>&nbsp;</td>
          </tr>
</table>
        <?php































//free up some memory















mysql_free_result($result);



// close the aatabase connection

mysql_close();

//include footer code


?>
        <br />
      </table>


</html>

Ok , so im fairly new to this beeen watching tuts , messing around with coding to see what does what , well i cant seem to get this uploader to send a image to the db it just errors the code is
<html>
<head>
<title>Image Uploader</title>
</head>
<body>
<form method="post" action="index.php" enctype="multipart/form=data">
File:
<input type="file" name="image" />
<input type="submit" value="upload" />

</form>


<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());


//file propities
$file = $_FILES['image']['tmp_name'];

if (!isset($file))  {
echo "Please select an image";
}
else
{
$image = file_get_contents ($_FILES['image']['tmp_name']);
$image_name = $_FILES['image']['name'];
$image_size = getimagesize($_FILES['image']['tmp_name']);

if ($image_size==FALSE) 
echo "This is not an image file";


else
{
 if (!$insert = mysql_query("INSERT INTO imagedb VALUES ('','$image_name','$image')"))
 echo "problem uploading image";


 else
 {
   $lastid = mysql_insert_id();
   echo "image uploaded<p>Your image</p><img scr =get.php?id=$lastid>";
 }
}
}
?>
</body>
</html>


thats my index.php


then my get.php is
<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());  

$id = addslashes($_REQUEST['id']);
$image = mysql_query("SELECT * FROM imagedb WHERE id=$id");
$image = mysql_fetch_assoc($image);
$image = $image['image'];

header("Content-type: img/jpeg");

echo $image;
?>




My database is called 'test'
and my table is called 'imagedb'
and i have 3 fields 'id'name'image.

help would be much appriciated thankyouu

On the home page I am having a problem pulling information from the MySql here is my code...and this is what I am trying to do... i am trying to pull 10 items from the database that have today's date...I am also trying to make the user name a link to a page called backpack.php where that page can use the user name that is clicked to retrieve more information. (the problem I am having is 10 results come up but it is a repeat of the same 10 results and when you click the link it doesn't show the user that is clicked info.) PLEASE someone help I have been trying to figure this out for the longest time.

Code: [Select]
   <form action="backpack.php" method="post">
           
         <?php
         // rows to return
         $limit=10; 
         $idcount=10;
         $date = date('Y-m-d');
         $count = 0;
            
         
while ($limit>=$count)   
{
   //open database
            $connect = mysql_connect("hostname","uname","pass") or die("Not connected");
            mysql_select_db("db_name") or die("could not log in");
   
            $query = "SELECT *,COUNT(name) FROM boox WHERE date='$date' ORDER BY date";
            $idcount = $row['COUNT(name)'];
            $result = mysql_query($query);
            while($row = mysql_fetch_array($result))

         echo "</br><table width='297' height='200' border='1' align='center' style='overflow:scroll'>
  <tr>
    <td width='152'>Book Title:</td>
    <td width='129'>$row[name]</td>
  </tr>
  <tr>
    <td>Author:</td>
    <td>$row[author]</td>
  </tr>
    <tr>
    <td>ISBN#</td>
    <td>$row[isbn]</td>
  </tr>
  <tr>
    <td>Date Posted:</td>
    <td>$row[date]</td>
  </tr>
  <tr>
    <td>Posted By:</td>
    <td><a href='backpack.php' onclick='document['packback'].submit()'>$row[username]</a></td>
  </tr>
  <tr>
    <td>School:</td>
    <td>$row[school]</td>
  </tr>
</table></br>";   

$count = $count + 1;
$idcount = idcount + 1;
         }
         
         ?>
            </form>

MOD EDIT: DB credentials removed, [code] . . . [/code] tags added.

how do I call only a single column in a MySQL?

This is not working.
$SomeVar = $_POST['finco'];
$query = "SELECT * FROM idb WHERE name = '".$SomeVar."'";
$results = mysql_query($query);
$psend = $results["fincos"];
echo($psend);

I'm trying to create a mac widget that will display my college's football schedule. How do i get started pulling the table data of this page? or any webpage for that matter? It doesn't appear to wrapped in any kind of xml

Code: [Select]
http://www.aggieathletics.com/sports/m-footbl/sched/tam-m-footbl-sched.html
The html is about 3/4 of the down in the source code.

This is my code. Data is been pulled from db_faq and Db_2 and then match the records against each other using array_intersect(). And as you see the data from db_faq is been pulled based on the $username.

My question is how can I ignore the $username and match all rows in db_faq against the data in db_2? Basically I need to get the matching records between the 2 databases regardless of the username.

$Array1 = array();
$Array2 = array();
$var1 = '$username';
$query1 =  "SELECT * FROM db_faq WHERE username = '".$var1."'";
$result1 = mysql_query($query1);
$score1 = mysql_fetch_assoc($result1);
foreach (range('25','35') as $ltr) {
$Array1[] = array($score1['roundzA' . $ltr]);
}

$var2 = 'new';
$query =  "SELECT * FROM db_2 WHERE place = schedule";
$result = mysql_query($query);
$score2 = mysql_fetch_assoc($result);
foreach (range('25','35') as $ltr) {
$Array2[] = array($score2['points' . $ltr]);
}
$count = array();
for($i=0;$i<count($Array1);++$i) {
$count[$i] = count(array_intersect($Array1[$i],$Array2[$i]));
}
$countResult = array_sum($count);

the script succesfuly insert image to the database bt, i cant be able to display it on my pages, any help i will appreciate Attached Files  saveimage.php   1.15KB   2 downloads  images_tbl.php   192bytes   3 downloads

Hi there

I've been working with some code to display a single
record on page. This all works fine and I'm able to pull what I
want from the database. My problems is trying to use that
data and turning it into something else like a link.

I have a field in the database called image url which
contains rows of image urls.

So here is the problem area of the code:

Code: [Select]
<?php
//////Displaying Data/////////////
$id=$_GET['id']; // Collecting data from query string
if(!is_numeric($id)){ // Checking data it is a number or not
echo "Data Error";
exit;
}

$fetch=mysql_query("select * from productfeeds where ProductID=$id ");
$row=mysql_fetch_object($fetch);
echo mysql_error();
echo "<table>";
echo "
<tr><td><b>ProductID</b></td><td>$row->ProductID</td></tr>
<tr><td><b>ProductName</b></td><td>$row->ProductName</td></tr>
<tr><td><b>ProductPrice</b></td><td>$row->ProductPrice</td></tr>

//problem area for me
<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>
echo "</table>";
I'm trying to edit this part of the code:

<tr><td><b>Image</b></td><td>$row->ImageURL</td></tr>

I've tried this:

<tr><td><b>Image</b></td><td><a href='{$row['URL']}'> <img src='{$row['ImageURL']}'></a>

and

<tr><td><b>Image</b></td><td><a href='$row['URL']'> <img src='$row['ImageURL']'></a>  //removed brackets

but I'm just getting errors. Can you guys help please?

Thank you very much.