retrieving records for manipulation

[Anon]

This probem has been driving me bonkers for days.....

Rather that use ODBC_RESULT_ALL I wanted to be able to do something with my retrieved records so I wrote a bit of code to print each record field by field, then line by line.

The problem is I can't see a way to refer to each variable ($col2 in this case) uniquely when they are passed as variables to a php program - is anything like this possble?

I just can't think of any way to do this.

while (odbc_fetch_row($result))
{
// Get first column
$col1 = odbc_result($result,1);

// Print contents of first field
echo ("$col1 \n");

// Get second column
$col2 = odbc_result($result,2);

// Print contents of second field as a link
echo "<a href=\"call a php program with variables\"> $col2 </a> <BR>";

}

Thanks

Chris

[craigh]

yeah - I was trying to do a similar thing yesterday and failed. I started with trying to make my $col1 an array so I did something like:
$x=0

while...

$col1($x) = odbc_result($result,1);

$x++

}

see where I'm going with that? Anyway, I didn't get it to work (but, admittedly I was not patient enough to keep working on it).

If you can get something like that to work for you, I would liove to know!

[jc94062]

... to do but see if this helps.

$name=mysql_query("SELECT anything FROM table WHERE something='$variable'",$db);
while($rows=mysql_fetch_array($name)) {
$variable_to_set = $rows["row_from_table_to_assign_variable_to"];
}

[Anon]

try this,

print "<a href=$PHP_SELF/?COL=$col2>$col2</a>";

So in the same PHP script, you would do something like:

if ($COL) {
...

}

[Anon]

Thanks all,

I think Tigers answer is along the right lines for me. I'm using MSSQL 2000 as my back end database - unfortunatly, this means I can only connect via the ODBC functions, and they seem more limited than the native equivalents.

I really want to get multiple rows in my result and have a way to access them. Tigers solution would only work if I was returning one row.

[Anon]

sir i have problems with my password.some body has changed my password for [e-mail] send me the password to this id [e-mail] as i have so many important messagesa in that ,i tried several ways,
please sir.]

thank you.

[Anon]

I used this for Oracle DB backend, and this solution works for one or mutiple rows. I dont know much about PHP ODBC so I cant be for sure, but I can not see any different, the solution works regardless you are retrieving 1 or more records.

[Anon]

I've implemented your suggestion and it's tantalizingly close to my requirements.

The only problem I now have is the appearance of the link within my generated table. If the user clicks the link, the php program calls itself again with incorrect variables - did you manage to suppress the link somehow?

Thanks for getting me this close - I don't know why I missed this idea, must be getting code blind🙂

Chris

[Anon]

I've managed to do this now with hidden fields/arrays.....

I wanted to validate the hidden field (which is displayed as well) against an inputted field - in order to do so I had to dynamically create the field name for both (because I had many similar rows)

Here are the two lines: -

echo ("<input name=outstandqty[$arrayindex] type=hidden value=$col6>");

echo ("<td><input name=orderqty[$arrayindex] type=text size=11>\n</td>");

Hope this helps

Chris

[Anon]

To tell the truth, I was looking doing the same thing a different way, I was trying to have a submit button next to each record, this did not get me far. Your question remind me of the easier way, which works very well for me. Thanks to you. In mycase, when the link is clicked, the value ($COL) is passed to the same script, the script checks if ($COL) defined then I know that the link is clicked so I can then use the value of $COL to do another query and display a another form. I use this to allow user to update that particular record.

I am not too sure what is your problem, can you give more info?

I have not tried this but I think you can pass more variable to the script by appending ?para1=value1?para2=value2 etc

[Anon]

dear sir,
my name is priya.i have an id in yahoo i.e
[e-mail] password was mruna.i am an indian.some body has changed my password.they have changed mydetails in that.i want to know the password as i have so many mails in that regarding my career .
kindly try this for me and send the password to this mail id [e-mail].
i will be grateful to you for this favour.
thank you very much.

[Anon]

Tiger,

I've managed to sort it now thanks.
I used a hidden field (which is also displayed so the user can see how much stock they have available), and a regular input field:-

echo ("<input name=outstandqty[$arrayindex] type=hidden value=$col6>");

echo ("<td><input name=orderqty[$arrayindex] type=text size=11>\n</td>");

using arrays (I think) it will generate multiple fields in the html. E.g I can compare outstandqty[1] to orderqty[1] etc.

Thanks

Chris