Help in displaying all the record instead of 1

[Rocky86]

Hi ppl I need help with my php basically I manage to get my php to display the uname that matches the sql condition however it only return 1 record when there are 2 record that match the condition how do I make it display all record that matches the condition instead of displaying just one?
This is my code:
[PHP]
$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='56' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

$counterx=0;
if($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}





$report.="uid"."=".$temp[0]."&";
$report.="uname"."=".$temp[1]."&";




echo $report;


[/PHP]

[pbmods]

Heya, Rocky.

Change this line:

if($row=mysql_fetch_array($resultpostal)){
 

to:

while($row=mysql_fetch_assoc($resultpostal)){
 

s/if/while/
s/array/assoc/

[Rocky86]

Heya, Rocky.

Change this line:

if($row=mysql_fetch_array($resultpostal)){
 

to:

while($row=mysql_fetch_assoc($resultpostal)){
 

s/if/while/
s/array/assoc/

Hey pbmods I did what you mention but it does not seen to work at all it just basically return me the value "3"

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

After I change back then it still return me one record but when I do a testing on the SQL statement it return me 2 record but in php it just return me 1

[pbmods]

Heya, Rocky.

Let's organize your code real quick:

$temp = array();
 
while($row = mysql_fetch_assoc($resultpostal))
{
    $temp[] = $row;
}
 
print_r($temp);
 

Put this right after your MySQL query and get rid of everything else below it.

[Rocky86]

Heya, Rocky.

Let's organize your code real quick:

$temp = array();
 
while($row = mysql_fetch_assoc($resultpostal))
{
    $temp[] = $row;
}
 
print_r($temp);
 

Put this right after your MySQL query and get rid of everything else below it.

I did as you suggest it now return me nothing at all worse then just now this statement iszit to check if it return all the recordS?

[jx2]

I did as you suggest it now return me nothing at all worse then just now this statement iszit to check if it return all the recordS?

pbmods is right!!

insted of giving u the answer i try to explain you how it works

it dosnt return just one record!!(if there are records matching your criteria) it return THE FIRST RECORD ONLY!!!
if u want the second record u need to call mysql_fetch_array() or mysql fech row() again and again

therefore pbmods sugested you to change "if" to "while"

there is ofcurse posible your query doesnt math anything

i sugest to try somthing simplier at the begining and modify it to your needs later

[PHP]
$result = mysql_query(" SELECT * FROM yourtable");
echo "<table>";
while($record = mysql_fetch_row($result))
{
//notice i do not compare it i asign it (single "=" not "==")
// the statment above is true as long as thre are records to read
// $record is an array!! therefore:
echo "<tr>";
foreach($record as $var){
echo "<td>$var</td>";
}
echo "</tr>";
}
echo "</table>";
[/PHP]

that should display all records in your table
you can modify the query to your need later

i hope that helps
jx2

[pbmods]

Heya, Rocky.

I did as you suggest it now return me nothing at all worse then just now this statement iszit to check if it return all the recordS?

I put up that code to help you understand what the code is doing.

The solution to your problem is actually quite simple, but only if you know how your code works.

[Rocky86]

Heya, Rocky.



I put up that code to help you understand what the code is doing.

The solution to your problem is actually quite simple, but only if you know how your code works.

Hey pbmods that code you put is just returning the record that match my sql statement that all what is the solution to my problem plss help

[Rocky86]

pbmods is right!!

insted of giving u the answer i try to explain you how it works

it dosnt return just one record!!(if there are records matching your criteria) it return THE FIRST RECORD ONLY!!!
if u want the second record u need to call mysql_fetch_array() or mysql fech row() again and again

therefore pbmods sugested you to change "if" to "while"

there is ofcurse posible your query doesnt math anything

i sugest to try somthing simplier at the begining and modify it to your needs later

[PHP]
$result = mysql_query(" SELECT * FROM yourtable");
echo "<table>";
while($record = mysql_fetch_row($result))
{
//notice i do not compare it i asign it (single "=" not "==")
// the statment above is true as long as thre are records to read
// $record is an array!! therefore:
echo "<tr>";
foreach($record as $var){
echo "<td>$var</td>";
}
echo "</tr>";
}
echo "</table>";
[/PHP]

that should display all records in your table
you can modify the query to your need later

i hope that helps
jx2

hey jx2 basically the code you post is returning all the record which not what I want to acheive for my case I need to compare the value and return the uname and uid of whoever that matches my sql condition right now my code is able to just return 1 record instead of all the record that matches the condition trying to make it display not just 1 but all the record that matches the sql condition

[kovik]

hey jx2 basically the code you post is returning all the record which not what I want to acheive for my case I need to compare the value and return the uname and uid of whoever that matches my sql condition right now my code is able to just return 1 record instead of all the record that matches the condition trying to make it display not just 1 but all the record that matches the sql condition

He's not writing the code for you, he's giving you an example of how to retrieve data from a query result. If you want it to match your SQL, then replace the query he gave to you with your query.

I really suggest that you go back and read some beginner's tutorials. You seem to keep thinking that everyone is writing your code for you when all we're doing is trying to teach you, and if you understood the code instead of just copying and pasting it, you'd know that. There's are plenty of books available as well to help you 'break out' of being a novice programmer into an intermediate stage.

[Rocky86]

He's not writing the code for you, he's giving you an example of how to retrieve data from a query result. If you want it to match your SQL, then replace the query he gave to you with your query.

I really suggest that you go back and read some beginner's tutorials. You seem to keep thinking that everyone is writing your code for you when all we're doing is trying to teach you, and if you understood the code instead of just copying and pasting it, you'd know that. There's are plenty of books available as well to help you 'break out' of being a novice programmer into an intermediate stage.

I understand the mysql_fetch_array is only able to fetch the first row but not the second or third and so on But I reallx want to know how to do that? able to fetch not just the first row but all the row that match the sql condition pls help

[dafodil]

Hey man. You should really study. I checked all your posts. It seems you're not really interested in learning. I adviced you already in your previous thread. Are you using this site to create your own project? Its not good.

This site is a good start for learning: http://w3schools.com/

you can also try this: http://movielibrary.lynda.com/html/modPage.asp?ID=435

Your previous thread already came up to 28 posts with simple questions that's not hard to understand...

With a thread title how to use logic for my code?. That's shows how lazy you are, you even want us to solve the logic of your program.

When all you need to learn is the syntax of the language and the logic is the application of it!!!!!

[Rocky86]

how come the uid is undefined value on the actionscripts? the uname is able to be display but the uid is undefinded I don't see any wrong with my code but I don't know why it return undefinded value?
[PHP]
$counterx=0;
if($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}





$report.="uid"."=".$temp[0]."&";
$report.="uname"."=".$temp[1]."&";




echo $report;


[/PHP]

[kovik]

You need to start doing some debugging. Make your ActionScript display everything from the PHP file, and start making the PHP file echo out everything that you can. There is no magic solution... You HAVE to put forth some effort.

[Rocky86]

You need to start doing some debugging. Make your ActionScript display everything from the PHP file, and start making the PHP file echo out everything that you can. There is no magic solution... You HAVE to put forth some effort.

I understand I will do it thx

[Rocky86]

You need to start doing some debugging. Make your ActionScript display everything from the PHP file, and start making the PHP file echo out everything that you can. There is no magic solution... You HAVE to put forth some effort.

Hey volectricity I did alot of testing and I realize that it keep returning me the same value for both the uname and uid:

uid=Khali Signh&uname=Khali Signh&

this is what I get what is wrong with it I don't know why the uid is displaying the same value as the uname when it should be displaying uid

[pbmods]

Heya, Rocky.

Quick, what's the difference between if and while?

The answer to that question is the reason why you're only getting one record.

If you don't know the answer to that question, you might want to consider picking up a PHP programming book, or else have a look at PHP Control Structures.

[Rocky86]

Heya, Rocky.

Quick, what's the difference between if and while?

The answer to that question is the reason why you're only getting one record.

If you don't know the answer to that question, you might want to consider picking up a PHP programming book, or else have a look at PHP Control Structures.

Hey pbmods I noe the different between the if and while if just loop through 1 record while loop through all the record until that is no matching result but I try both using if and while it still return me the same thing

[pbmods]

Heya, Rocky.

Never mind me. Upon closer inspection, your problem is actually here.

foreach($row as $col_value)
{
    $temp[$counterx] = $col_value;
    $counterx++;
}
 

You'll want to change that entire block to simply:

$temp[] = $row;
 

Then to create $report:

$report = '';
foreach($temp as $row => $data)
{
    $report .= ($report ? '?' : '&') . "uid={$data[0]}&uname={$data[1]}";
}
 

[Rocky86]

Heya, Rocky.

Never mind me. Upon closer inspection, your problem is actually here.

foreach($row as $col_value)
{
    $temp[$counterx] = $col_value;
    $counterx++;
}
 

You'll want to change that entire block to simply:

$temp[] = $row;
 

Then to create $report:

$report = '';
foreach($temp as $row => $data)
{
    $report .= ($report ? '?' : '&') . "uid={$data[0]}&uname={$data[1]}";
}
 

Hey pbmods I manage to get the both the uid and uname to be display actionscripts by this php code I did:

[PHP]
$report = "&";

$counterx=0;
while($row=mysql_fetch_assoc($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}


$report.="uid"."=".$temp[1]."&";
$report.="uname"."=".$temp[0]."&";



echo $report;

[/PHP]

Thx I finally manage to do it with a different method after trying and trying