生成重复语法的数组


makeing array of repeated syntax

我可以制作以下重复语法的数组和循环吗:

$row1=mysql_fetch_array(mysql_query("SELECT `name_of_book` from `mytable` where  = `date_borrow`= curdate() ));
$row2=mysql_fetch_array(mysql_query("SELECT `name_of_book` from `mytable` where  = `date_borrow`= curdate()+1 ));
$row3=mysql_fetch_array(mysql_query("SELECT `name_of_book` from `mytable` where  = `date_borrow`= curdate()+2 ));
$row4=mysql_fetch_array(mysql_query("SELECT `name_of_book` from `mytable` where  = `date_borrow`= curdate()+3 ));
.
.
.
.
$row50=mysql_fetch_array(mysql_query("SELECT `name_of_book` from `mytable` where  = `date_borrow`= curdate()+49 ));

以及我如何回应$row23 的name_of_book

感谢

这样的东西就可以了。

$rows = mysql_query("SELECT name_of_book, date_borrow from mytable where date_borrow < DATE_ADD(CURDATE(), INTERVAL 50 DAY) ");
$i = 0;
while ($row = mysql_fetch_assoc($rows)) {
    if($i>22 || $i < 41){
      echo $row["name_of_book"];
      echo $row["date_borrow"];  
     }
    $i = $i+1;
}