[SOLVED] please help!!!!!

[nikhildigde]

hey iv written an applicn using MySQL in PHP......the connection is done properly but its not displaying all the tuples.......its jus printing the 1st one......

 

<?php

mysql_connect('localhost','dname','pass');

mysql_select_db('test');

$query="select * from tbname";

mysql_query($query);

$res=mysql_fetch_array($res);

for($i=0;$i<count($res);$i++)

{

    echo $res[$i];

}

?>

 

please help!!!

[Maq]

Try this:

 

mysql_connect('localhost','dname','pass');
mysql_select_db('test');
$query="SELECT * FROM tbname";
$result = mysql_query($query) or die(mysql_error());
while ($res=mysql_fetch_array($result)) {
    echo $res['name1'];
    echo $res['name2'];
}
?>

 

[rhodesa]

you need to loop over the rows too:

 

<?php
mysql_connect('localhost','dname','pass');
mysql_select_db('test');
$query="select * from tbname";
$res=mysql_query($query);
while($row=mysql_fetch_array($res)){
  for($i=0;$i<count($row);$i++)
  {
    echo $row[$i];
  }
}
?>

[nikhildigde]

thanks dude i got it.......

 

 

cheers!!!

[Maq]

thanks dude i got it.......

 

 

cheers!!!

 

cool solved then?