More PHP problems...

  RicScott 16:04 20 May 2006
Locked

I'm trying to display images from a mysql database using LONGBLOB. I can view the image from phpmyadmin, but when I try to create a recordset (from with Dreamweaver) that includes the IMG row, I get 'an unidentified error has occured'.
I've tried to manually program it but just get an empty space..

Number 2 is.. I'm trying to display the contents of the DB in tables..if I insert the query into the tables, all I get is the first entry from the DB going down the screen in every table..??
Failing that I just get a blank space where the data should be with no connection errors...
Where am I going wrong?

  beynac 16:57 20 May 2006

Sorry, I can't help with your first question.

Number 2: What code are you using? I set up the table, including headings, in html and then insert the following php code as the body ($Query is the SQL query):

<?php
$Result = mysql_query($Query);
while ($Row = mysql_fetch_array ($Result)) {
print (" <tr>\n");
print (" <td>$Row[Field1]</td>\n");
print (" <td>$Row[Field2]</td>\n");
print (" <td>$Row[Field3]</td>\n");
print (" </tr>\n");
}
?>

There are other ways of doing this, but this one is very straightforward.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?