Way to SELECT a table the draw two seperate rows from that table??

[carefree]

Is there a way to SELECT a  table the draw two seperate rows from that table?

 

Heres what im trying to do:

 

$cnx = mysql_connect("localhost", "DATABASE USER", "PASSWORD");
mysql_select_db("DATABASE NAME", $cnx);
$sql = mysql_query("SELECT VID FROM video") or die (mysql_error());
while($row = mysql_fetch_array($sql)){
   $row_array[] = $row['VID'];
}
mysql_close($cnx);
$random_row = $row_array[rand(0, count($row_array) - 1)];

echo '<a href="http://www.DOMAIN.com/"><img src="http://DOMAIN.com/vid/thumb/', urlencode($random_row),'.jpg" border="0"></a>';

 

Ok so the "VID" row is the url of the video thumb

 

I also want to draw the name from the same video and place it into the "http://www.DOMAIN.com/" section . The rows name is "title"

 

Ive tried to use:

 

$cnx = mysql_connect("localhost", "DATABASE USER", "PASSWORD");
mysql_select_db("DATABASE NAME", $cnx);
$sql = mysql_query("SELECT VID,table FROM video") or die (mysql_error());
while($row = mysql_fetch_array($sql)){
    $row_array[] = $row['VID,table'];

 

But no luck :-\

[toplay]

Example:

 

SELECT col_name_1, col_name_2, col_name_3 FROM table_name

 

See syntax manual page:

 

http://dev.mysql.com/doc/refman/5.0/en/select.html

[fenway]

I have no idea what you're trying to accomplish -- please expalin