[SOLVED] get 2 rows of data separately

[simon551]

Hi. I need to be able to pull out two rows of data from my query and then manipulate that data separately in a page. I would like to do something like this:

<?php 
mysql_select_db($database_conn_org, $conn_org);
$query="SELECT etDetId FROM et_details ";
$rs = mysql_query($query, $conn_org) or die(mysql_error());
$row = mysql_fetch_array($rs);
$totalRows = mysql_num_rows($rs);
while ($row < $totalRows) {
//transaction information
$id1= $row[0]['etDetId'];
$id2= $row[1]['etDetId'];
}
echo $id1.'<br />'.$id2;

I'm not really sure what I'm doing with the array in the $row[0]['etDetId'], that was a total guess and it didn't work. The query I'm using will return a maximum of 2 rows but could just be one. Let me know if I'm not explaining my problem well. Thanks in advance.

[ldougherty]

I'm not sure I understand your question but here is an example of how you would loop through the results of a query.

 

$result=mysql_query("SELECT * FROM mytable");

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

  $name = $row[name];

  $email = $row;

  echo "name is $name and email is $email<br>";

}

 

This assumes you have fields for name and email and would assign a value and output each through the loop until it reaches the end of the database.

[simon551]

No. I understand that part. I'm trying to modify it to accomplish something else. I actually need to have a variable $id2 that I can use somewhere on the page outside of the <?php while ?> loop.

[ldougherty]

If you assign the variable inside the while loop you can use it anywhere on the page inside the PHP tags, or inside HTML by opening the php tag as <? echo $name ?>

[simon551]

$result=mysql_query("SELECT * FROM mytable");

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

  $name = $row[name];

  $email = $row;

  echo "name is $name and email is $email<br>";

}

I got you that I can echo $name anywhere on the page. But how do I echo (exactly) the second name in 'myTable'?

[ldougherty]

http://us2.php.net/manual/en/function.mysql-fetch-row.php

 

You can use mysql_fetch_row to return a single row instead of an array.  This is a good way to pull out individual values from the database.

 

The other option would be to use mysql_fetch_array and then reference the array object.  For example assume you return 10 items in the array and you want item 2 and 3 you would reference them as $name[2]  and $name[3]

[simon551]

 

The other option would be to use mysql_fetch_array and then reference the array object.  For example assume you return 10 items in the array and you want item 2 and 3 you would reference them as $name[2]  and $name[3]

That's what I'm trying to do.

[simon551]

This returns

0

8

but I'm expecting it to return, according to my database records

10856

10857

<?php 
mysql_select_db($database_conn_org, $conn_org);
$query="SELECT etDetId FROM et_details WHERE etmId=3865";
$rs = mysql_query($query, $conn_org) or die(mysql_error());
$row = mysql_fetch_array($rs);
$totalRows = mysql_num_rows($rs);
while ($row = mysql_fetch_array($rs)) {
//transaction information
$id= $row['etDetId'];
}
echo $id[1].'<br />'.$id[2];

[pkedpker]

yah i know what you are trying to do access data outside loops then you have to store it somewhere.. I'd use sessions or globals for this

 

<?php
function blahblah() {
global $id;
while(some shit) {
$id[0] = "hommie";
$id[1] = "some shit i dont know";
}
echo $id[0];
?>

[simon551]

figured it out.

<?php

mysql_select_db($database_conn_org, $conn_org);
$query="SELECT etDetId FROM et_details WHERE etmId=3865";
$rs = mysql_query($query, $conn_org) or die(mysql_error());
$totalRows = mysql_num_rows($rs);
$i=0;
while ($row = mysql_fetch_array($rs)) {
$i++;
//transaction information
$id[$i]= $row['etDetId'];
}
echo $id[1].'<br />'.$id[2];

[pkedpker]

ooooo u wanted to do i like that.. then use foreach()

 

<?php colors
  foreach($arr as $key => $value){
           $id[$key] = $value;
   }   
?>