Simple MySQL / PHP Help?

  • Thread starter Thread starter James G
  • Start date Start date
J

James G

Guest
I know there mussst be a better way to write this stuff, can somebody please just lead me in the right diriection

This is the code:

$description1 = mysql_query("SELECT description FROM map WHERE mapnum = 1 + $pagenum");
$description2 = mysql_query("SELECT description FROM map WHERE mapnum = 2 + $pagenum");
$description3 = mysql_query("SELECT description FROM map WHERE mapnum = 3 + $pagenum");
$description4 = mysql_query("SELECT description FROM map WHERE mapnum = 4 + $pagenum");
$description5 = mysql_query("SELECT description FROM map WHERE mapnum = 5 + $pagenum");
$description6 = mysql_query("SELECT description FROM map WHERE mapnum = 6 + $pagenum");
$description7 = mysql_query("SELECT description FROM map WHERE mapnum = 7 + $pagenum");
$description8 = mysql_query("SELECT description FROM map WHERE mapnum = 8 + $pagenum");
$description9 = mysql_query("SELECT description FROM map WHERE mapnum = 9 + $pagenum");
$description10 = mysql_query("SELECT description FROM map WHERE mapnum = 10 + $pagenum");
$description11 = mysql_query("SELECT description FROM map WHERE mapnum = 11 + $pagenum");
$description12 = mysql_query("SELECT description FROM map WHERE mapnum = 12 + $pagenum");
$description13 = mysql_query("SELECT description FROM map WHERE mapnum = 13 + $pagenum");
$description14 = mysql_query("SELECT description FROM map WHERE mapnum = 14 + $pagenum");
$description15 = mysql_query("SELECT description FROM map WHERE mapnum = 15 + $pagenum");
$description16 = mysql_query("SELECT description FROM map WHERE mapnum = 16 + $pagenum");
$description17 = mysql_query("SELECT description FROM map WHERE mapnum = 17 + $pagenum");
$description18 = mysql_query("SELECT description FROM map WHERE mapnum = 18 + $pagenum");
$description19 = mysql_query("SELECT description FROM map WHERE mapnum = 19 + $pagenum");
$description20 = mysql_query("SELECT description FROM map WHERE mapnum = 20 + $pagenum");
$descriptionrow1 = mysql_fetch_row($description1);
$descriptionrow2 = mysql_fetch_row($description2);
$descriptionrow3 = mysql_fetch_row($description3);
$descriptionrow4 = mysql_fetch_row($description4);
$descriptionrow5 = mysql_fetch_row($description5);
$descriptionrow6 = mysql_fetch_row($description6);
$descriptionrow7 = mysql_fetch_row($description7);
$descriptionrow8 = mysql_fetch_row($description8);
$descriptionrow9 = mysql_fetch_row($description9);
$descriptionrow10 = mysql_fetch_row($description10);
$descriptionrow11 = mysql_fetch_row($description11);
$descriptionrow12 = mysql_fetch_row($description12);
$descriptionrow13 = mysql_fetch_row($description13);
$descriptionrow14 = mysql_fetch_row($description14);
$descriptionrow15 = mysql_fetch_row($description15);
$descriptionrow16 = mysql_fetch_row($description16);
$descriptionrow17 = mysql_fetch_row($description17);
$descriptionrow18 = mysql_fetch_row($description18);
$descriptionrow19 = mysql_fetch_row($description19);
$descriptionrow20 = mysql_fetch_row($description20);

$address1 = mysql_query("SELECT target FROM map WHERE mapnum = 1 + $pagenum");
$address2 = mysql_query("SELECT target FROM map WHERE mapnum = 2 + $pagenum");
$address3 = mysql_query("SELECT target FROM map WHERE mapnum = 3 + $pagenum");
$address4 = mysql_query("SELECT target FROM map WHERE mapnum = 4 + $pagenum");
$address5 = mysql_query("SELECT target FROM map WHERE mapnum = 5 + $pagenum");
$address6 = mysql_query("SELECT target FROM map WHERE mapnum = 6 + $pagenum");
$address7 = mysql_query("SELECT target FROM map WHERE mapnum = 7 + $pagenum");
$address8 = mysql_query("SELECT target FROM map WHERE mapnum = 8 + $pagenum");
$address9 = mysql_query("SELECT target FROM map WHERE mapnum = 9 + $pagenum");
$address10 = mysql_query("SELECT target FROM map WHERE mapnum = 10 + $pagenum");
$address11 = mysql_query("SELECT target FROM map WHERE mapnum = 11 + $pagenum");
$address12 = mysql_query("SELECT target FROM map WHERE mapnum = 12 + $pagenum");
$address13 = mysql_query("SELECT target FROM map WHERE mapnum = 13 + $pagenum");
$address14 = mysql_query("SELECT target FROM map WHERE mapnum = 14 + $pagenum");
$address15 = mysql_query("SELECT target FROM map WHERE mapnum = 15 + $pagenum");
$address16 = mysql_query("SELECT target FROM map WHERE mapnum = 16 + $pagenum");
$address17 = mysql_query("SELECT target FROM map WHERE mapnum = 17 + $pagenum");
$address18 = mysql_query("SELECT target FROM map WHERE mapnum = 18 + $pagenum");
$address19 = mysql_query("SELECT target FROM map WHERE mapnum = 19 + $pagenum");
$address20 = mysql_query("SELECT target FROM map WHERE mapnum = 20 + $pagenum");
$addressrow1 = mysql_fetch_row($address1);
$addressrow2 = mysql_fetch_row($address2);
$addressrow3 = mysql_fetch_row($address3);
$addressrow4 = mysql_fetch_row($address4);
$addressrow5 = mysql_fetch_row($address5);
$addressrow6 = mysql_fetch_row($address6);
$addressrow7 = mysql_fetch_row($address7);
$addressrow8 = mysql_fetch_row($address8);
$addressrow9 = mysql_
im not so worried about code length as im am trying to reduce the load of so many requests,

thank you btw to the first guy that answered =)
I just wasn't completely clear
 
Loops

I'm not very good with PHP at all, but you could do something like this:

for ( $count = 0; $count<=20; $count++; )
{
$description'$count' = mysql_query("SELECT description FROM map WHERE mapnum = '$count' + $pagenum");
}


Reducing your overall number of lines by 95% :)
 
Back
Top