Cant grab urls from mysql db to display images

[Prosidius]

My guestbook(http://adamb10.com/book) is going to let people edit those images u see in the menu bar. The problem is it's not quite working. :p

Click the link above and click Login

Username/pw is admin/3218812

Click Home followed by Admin.

Click Layout & Colors, finally click Edit/Change images.

For some reason the images wont display. :(

The code for the file...changeimages.php...:

<?

/*

+-------------------------------------------------------

|	UltraBook 1.1

|	==============================

|	by Adam Bailey

|	(c)Copyright Adam Bailey

|	http://adamb10.com

|	==============================

+-------------------------------------------------------

|

|  > Edit Images Frontend

|  > Written by Adam bailey

|  > Date started: Friday January 20, 2005

|

+-------------------------------------------------------

*/
error_reporting (E_ALL);
//Connect to the databas

database_connect();
//Grab the title of the guestbook

	$sql = "SELECT title FROM settings";

$result = mysql_query ($sql);

$row = mysql_fetch_array ($result);
//Header for the guestbook(real creative name I know =D)

guestbook_header();
//Grab everything from the customize table

$image1 = "SELECT * FROM customize";


$image2 = mysql_query ($image1);


$image = mysql_fetch_array ($image2, MYSQL_ASSOC);


echo '



<br>



<br>



<br>';
//Is the user logged in?

if(session_is_registered('Password')){

	adminpanel_side();

	echo '

<td>



	  <h3 style="text-align: center;"><span style="font-weight: bold;">Change Images</span></h3>



<p align=center>Change the default images to whatever you want.</p><span style="font-weight: bold;"><br>



	  <br>



		   <form method="post" action="?action=saveimages" name="saveimages" >

		   <img src="'.$image['homeimage'].'"><input size="30" name="homeimage" value="'.$image['homeimage'].'"><br><br>
<img src="'.$image['loginimage'].'"><input size="30" name="loginimage" value="'.$image['loginimage'].'"><br><br>
<img src="'.$image['logoutimage'].'"><input size="30" name="logoutimage" value="'.$image['logoutimage'].'"><br><br>
<img src="'.$image['adminimage'].'"><input size="30" name="adminimage" value="'.$image['adminimage'].'"><br><br>
<img src="'.$image['newpostimage'].'"><input size="30" name="newpostimage" value="'.$image['newpostimage'].'"><br><br>


		  <div style="text-align: center;"><input value="Save" type="submit"></div>

		  <br>

		  </form>



 </tr>



	  </tbody>

</table>

';

} else {
//User is NOT logged in?  OK, display this then! 

	echo '<table class="border" style="width: 25%; text-align: left; margin-left: auto; margin-right: auto;" border="0" cellpadding="4" cellspacing="1" class="border">



  <tbody>



	<tr class="titlebg">



	  <td>Error</td>



	</tr>



	<tr class="windowbg2">



	  <td>You are not allowed to access this area.<br>



	  </td>



	</tr>



  </tbody>

</table>';

}
//Stealing is bad kids
copyright();

?>
</body>
</html>

THANKS!! :)

[Digiwire]

Hey,

Can you post your table structure for that page too.

[soil]

:unsure:

looks like ts something to do with i not setting '$image['loginimage']'

i dont think i have ever used this be4 ', MYSQL_ASSOC);' in mysql but something around there might be ur problem. :unsure:

hope that helps

[Digiwire]

Until I can see the table structure for the customize table there is not much that can be changed. Anyways for now try and use:

<?
/*
+-------------------------------------------------------
|	UltraBook 1.1
|	==============================
|	by Adam Bailey
|	(c)Copyright Adam Bailey
|	http://adamb10.com
+-------------------------------------------------------
|
|  > Edit Images Frontend
|  > Written by Adam bailey
|  > Date started: Friday January 20, 2005
|
+-------------------------------------------------------
*/

error_reporting (E_ALL);

//Connect to the databas
database_connect();

//Grab the title of the guestbook
$result = mysql_query ("SELECT `title` FROM `settings` LIMIT 1;");
$row = mysql_fetch_array ($result);

//Header for the guestbook(real creative name I know =D)
guestbook_header();

//Grab everything from the customize table
$get_image = mysql_query ("SELECT * FROM `customize` LIMIT 1");
$image = mysql_fetch_array ($get_image);


echo '<br><br><br>';

//Is the user logged in?
if(session_is_registered('Password')){
	adminpanel_side();

	echo '<td>
			<h3 style="text-align: center;"><span style="font-weight: bold;">Change Images</span></h3>
			<p align=center>Change the default images to whatever you want.</p><span style="font-weight: bold;"><br>
			<br>

			<form method="post" action="?action=saveimages" name="saveimages" >

		   	<img src="'.$image['homeimage'].'"><input size="30" name="homeimage" value="'.$image['homeimage'].'"><br><br>
			<img src="'.$image['loginimage'].'"><input size="30" name="loginimage" value="'.$image['loginimage'].'"><br><br>
			<img src="'.$image['logoutimage'].'"><input size="30" name="logoutimage" value="'.$image['logoutimage'].'"><br><br>
			<img src="'.$image['adminimage'].'"><input size="30" name="adminimage" value="'.$image['adminimage'].'"><br><br>
			<img src="'.$image['newpostimage'].'"><input size="30" name="newpostimage" value="'.$image['newpostimage'].'"><br><br>
			<div style="text-align: center;"><input value="Save" type="submit"></div><br>

			</form>

		</tr>
	</tbody>
</table>';

} else {

	// User is NOT logged in?  OK, display this then! 
	echo '<table class="border" style="width: 25%; text-align: left; margin-left: auto; margin-right: auto;" border="0" cellpadding="4" cellspacing="1" class="border">
			  <tbody>
			 <tr class="titlebg">
			  <td>Error</td>
			 </tr>
			 <tr class="windowbg2">
			  <td>You are not allowed to access this area.<br></td>
			 </tr>
			</tbody>
		</table>';
}

//Stealing is bad kids
copyright();

?>

[Prosidius]

Heres what the table looks like.

[JoeC]

Try just changing mysql_fetch_array to mysql_fetch_assoc. May not make a ha'peth of difference, but worth a try.

[Prosidius]

  JoeC said:

Try just changing mysql_fetch_array to mysql_fetch_assoc. May not make a ha'peth of difference, but worth a try.

Nope, doesnt work. :no:

[GatorV]

Try removing the LIMIT 1 from your SQL Querys...

[Prosidius]

  GatorV said:

Try removing the LIMIT 1 from your SQL Querys...

Didn't work. :(

[the_mole001]

are the images stored in another folder?

and by looking at that db pic the fields are blank anyways? can u give us an example on what is actually in the field, is it simply 'homeimage.gif'? or 'http://adamb10.com/book/homeimage.gif'?

because when viewing the site it has the link to the folder but nothing added on the end, that is to say the image is linking to http://adamb10.com/book/ and missing homeimage.gif...which makes me wonder if its even in the db?

[Prosidius]

I have the full urls in the DB. I used phpmyadmin and the INSERT query to put them in. Dunno why they wouldnt be there.

[the_mole001]

try putting:

$image = mysql_fetch_array(mysql_query("SELECT * FROM customize LIMIT 1"));

right after the adminpanel_side() funtion within the if statement of checking if the user is logged in

[Prosidius]

That does nothing. :(

[GatorV]

Try this script and see if you get the image urls in the output:

<?
/*
test script
*/

error_reporting (E_ALL);

//Connect to the databas
database_connect();

//Grab everything from the customize table
$get_image = mysql_query ("SELECT * FROM `customize` LIMIT 1") or die( "MySQL Error: " . mysql_error() );
$image = mysql_fetch_array($get_image, MYSQL_ASSOC)  or die( "MySQL Error: " . mysql_error() );

echo "<pre>";
var_dump( $image );
echo "</pre>";

?>

if it doesn't output, try again with this one:

<?
/*
test script
*/

error_reporting (E_ALL);

//Connect to the databas
database_connect();

//Grab everything from the customize table
$get_image = mysql_query ("SELECT * FROM `customize`") or die( "MySQL Error: " . mysql_error() );
$offset = 0;
while( $image = mysql_fetch_array($get_image, MYSQL_ASSOC) ) {
	echo "<pre>";
	echo "Result Number: $offset \n";
	var_dump( $image );
	echo "</pre>";
	$offset++;
}

?>