Is there a way to make a field in a table a variable?

[Wales]

I'm trying to do a

SELECT links FROM mytable

and use the field links as a variable. What I want is to be able to select links and add <?php echo 'links'; ?> outside of the main php and incorporated into the main html. It'll look something like

<object width="425" height="355"><embed src="<?php echo '$links'; ?>" type="application/x-shockwave-flash" wmode="transparent" width="425" height="355"></embed></object>

I eventually want to put my links into an object.

[Sanoz0r]

$result = mysql_query("SELECT links FROM mytable ", $dbconn);  

while ($row = mysql_fetch_array($result)) echo $row['link']."<br>";

this should start you off... 🙂

[Wales]

Thanks that's what I was using. Now how do I but the echo $row['link'] into the embed source code?

[Sanoz0r]

<?php
while ($row = mysql_fetch_array($result)) { ?>
<object width="425" height="355"><embed src="<?php echo $row['link']; ?>" type="application/x-shockwave-flash" wmode="transparent" width="425" height="355"></embed></object>
<?php } ?>

I assume you will also need to insert these links into a table or something?