That would be correct --- it should be extract($sql); in that code.
Like I said earlier (or was it another thread?) I'm going slightly retarded
this afternoon.
Another 30-60 minutes and I'm hitting happy hour for a beer, where the
closest things to a computer screen in the place are the cas
Almost for sure, he meant 'extract' where he put 'expand'...
On Wed, April 25, 2007 4:42 pm, Daniel Brown wrote:
> It looks like it's a combination of what everyone's been
> suggesting.
> Try this rewritten code:
>
> $sql ="SELECT * FROM payment_request WHERE status_code = 'P'";
> $re
On Wed, April 25, 2007 4:15 pm, Dan Shirah wrote:
> I'm sorry, perhaps I confused everyone by including the print_r.
>
> My table has 79 records all with a status_code of 'P' that this
> "should" be
> returning. But instead of all the results returning, all I am getting
> back
> is row 79.
No.
A
Exactly. And I also wanted to make a note that when I included the
print_r($sql_record); in my last post, it was only because I forgot to
delete it.
I'm so ready to get out of here and grab a beer now!
On 4/25/07, Stut <[EMAIL PROTECTED]> wrote:
Dan Shirah wrote:
> Any ideas why my qu
Dan Shirah wrote:
Any ideas why my query only returns the very last record that matches the
criteria specified??
$sql_record ="SELECT * FROM payment_request WHERE status_code = 'P'";
$result_record = mssql_query($sql_record) or die(mssql_error());
if(!empty($result_record)) {
while ($row_recor
It looks like it's a combination of what everyone's been suggesting.
Try this rewritten code:
print_r ($sql_record);
On 4/25/07, Dan Shirah <[EMAIL PROTECTED]> wrote:
No, I am trying to figure out why my query is only returning the last
record that matches instead of all the records that m
No, I am trying to figure out why my query is only returning the last record
that matches instead of all the records that match.
On 4/25/07, Daniel Brown <[EMAIL PROTECTED]> wrote:
Are you trying to just print this to the screen? If so, refer to the
modified snippet I sent you a bit ago.
Are you trying to just print this to the screen? If so, refer to the
modified snippet I sent you a bit ago.
On 4/25/07, Dan Shirah <[EMAIL PROTECTED]> wrote:
I'm sorry, perhaps I confused everyone by including the print_r.
My table has 79 records all with a status_code of 'P' that this "s
I'm sorry, perhaps I confused everyone by including the print_r.
My table has 79 records all with a status_code of 'P' that this "should" be
returning. But instead of all the results returning, all I am getting back
is row 79.
On 4/25/07, Richard Lynch <[EMAIL PROTECTED]> wrote:
On Wed, Apr
Just a first glance, Dan, but try this:
$sql_record ="SELECT * FROM payment_request WHERE status_code = 'P'";
$result_record = mssql_query($sql_record) or die(mssql_error());
if(!empty($result_record)) {
while ($row_record = mssql_fetch_array($result_record)) {
echo $row_record['id'];
2007. 04. 25, szerda keltezéssel 17.03-kor Dan Shirah ezt írta:
> Okay, print_r($result_record) for the query result.
$result_record is a resource identifier. you are not interested in that
too, I think... ;)
if you want all records, then stuff them into an array and use that:
while ($row_record
On Wed, April 25, 2007 3:56 pm, Dan Shirah wrote:
> Any ideas why my query only returns the very last record that matches
> the
> criteria specified??
>
> $sql_record ="SELECT * FROM payment_request WHERE status_code = 'P'";
> $result_record = mssql_query($sql_record) or die(mssql_error());
> if(
Dan Shirah wrote:
Okay, print_r($result_record) for the query result.
But I still don't know why it's only returning the last record of the
query
instead of all the results.
Because it's a cursor and you're not resetting the position. You can't
print the entire result set this way - you ha
Okay, print_r($result_record) for the query result.
But I still don't know why it's only returning the last record of the query
instead of all the results.
On 4/25/07, Zoltán Németh <[EMAIL PROTECTED]> wrote:
2007. 04. 25, szerda keltezéssel 16.56-kor Dan Shirah ezt írta:
> Any ideas why my qu
2007. 04. 25, szerda keltezéssel 16.56-kor Dan Shirah ezt írta:
> Any ideas why my query only returns the very last record that matches the
> criteria specified??
>
> $sql_record ="SELECT * FROM payment_request WHERE status_code = 'P'";
> $result_record = mssql_query($sql_record) or die(mssql_erro
15 matches
Mail list logo
