<?php
include ("php_includes/db_conx.php");
$sql = "SELECT sun_zodiac, mon_zodiac, tue_zodiac, wed_zodiac, thur_zodiac, fri_zodiac, sat_zodiac FROM horoscope WHERE zodiac_sign = 'Taurus' OR zodiac_sign = 'Virgo'OR zodiac_sign = 'Capricorn' LIMIT 0 , 30";
$result = mysqli_query($db_conx,$sql);
while($row = mysqli_fetch_array($result)) {
//Array is set up to capture values out the database by rows which will number 3.
$sunday_daily[] = $row['sun_zodiac'];
$monday_daily[] = $row['mon_zodiac'];
$tuesday_daily[] = $row['tue_zodiac'];
$wednesday_daily[] = $row['wed_zodiac'];
$thursday_daily[] = $row['thur_zodiac'];
$friday_daily[] = $row['fri_zodiac'];
$saturday_daily[] = $row['sat_zodiac'];
}
?>
<script>
var dailyTaurus = ["<?php $sunday_daily[1]; ?>", "<?php $monday_daily[1]; ?>", "<?php $tuesday_daily[1]; ?>", "<?php $wednesday_daily[1]; ?>", "<?php $thursday_daily[1]; ?>", "<?php $friday_daily[1]; ?>", "<?php $saturday_daily[1]; ?>"];
var dailyVirgo = ["<?php $sunday_daily[2]; ?>", "<?php $monday_daily[2]; ?>", "<?php $tuesday_daily[2]; ?>", "<?php $wednesday_daily[2]; ?>", "<?php $thursday_daily[2]; ?>", "<?php $friday_daily[2]; ?>", "<?php $saturday_daily[2]; ?>"];
var dailyCapricorn = ["<?php $sunday_daily[0]; ?>", "<?php $monday_daily[0]; ?>", "<?php $tuesday_daily[0]; ?>", "<?php $wednesday_daily[0]; ?>", "<?php $thursday_daily[0]; ?>", "<?php $friday_daily[0]; ?>", "<?php $saturday_daily[0]; ?>"];
</script>
<?php
//Values return fine using PHP
echo $sunday_daily[0] . "<br><br>";
echo $sunday_daily[1] . "<br><br>";
echo $sunday_daily[2] . "<br><br>";
?>
<script>
alert(dailyVirgo[1]);
//Returns absolutely nothing.
/*
I have done some research about JSON encoding like this
*/
var dailyVirgo = <?php echo json_encode($sunday_daily[0]) ?>;
//alert(dailyVirgo[1]);
/*It would really benefit me to understand this technique well, I need to manage this information to finish a project Can someone help me understand what I am missing please?*/
</script>