MySQL Fetch Array & Object

[thekidscareya]

My Page

<?php
# Get Database Details
include 'conf_global.php';

# Connect to MySQL Server
$connect = mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']) or die("Cannot connect to MySQL server.");

# Select Database
mysql_select_db($INFO['sql_database'],$connect) or die("Cannot connect to database.");

# Set regular query
$regularsql = "SELECT * FROM ibf_clips";

# Set object query
$objectsql = "SELECT `Preview` FROM `ibf_clips` WHERE `ClipID` = '".$id."'";

# Regular Query
$regularresult = mysql_query($regularsql,$connect) or die("Cannot perform regular query.");

# Object Query
$objectresult = mysql_query($objectsql,$connect) or die("Cannot perform object query.");

# Set object in array
while ($regularrow = mysql_fetch_array($regularresult))
	{
	# Rename Primary Key
	$id = $regularrow[ClipID];
	?>
	<table width="75%" border="0" align="center">
  	<tr>
    <td><?php echo "<a href='{$regularrow[Filename]}'>{$regularrow[Name]}</a>"; ?></td>
    <td><?php echo "$regularrow[Size] KB"; ?></td>
    <td>
    <?php 
	while ($objectrow = mysql_fetch_object($objectresult)) 
		{
		# Display Object
		echo $objectrow->Preview;
 		} 
	# Free Result for Object Query
	mysql_free_result($objectresult);
	?>
	</td>
  	</tr>
	</table>
	<?php
	}
?>

I get these 2 error multiple times

Warning: mysql_fetch_object(): 5 is not a valid MySQL result resource in /home/joel/public_html/home/clips.php on line 35

Warning: mysql_free_result(): 5 is not a valid MySQL result resource in /home/joel/public_html/home/clips.php on line 41

[zhabala]

I have got them because it the order of commands was wrong for things you are doing, I have enclosed right order for them. Try it and try to find the difference.

Now I found that you are doing both SELECT statements from the same table, why it is so ?

Zdenek ?

<?php 
# Get Database Details 
include 'conf_global.php'; 

# Connect to MySQL Server 
$connect =  mysql_connect($INFO['sql_host'],$INFO['sql_user'],
$INFO['sql_pass']) or die("Cannot connect to MySQL server."); 

# Select Database 
mysql_select_db($INFO['sql_database'],$connect) or die("Cannot connect to database."); 

# Set regular query 
$regularsql = "SELECT * FROM ibf_clips"; 

# Regular Query 
$regularresult = mysql_query($regularsql,$connect) or die("Cannot perform regular query."); 

# Set object in array 
while ($regularrow = mysql_fetch_array($regularresult)) 
    { 
    # Rename Primary Key 
    $id = $regularrow[ClipID]; 
    ?> 
    <table width="75%" border="0" align="center"> 
      <tr> 
    <td><?php echo "<a href='{$regularrow[Filename]}'>{$regularrow[Name]}</a>"; ?></td> 
    <td><?php echo "$regularrow[Size] KB"; ?></td> 
    <td> 
    <?php  
    # Set object query 
    $objectsql = "SELECT `Preview` FROM `ibf_clips` WHERE `ClipID` = '".$id."'"; 

# Object Query 
$objectresult = mysql_query($objectsql,$connect) or die("Cannot perform object query."); 

while ($objectrow = mysql_fetch_object($objectresult))  
    { 
    # Display Object 
    echo $objectrow->Preview; 
    }  
# Free Result for Object Query 
mysql_free_result($objectresult); 
?> 
</td> 
  </tr> 
</table> 
<?php 
} 
?>

[thekidscareya]

Now, I just get some binary code were Preview is supposed to be 🙁

[zhabala]

Yes, because you are just retrieving it from a database. Then if it is a movie clip or I don't know what it actualy is, you have to deal with that somehow not only echo it.

Z.

[thekidscareya]

all it is is a LONG BLOB (Binary)

why isn't it working?

[zhabala]

Because echoing a LONG BLOB means display the binary content of it.

You have to convert it somehow depeding on what is the content of it. You can store it to the file and make a link from the page to that file or whatever you want and need, you didn't write it so I don't know exactly.

[thekidscareya]

i want Preview as the image in the db...i want to save some space...and make it a bit more dynamic and easier to hanlde

[zhabala]

But as you probably know, when you want to show an image on some web page, it must be displayed using HTML TAG named IMG, then the parameter SRC which is normally pointing to the file with the image. In your case the SRC parameter should point to your PHP script with an identifiaction of the Image which should be displayed and then .... but it is too complicated to be explained here. I think, that storing images into the DB is not good idea, usually only some information about the image is stored in DB and the image itself is stored into a filesystem.

Z.

[thekidscareya]

how exactly would i do that?