php data not showing in html . . . why

seanpaulcail

I have the following php code:

$query1 = ('select num_of_sm_images from Eli2 where page_number="5"');
$result1 = mysql_query($query1);
?>
<table width="<?php ($result1)*60 ?>" border="0" cellspacing="0">

but when I view my source code from my browser, nothing shows up in the width variable

Here's the ouput in html:

<table width="" border="0" cellspacing="0">

how can I get php to process the numbers. In other words I need the width to be the number of images times 60, since each image has a width of 60.

thanks

barand

Your $result1 is the resource result of the query. You ned to extract the data

$query1 = ('select num_of_sm_images from Eli2 where page_number="5"'); 
$result1 = mysql_query($query1); 
$num_images = mysql_result($result1, 0, 0);
?> 
<table width="<?php ($num_images)*60 ?>" border="0" cellspacing="0">

hth

seanpaulcail

it didn't work

I got it to work but my width is showing up as 60 instead of 60*num_of_sm_images

here's the code:

  $query1 = "SELECT num_of_sm_images FROM Eli2 where page_number='5'";
$result1 = mysql_query($query1);
$data = mysql_result($result1, 0, 'num_of_sm_images');

echo 'The data retrieved from the database is ' .$data;

Data shows up as 7 which is correct.

But when I try to do multiplication for the width, I get a blank.

here's the code for the width calculation:

<table width="<?php ($data)*60 ?>" border="0" cellspacing="0">

Why am I getting a blank instead of 420?

thanks

KevinMG

try...

<?php intval($data)*60; ?>

hopefully that helps

laserlight

actually, you need to
echo $data * 60;

webchef

$multiply = $num_images*60;

table width="<?php echo"$multiply"; ?>" border="0" cellspacing="0">

That should just about do it.

seanpaulcail

It worked

here's the code

<table width="<?php echo $data*60; ?>" border="0" cellspacing="0">

now how do I mark the thread as "resolved?"

thanks again