title: Php line graph by using GD and MySQL data
body: <p>I'm trying to draw a simple line graph which would use values from the database. At the moment I have a function which gets my data as it should and I also have another <code>.php</code> file which should be the one where the image is constructed.</p>
  
  <p>I've basically used the example from <a href="http://www.roseindia.net/tutorial/php/phpgd/About-linegraph.html" rel="nofollow">here</a> and it works if the values are typed manually. Nevertheless when I try to call <code>$arrval = functionToGetValues("$keyword");</code> it just won't work it won't draw anything. I'm guessing it's mostly because the <code>GD</code> is so messed up because it doesn't seem to work too good even with normal php commands.</p>
  
  <p>I think it's unnecessary to post exact code because <code>functionToGetValues</code> works and it just returns an array of values.</p>
  
  <p>I also tried to play with scopes like initializing the <code>$arrvals</code> in <code>functionToGetValues()</code> but it didn't work. My calling sequence was:</p>
  
  <p>/main.php</p>
  
  <pre><code>include "conn.php";
  
  ....
  
  dbquery("$keyword");
  
  //in dbquery($keyword)...
  
  $arrval = array(...);
  
  for($i=1; $i&lt;30;$i++)
  {
       $sql =  mysql_query("SELECT * FROM table WHERE data LIKE '%$keyword%'") or die("Query error: ". mysql_error());;
       $total = mysql_num_rows($sql);
  
  $arrval [$i] = $total;
  
  }
  
  &lt;img src='imgdraw.php?keyword=$keyword'vspace='50'/&gt;";
  </code></pre>
  
  <p>I also tried <a href="http://www.plus2net.com/php_tutorial//gd-linegp.php" rel="nofollow">this</a> type of solution but the include "conn.php" just doesn't seem to work with GD -_-. I can't find out the reason :(</p>