473,322 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Showing image stored on server...

Hello again all,

I am trying to show team images instead of team names in a standings page that i have created. Images are stored on the server but i am unable to come up with the code that prints the image of the team. Here is my code.


Expand|Select|Wrap|Line Numbers
  1.  <?php
  2.  
  3.  
  4. function ConferenceStandings ($conference)
  5. {
  6.  
  7.   include 'connect.php';
  8.  
  9.   $teamid = $_REQUEST["id"];
  10.  
  11.   // Connects to your Database
  12.  
  13.   $sql = "select *from season12 join teams WHERE season12 . team =teams . teamnameseason AND teams . conference ='$conference' ORDER BY `season12` . `P` DESC";
  14.   $data = mysql_query($sql) or die(mysql_error());
  15.   Print "<table width = 300>";
  16.   Print "<th bgcolor=#C10000>&nbsp;&nbsp;&nbsp;#&nbsp;&nbsp;&nbsp;</th>";
  17.   Print "<th bgcolor=#C10000>&nbsp;&nbsp;&nbsp;&nbsp;Team&nbsp;&nbsp;&nbsp;&nbsp;</th>";
  18.   Print "<th bgcolor=#C10000>&nbsp;&nbsp;&nbsp;&nbsp;GP&nbsp;&nbsp;&nbsp;&nbsp;</th>";
  19.   Print "<th bgcolor=#C10000>&nbsp;&nbsp;&nbsp;&nbsp;Pts&nbsp;&nbsp;&nbsp;&nbsp;</th>";
  20.  
  21.   $count++;
  22.   while($info = mysql_fetch_array( $data ))
  23.   {
  24.     $wcount=$wcount+1;
  25.     $teamnameseason = $info['teamnameseason'];
  26.     Print "<tr>";
  27.     if ($wcount == 9)
  28.     {
  29.       Print "<td>"?>
  30. <hr align="center" width="100%" size="1" color="#C10000" />
  31. <?php "</td> ";
  32.       Print "<td>"?>
  33. <hr align="center" width="100%" size="1" color="#C10000" />
  34. <?php "</td> ";
  35.       Print "<td>"?>
  36. <hr align="center" width="100%" size="1" color="#C10000" />
  37. <?php "</td> ";
  38.       Print "<td>"?>
  39. <hr align="center" width="100%" size="1" color="#C10000" />
  40. <?php "</td> ";
  41.       Print "<tr>";
  42.     }
  43.  
  44.     Print "<td align = center>".$wcount. "</td> ";
  45.     Print "<td align = center>".$info['teamnameseason'] . "</td> ";
  46.     Print "<td align = center>".$info['GP'] . "</td> ";
  47.     Print "<td align = center>".$info['P'] . "</td> ";
  48.   }
  49.  
  50.   Print "</table>";
  51.   include 'closedb.php';
  52. }
  53.  
  54. print "<img src='images/logoest.gif' />";
  55. print "<br />";
  56. ConferenceStandings ("East");
  57.  
  58. print "<br><br><br><br />";
  59.  
  60. print "<img src='images/logowest.gif' />";
  61. ConferenceStandings ("West");
  62. ?> 

As you can see teamnameseason is what is printing but i am looking for the image of the team that i have stored the link in a BLOB on the db...

Anyone able to give some advice?

Thanks in advance...
Oct 27 '11 #1
1 1479
Anyone able to help here?
Oct 29 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: ATK | last post by:
Hi, I have a image stored in a blob column in my db... i know how to retrieve it correctly and yes, i need to save it in a blob in the db. How can i get the width & height from that image? I...
6
by: bissatch | last post by:
Hi, I have a collection of images stored in a DB. They are there for the purpose of a news system. When the user views the homepage it will diplay cropped versions of the news where the user...
0
by: Bevo | last post by:
I have a table column in my db of type Image to store some pictures. Now I'd like to bind that column to an Image web server control on my page, preferrably in the declaration in the .aspx, like: ...
7
by: needin4mation | last post by:
Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. ...
17
sumittyagi
by: sumittyagi | last post by:
Hi! everybody! I am facing one problem. How to get data from response, where content type is image/jpg ore image/gif. normally browser do it for us, when it encounters an image tag, it sends an...
0
sashi
by: sashi | last post by:
BLOB - Retieve image stored in database Dim CN As New ADODB.Connection Dim RS As ADODB.Recordset Dim DataFile As Integer, Fl As Long, Chunks As Integer Dim Fragment As Integer, Chunk() As...
7
by: hsegoy1979 | last post by:
Dear All Iam using file upload control and i want to display image in another pop up page .But image is not displaying in image control iam sending image path thru querystring . here is my code ...
6
by: hsegoy1979 | last post by:
Dear All Iam new to asp.net. I want to display image on server machine uploaded from client machine using javascript. Any Help Thankx in Advance Yogesh
0
by: =?Utf-8?B?SmVmZlAtPg==?= | last post by:
We moved our main Application but not our web apps and now we're not able to view our TIF / Bitmap images on the web data entry page. We had.... Our scanner deposited TIF files for web based data...
2
by: Gunasegar | last post by:
Greeting to all am trying to create thumbnail from image stored in mysql database.. this is the coding am using to create the thumbnail... this works like charm.. but the problem is that the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.