[SOLVED] help crazy output

[teng84]

why do i get a single value of array when doing print_r 

the page contain more than 10,000 record

i dont understand as you can see everything is fine can you tell me the possible solution or error

 

$qry = "SELECT * FROM categories ";
$result=mysql_query($qry);
$total = mysql_fetch_array($result);
print_r($total);

 

 

 

 

[jcombs_31]

use an associative array. I don't understand why you want want to return your results they way you are doing it. I tend to always use a while loop

 

while($row = mysql_fetch_assoc($result)) {
  echo $row['field in db you want'];

  or do something else with it
}

[teng84]

even if i do that i get single result. like what ive said i have morethan 10, 000 record but when i do the fetch thing it returns only one record???? we have a test server which i test this using php myadmin and everything works fine .

 

can you tell me the possible error im doing

[cooldude832]

try mysql_num_rows($result) that might give you some clue

[teng84]

i tried everything when i do this

SELECT count(id) FROM categories

it returns correct result

 

but the error is that when i will have morethan one in my array tru msql fetching

it will only return single result

 

 

 

[cooldude832]

just humor me and run this version

<?php
$q = "SELECT * FROM categories";
$result = mysql_query($q) or die(mysql_error());
$total = mysql_fetch_assoc($result);
$rows = mysql_num_rows($result);
echo "Number of Rows: ".$rows."<br/><br/><br/>";
print_r($total);
?>

and then view its source

 

[teng84]

thank for the help i think its a server error

any ways thanks for the help

 

i will never forget this crazy error i got this makes my day  > >

[cooldude832]

just remember its $_SESSION not $_SESSSION

[Barand]

$qry = "SELECT * FROM categories ";
$result=mysql_query($qry);
$total = mysql_fetch_array($result);
print_r($total);

 

You do the query, you get the first record, you print_r its contents.

 

Why would you expect more than one record with that code?

[teng84]

barand i think when you print_r your fetch thing it will return the whole content i see my error

 

and the error is that i have the same variable name so when the loop run it gets overwriten

its really hard to find the error because this is big site and it have thousands of lines

 

any way thanks