MySql variables as source for Dynamic image?

[al3x8730]

I'm using this:

 

<?php

include "header.php";
$Num = mysql_query("SELECT * FROM `users`");
$Num = mysql_num_rows($Num);


// Create a 100*30 image
$im = imagecreate(100, 30);

// White background and blue text
$bg = imagecolorallocate($im, 255, 255, 255);
$textcolor = imagecolorallocate($im, 0, 0, 255);

// Write the string at the top left
imagestring($im, 5, 0, 0, $Num, $textcolor);

// Output the image
header('Content-type: image/png');

imagepng($im);
imagedestroy($im);
?>

 

As an source to make an image with the number of users in my database. Is there any reason why this shouldn't work >.>?

 

btw header.php is connection to MySql.

[Adam]

I tested it without the MySQL and it worked fine, I can only imagine its either that or you don't have the GD library installed on your version of PHP, is it a free host you use?

 

Adam

[genericnumber1]

It would be better to use select COUNT(*) and you forgot to use imagefill() to make the background white. What is it doing that you think it wouldn't work?

[al3x8730]

I tested it without the MySQL and it worked fine, I can only imagine its either that or you don't have the GD library installed on your version of PHP, is it a free host you use?

 

Adam

 

It works when I use a string, or a variable, just not with the MySql variable...

[Adam]

Okay try checking if there's an error with the mysql:

 

$Num = mysql_query("SELECT * FROM `users`") or die(mysql_error());
$Num = mysql_num_rows($Num) or die(mysql_error());

[al3x8730]

Okay try checking if there's an error with the mysql:

 

$Num = mysql_query("SELECT * FROM `users`") or die(mysql_error());
$Num = mysql_num_rows($Num) or die(mysql_error());

 

Nope, there's no error in the MySql, just checked, and infact I use this same code accept with an echo to show how many users are in the database elsewhere, any other ideas? Dx

[Garethp]

Try imagestring($im, 5, 0, 0, '$Num', $textcolor);

 

Also, try echoing $Num, what is it?

 

 

 

 

 

 

 

 

 

Side Note:

Check your messages, I sent you one