Printing Values from MySQL to a PHP Page

[elementalskater]

Hey guys I'm a newbie on this forum, and more or less one to PHP. I participate in other forums (based on website creation and maintenance), PM me if you want to know where.

Basically, what I want to do is print values from a MySQL table to a php page. I have no problem including the necessary php script to access the DB, etc etc. But I ran into problems when trying to print the values.

The page at which I am trying to print to is http://guards.dscpool.com and the script is (that is includes-ed) as follows:

<?php
$connect= mysql_connect ("localhost", "...", "...") or die ('Database failure: ' . mysql_error($dbh));
mysql_select_db ("...");
$get=mysql_query("SELECT * FROM may");
if ($get) {
$info=mysql_fetch_assoc($get);
}
else {
echo "Error:" . mysql_error();
}
mysql_close($connect);
?>

The page is currently displaying an error. I don't know what it is or how to fix it. Any help would be apprecated.

[LordShryku]

Real easy...you can find this script all over the forums here, so you may want to try searching before posting, but here's what you need...

<?
$connect= mysql_connect ("localhost", "...", "...") or die ('Database failure: ' . mysql_error()); 
mysql_select_db ("some_db"); 
$get=mysql_query("SELECT field1 FROM table"); 
$rows=mysql_num_rows($get);
if($rows > 0) {
    while($row=mysql_fetch_array($get)) {
        echo "Field 1: ".$row['field1']."<br>";
    }
}
else {
    echo "No rows returned";
}
mysql_close($connect); 
?>

[elementalskater]

but i'm not sure you understand my problem.

the php (external) script works fine. its the printing INSIDE the index.php (non-external) that doesn't. thats where the error is coming from. it is setup like:

<?php
include ('http://guards.dscpool.com/php/maysched.php');
echo "$info[may29morn1]";
echo "$info[may29morn2]";
echo "$info[may29morn3]";
...etc.etc....
print ('<table......<td><p>').$info[may20morn1].('</td>....
...etc.etc....
?>

and on line 158 it is printing some error. i can't find it! but is the above code even going to pring what i want where i want? please help! thanks.

[elementalskater]

anybody?

[ofSHIZ]

Maybe give us the code were the error is at?

[elementalskater]

It says it's somewhere in here (i always lose count going up that high on the lines):

print ('<tr><!-- Week 5 -->
  <td class=\"day\"><p class=\"daynumber\">23</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">24</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">25</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">26</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">27</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">28</p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">29</p>
  <p class=\"content\">9-3:  ').$info[may29morn1].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may29aft1].('<br />
  9-3:  ').$info[may29morn2].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may29aft2].('<br />
  9-3:  ').$info[may29morn3].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may29aft3].('<br />
  9-3:  ').$info[may29morn4].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may29aft4].('<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6D:  ').$info[$may29des].('&nbsp;&nbsp;&nbsp;<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6:  ').$info[may29mid].('&nbsp;&nbsp;&nbsp;<br /></p>
  </td>
</tr>');
print ('<tr><!-- Week 6 -->
  <td class=\"day\"><p class=\"daynumber\">30</p>
  <p class=\"content\">9-3:  ').$info[may30morn1].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may30aft1].('<br />
  9-3:  ').$info[may30morn2].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may30aft2].('<br />
  9-3:  ').$info[may30morn3].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may30aft3].('br />
  9-3:  ').$info[may30morn4].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may30aft4].('<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6D:  ').$info[may30des].('&nbsp;&nbsp;&nbsp;<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6:  ').$info[may30mid].('&nbsp;&nbsp;&nbsp;<br /></p>
  </td>
  <td class=\"day\"><p class=\"daynumber\">31</p>
  <p class=\"content\">9-3:  ').$info[$may31morn1].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may31aft1].('<br />
  9-3:  ').$info[may31morn2].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may31aft2].('<br />
  9-3:  ').$info[may31morn3].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may31aft3].('<br />
  9-3:  ').$info[may31morn4].('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3-9:  ').$info[may31aft4].('<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6D:  ').$info[may31des].('&nbsp;&nbsp;&nbsp;<br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-6:  ').$info[may31mid].('&nbsp;&nbsp;&nbsp;<br /></p>
  </td>....');

[helz]

might be easier to code php where it lights up all the code with different colours, also with line numbers to the side... some simple wysiwyg will do like: dreamweaver or frontpage