Ad:

PHP Discussion Thread
Unsolved
Views: 762

Mar 5th, 2010

Issue with fetch row

Expand Post »

Hello there, I'm not getting the result's I want with my code.

So this is my table:

P_ID Latitude Longitude
9001 15 10
9002 23 54
9003 2 23
9004 23 12
9005 54 23

And here is my code:

PHP Syntax (Toggle Plain Text)
//connect
//ordering the latitude 
$query="SELECT Latitude FROM Position ORDER BY Latitude ASC";
$result=mysql_query($query);
 
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);
 
echo $row[0];
echo $row[1];
echo $row[2];
//connect
//ordering the latitude 
$query="SELECT Latitude FROM Position ORDER BY Latitude ASC";
$result=mysql_query($query);

if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);

echo $row[0];
echo $row[1];
echo $row[2];

Issue: I want to be able to retrieve any row I want but this code keeps giving me back only the first result. In this specific example the result is ''2'' which is the Latitude of the row 0 since I order the column ASC.
Do you have any suggestion ? To get other values?

Thank you

Similar Threads

Dynamic Row Input Problem in JavaScript / DHTML / AJAX
data adapter doesnt fetch the last row in VB.NET
Problems deleting row from DataTable in VB.NET
Editing a Single fixed row in a mysql database in PHP
Stack overflow issue in C++

pedroteixeira07

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Feb 2010

Permalink

Mar 5th, 2010

Re: Issue with fetch row

PHP Syntax (Toggle Plain Text)
 <?php
//connect
 //ordering the latitude
 $query="SELECT Latitude FROM Position ORDER BY Latitude ASC";
 $result=mysql_query($query);
 if (!$result) {
 	echo 'Could not run query: ' . mysql_error();
 	exit;
 }
while ($row = mysql_fetch_assoc($result)) {
 	echo $row['Latitude']."<br />";
}
 
?>
 <?php
//connect
 //ordering the latitude
 $query="SELECT Latitude FROM Position ORDER BY Latitude ASC";
 $result=mysql_query($query);
 if (!$result) {
 	echo 'Could not run query: ' . mysql_error();
 	exit;
 }
while ($row = mysql_fetch_assoc($result)) {
 	echo $row['Latitude']."<br />";
}
 
?>

Try the above code.

Go through the following
http://php.net/manual/en/function.mysql-fetch-assoc.php

as.bhanuprakash

Reputation Points: 16

Solved Threads: 19

Junior Poster

Offline

109 posts
since Dec 2009

Permalink

Mar 5th, 2010

Re: Issue with fetch row

PHP Syntax (Toggle Plain Text)
//connect
//ordering the latitude 
$query="SELECT * FROM Position ORDER BY Latitude ASC";
$result=mysql_query($query);
 
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
while($row = mysql_fetch_row($result))
{
echo $row['P_ID ']."<br>";
echo $row['Latitude ']."<br>";
echo $row['Longitude'];
}
 
//echo $row[1];
//echo $row[2];
//connect
//ordering the latitude 
$query="SELECT * FROM Position ORDER BY Latitude ASC";
$result=mysql_query($query);

if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
while($row = mysql_fetch_row($result))
{
echo $row['P_ID ']."<br>";
echo $row['Latitude ']."<br>";
echo $row['Longitude'];
}

//echo $row[1];
//echo $row[2];

try like this

rajabhaskar525

Reputation Points: 12

Solved Threads: 27

Junior Poster

Offline

179 posts
since Nov 2009

Permalink

Mar 5th, 2010

Re: Issue with fetch row

haaaa.......you printed only first array.
if you want to display all the rows which is in database then use while loop as banu said above.

muralikalpana

Reputation Points: 21

Solved Threads: 35

Posting Pro

Offline

534 posts
since Sep 2009

Permalink

Mar 5th, 2010

Re: Issue with fetch row

Hi, thanks for your answers. What I want is to be able to select for example the first latitude or the forth latitude (ordered ASC), not necessarily the first one or all of them but a row[x]. Do you understand what I mean? Thank you

pedroteixeira07

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

9 posts
since Feb 2010

Permalink

Mar 5th, 2010

Re: Issue with fetch row

Sounds like you'll need to either add a limit to the query:

PHP Syntax (Toggle Plain Text)

$query="SELECT * FROM Position ORDER BY Latitude ASC LIMIT 4,1";

This will return 1 row, starting with the 4th result returned.

Or, use a while loop as mentioned above and count the results:

PHP Syntax (Toggle Plain Text)
$i=0;
while($row = mysql_fetch_row($result))
{
if ($i==3) 
{
echo $row['P_ID ']."<br>";
echo $row['Latitude ']."<br>";
echo $row['Longitude'];
}
$i++;
}
$i=0;
while($row = mysql_fetch_row($result))
{
if ($i==3) 
{
echo $row['P_ID ']."<br>";
echo $row['Latitude ']."<br>";
echo $row['Longitude'];
}
$i++;
}

The first option is probably a lot more efficient, but both should work.

conord

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

11 posts
since Feb 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: php count

Next Thread in PHP Forum Timeline: Function Return (recursion error?)

DaniWeb Message

Cancel Changes

User Name
Password