Creating link out of DB Field

PsyberMind

Hey all.. I'm trying to create a link out of a Database Column and seem to be running into a small problem, in the way of:

Warning: extract() [function.extract]: First argument should be an array in /home/quicgcom/public_html/showvids2.php on line 55
link text

I know I messed something up big time, as this is the first time I've attempted such a thing (first time with PHP by myself, to be honest)

Heres the code. The offending snip is in the last TD

 </tr>
  <?php do { ?>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
    <tr>
      <td><?php echo $row_Recordset1['video_category']; ?></td>
      <td><?php echo $row_Recordset1['video_description']; ?></td>
      <td><?php
			$query="SELECT Link FROM Videos_List";
			$result="SELECT Link FROM Videos_List";
			$row= "$row_recordset1[video_link]";
			extract($row);
			?>

a search on the internet tells me that $row is probably empty, but I'm not sure what I did wrong to not fill it with data. I've got a repeaded display query running on the same page that looks like this:

mysql_select_db($database_vidlinks, $vidlinks);
$query_Recordset1 = "SELECT video_category, video_description, video_link FROM Videos_List ORDER BY video_category ASC";
$Recordset1 = mysql_query($query_Recordset1, $vidlinks) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

Any ideas?

garblar

you have $row_recordset1, but it should be $row_Recordset1
missing capital R

bradgrafelman

Also note that there's no need to have quotes around it if it's just another variable, which begs the question: why create a second variable, $row, that is identical to the first variable, $row_Recordset1['video_link'], instead of simply using the first variable?

Also, $row_Recordset1['video_link'] won't be an array, so I'm not sure what you're hoping to accomplish with [man]extract/man... perhaps you could explain what $row_Recordset1['video_link'] contains and what you're trying to do?