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 :-\