increasing numbers???

[ericburnard]

Hi there i have the following javascript

 

<table width=150><tr><td>
  <script language="JavaScript">
      //Link[nr] = "position [0 is menu/1 is item],Link name,url,target (blank|top|frame_name)"
  var Link = new Array();
  Link[0] = "0|Home";
  Link[1] = "1|Home|http://www.javascriptsource.com|";
  Link[2] = "1|More Scripts|http://www.javascript.com|";
  Link[3] = "1|Contact|http://www.javascriptsource.com/contact-us.html|";
  Link[4] = "1|Traffic|http://www.thecounter.com|";
  Link[5] = "0|Access";
  Link[6] = "1|Login|Login.asp|";
  Link[7] = "1|Logout|Logout.asp|"
  Link[8] = "0|Scripts";
  Link[9] = "1|Asp|http://www.javascriptsource.com|";
  Link[10] = "1|JavaScript|http://www.javascriptsource.com|";
  Link[11] = "0|Links";
  Link[12] = "1|JavaScript sites|http://www.javascripts.com|blank";

  startup(4);
  </script>
</td></tr></table>

 

As you can see the link number increases every time. I have put what i need of this code into my php -

 

<?
include('mheader.html');
include ('db.php');

$cookie=$_COOKIE["cusername"];

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM blog ORDER BY id DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<table width=150><tr><td>
  <script language='JavaScript'>
      //Link[nr] = 'position [0 is menu/1 is item],Link name,url,target (blank|top|frame_name)'
  var Link = new Array();";
   
$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"id");
$subject=mysql_result($result,$i,"subject");
$blog=mysql_result($result,$i,"blog");
$date=mysql_result($result,$i,"date");

echo "
  Link[0] = '0|$id : $subject : $date';
  Link[1] = '1|$blog|$blog|';";

$i++;
};

echo "startup(4);
  </script>
</td></tr></table><BR><BR>";
  
?>

 

The only problem i have now is that when the script repeats itself its just using the numbers 0 and 1 what i need it to do is 0,1 then the next repeat 2,3 the next 4,5 and so on im not to sure how to go about doing this??

Any help would be great.

Thanks again

Eric

[Ken2k7]

Try:

<?php
include('mheader.html');
include ('db.php');

$cookie=$_COOKIE["cusername"];

mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM blog ORDER BY id DESC";
$result=mysql_query($query) or die(mysql_error());

$num=mysql_num_rows($result) or die(mysql_error());

echo "<table width=150><tr><td>
  <script language='JavaScript'>
      //Link[nr] = 'position [0 is menu/1 is item],Link name,url,target (blank|top|frame_name)'
  var Link = new Array();";

while ($row = mysql_fetch_array($result)) {

echo "
  Link[0] = '0|{$row['id']} : {$row['subject']} : {$row['date']}';
  Link[1] = '1|{$row['blog']}|{$row['blog']}|';";
};

echo "startup(4);
  </script>
</td></tr></table><BR><BR>";
  
?>

 

By the way, you never used the date column. Did you mean to say blog|date or blog|blog back-to-back?

[kenrbnsn]

That does not solve the OP's problem, in fact it has the same problem -- you are explicitly setting the index. Try this:

<?php
include('mheader.html');
include ('db.php');

$cookie=$_COOKIE["cusername"];

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM blog ORDER BY id DESC";
$result=mysql_query($query);
echo "<table width=150><tr><td>
  <script language='JavaScript'>
      //Link[nr] = 'position [0 is menu/1 is item],Link name,url,target (blank|top|frame_name)'
  var Link = new Array();";
$i = 0;
$tmp = array();
while ($rw = mysql_fetch_assoc($result)) {   
    $tmp[] = 'Link[' . $i++ . "] = '0|" . $rw['id'] . ' : ' . $rw['subject'] . ' : ' . $rw['date'] . "'";
    $tmp[] = 'Link[' . $i++ . "] = '1|" . $rw['blog'] . '|' . $rw['blog'] . "|'"; 
};
echo implode("\n",$tmp) . "\n";	
echo "startup(4);
  </script>
</td></tr></table><BR><BR>";
  
?>

 

Ken

[ericburnard]

Thanks for that ken, the only problem is that im not getting anything diplayed im getting my header and if i echo some text i get that but its not displaying anything in the database??

 

Im not amazing at php so could you explain some of the changes for me

 

Thanks

Eric