MYSQL results not showing up properly

[NetworkTown.Net]

Hi

I have this code:

$result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC"); 

while($row = mysql_fetch_array($result))
  {
 $name = $row['Name'];
}
echo $name
echo '<br />';

and it will not show the results properly it wiill only show the first result and not all of them. Any one got any suggestions?

 

[Barrucadu]

Try

foreach(mysql_fetch_array($result) as $row){

Instead of

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

 

[NetworkTown.Net]

Well it shows me

0

as the result

 

[Kate]

Well that's plain simple: the statement

echo $name

is outside the loop
The variable is assigned several times (in the loop) but only the last value will be printed.
BTW put the echo '<br />'; inside the loop too.

 

[NetworkTown.Net]

So i will change it to

 $result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC"); 

while($row = mysql_fetch_array($result))
  {
 $name = $row['Name'];

echo $name
echo '<br />';  
}

Well just tried it and it dose not give any result at all if i move the }

 

[Barrucadu]

Try:

 $result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC");  

foreach(mysql_fetch_array($result) as $row){
     $name = $row['Name']; 
     echo $name;
     echo '<br />';   
}

 

[NetworkTown.Net]

Try:

 $result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC");  

foreach(mysql_fetch_array($result) as $row){
     $name = $row['Name']; 
     echo $name;
     echo '<br />';   
}

wired becuase the results came out like this: 22DD22111100

 

[Kate]

Sample code:

<?php

mysql_connect("localhost", "user", "password") or
die("Could not connect: " . mysql_error());
mysql_select_db("your_db");

$result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo $row["name"] ."<br />";
}

mysql_free_result($result);
?>

 

[NetworkTown.Net]

Sample code:

<?php

mysql_connect("localhost", "user", "password") or
die("Could not connect: " . mysql_error());
mysql_select_db("your_db");

$result = mysql_query("SELECT DISTINCT * FROM category WHERE type = 1 ORDER BY Id DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo $row["name"] ."<br />";
}

mysql_free_result($result);
?>

aaaaa this is getting annying still is not working it is showing blank results, iv never had this prob before now suddenly i get this prob

 

[Kate]

Do you see errors reported by the server ?
Perhaps if you add this on top of your code:
error_reporting(E_ALL);

you will see possible PHP errors

 

[NetworkTown.Net]

EDIT: fixed it, it was the capital N i forgot to use in the $row['

 

[Tree]

Yeah, MySQL is case sensitive

 

[NetworkTown.Net]

Yeah, MySQL is case sensitive

I didnt know that lol thanks.