using string as field name

denniston

I'm trying to make a webpage that changes depending upon the day. as for now I'm having the user select the week and day from a drop box. which then parses the information into the address bar.
ala: ...devo2.php?week=1&day=monday

page selects a record from the database depending on the information supplied.

the feilds are
mondayVerse, tuesdayVerse, wednesdayVerse, etc.

In the part of the attached script I want to know how to make:
$result = mysql_query("SELECT FROM devo WHERE index = 1",$db);
somethinglike
$result = mysql_query("SELECT FROM devo WHERE index = $day",$db);

$myrow["mondayQuestions"]
something like
$myrow[$day & 'Questions'"]

weekender

if your url is in the form

devo2.php?week=1&day=monday

then just do

$day = $_GET['day']; // $day == 1

if you want to make variable variables (that's what it's called, i kid you not!)

$newvarname = "thisismynewvarname";
$$newvarname = 1;
echo $thisismynewvarname; //echoes 1

adam

leatherback

hi,

Not sure how you have your tables set up. But what I read from your post, most surely you have it set-up fairly inefficiently..

(or better: | ID | Date | Verse |)

query = "select Verse from verses where Day=$day";
  $result = mysql_query($query); 
  while ( $row = mysql_fetch_array($result))
   {
    echo $row[Verse];
   }

denniston

here's the code for my page, I thought I had it attached to the first thread

<?php

$db = mysql_connect("localhost", "church_devo");

mysql_select_db("church_crave",$db);

$result = mysql_query("SELECT * FROM devo WHERE index = $day",$db);

if ($myrow = mysql_fetch_array($result)) {

do {

printf("<font size=+1>%s - $day</font><hr>%s<br>Objective: %s<hr><br>%s<br><br> %s<br> %s<br></face>\n", $myrow["title"], $myrow["topic"], $myrow["objective"], $myrow["mondayVerse"], $myrow["mondayQuestions"], "<TEXTAREA ROWS=5 COLS=48></TEXTAREA>");

} while ($myrow = mysql_fetch_array($result));

} else {

echo "Sorry, no records were found!";

}

The table is set up with each row is a week.
there are 5 lessons per week, 1 theme per week, 1 topic.
you can see it in action at :
http://www.fairmountwesleyan.org/devo.html