Error Encountered when using PHPlot to plot graph.

Hi, i am new to php. Any help will be much appreciated.

There is an error with the query although i do not know what to change to make it work.

Any ideas?

[php]
<?php
//Include the code
require_once 'phplot.php';
//Define the object
$plot = new PHPlot(800,600);
//Define some data

$dbhost = "localhost";
$username="root";
$password="";
$database="roy";


mysql_connect($dbhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM try2";

$r = mysql_query($query);
if (!$r) exit();
$data = mysql_fetch_array();
$n_rows = mysql_fetch_row($r);
for ($i = 0; $i < $n_rows; $i++) $data[] = mysql_fetch_row($r, $i);


$plot->SetDataValues($data);

//Turn off X axis ticks and labels because they get in the way:
$plot->SetXTickLabelPos('none');
$plot->SetXTickPos('none');
//Draw it
$plot->DrawGraph();
?>
[php]

1) Please enclose your code in [ PHP ] tags. See the sticky at the top of this forum.
2) Don't use the depreciated MySQL extensions. You should be using PDO.
3) Since we are not clairvoyant, you will need to post the error message.

Please, it's "deprecated". When I told you last time, you said it was a typo. But who makes the same typo every time he writes a word?

I do, obviously. Deprecate is a word I rarely use compared to depreciate so that is a natural typo for me. I don't know why I'm explaining myself to you anyway. Why are you so concerned with my typos in the first place? Is there anyone on this forum that you think is too dumb to understand what I meant?

...every time THEY write a word

If you are going to pick on someone, at least make sure your own grammar/English is acceptable or was that a typo?


PS> I am not having a go at you.

A special note to jeremsp. My apologies for being the vehicle through which someone decided to highjack your thread. Please resume your question.

Hi I thought i have enclosed the code within the [PHP] tags.
Sorry if i made any mistakes quite new here.

The error of the query is


Warning: mysql_fetch_array() expects at least 1 parameter, 0 given in C:\xampp\htdocs\PHPlot\phplot-5.8.0\test1.php on line 21

Warning: mysql_fetch_row() [function.mysql-fetch-row]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH in C:\xampp\htdocs\PHPlot\phplot-5.8.0\test1.php on line 23


and for the error on line 23 it just keep repeating until it cause lags and the window closes it. Did i loop it somewhere and cause it to repeat continuously? I really have no idea.

Untested but you replace all the obsolete MySQL stuff with this. You may need to reformat $data to get it the way you want.

P.S. You forgot the '/' in your closing PHP tag.

Hi. I have found a solution to the query and it works and a graph could be displayed.


By using this query it works.
Thank you all for your help.