lost array information?

the host it's erroring on:
PHP4 scripting (version 4.3.3 currently)
current MySQL version is: 4.0.16-standard

host it works perfectly on:
php 4.2.2
mysql 3.23.58

two questions...

Is the mysql_query() call for $frmsginf erroring?
Is $msginf being populated?

i thought about those. kept inserting
echo "debgug:variable: $variable...mysql error: '.mysql_errno($db).': '.mysql_error($db).'';
and adding any new variables and then getting any error info and moving it down.
once i got below $msginf i didn't get anything for that on the deployment server, but i didn't get any errors either.
i double checked the feild names. i know the feilds are correct. i double checked the fact the information is there. the EXACT same query in the mysql command line interface gets results.

i'm thinking there's something i don't know about the sql set up causing it not to return the information

So is it the mysql_query() or mysql_fetch_array() that's not returning a value?

Here's a question... do you have any PHP scripts that are successfully querying the DB? If not, I'd look into the configure settings for php.

It could be a simple problem with the upload of the script via FTP. If it was loaded as binary instead of ascii, you can get some weirdness sometimes.

You might also do a phpinfo() on both machines to see if any of the php.ini setup variables are different that might be causing problems as Mark has mentioned.

pretty much all my scripts query the db. i think there's only one that doesn't, but that actually calls a function in an include that does. everything else looks to be functinong fine (only mail hasn't been tested on the deployment server as of now). the error checking returns no errors from either the query or the fetch call. the query through the command line works. so my gut feeling is that it is the fetch array call.

there are a number of other calls tot he batabase in that script, including querys, and fetch arrays and even a num rows, all of which work correctly.

changing the line
$msginf=mysql_fetch_array($frmsginf);
to
$msginf=mysql_fetch_array($frmsginf);
foreach($msginf as $key=>$value){ echo "key: $key ---> value: $value"; }
gets the error:
Warning: Invalid argument supplied for foreach() in /home/dcfydllc/www/message.php on line 33
which tells me that there's an issue with the mysql_fetch_array call.

Out of curiosity, does mysql_fetch_assoc() work in place of mysql_fetch_array()?

didn't try that. let me go switch it out.

nope. no difference. the array is not being poulated.

i don'tknow it having the entire script might help, here it is without debugging lines (and with mark's suggesstion)

Have you printed out the query for $frmsginf? Just to make sure that it is what you expect it to be.

well... here's with debugging lines...

Quote: sql: SELECT message,from_un,from_id,UNIX_TIMESTAMP(sent) FROM msgs WHERE msg_id='1' AND to_id='47';
frmsginf: Resource id #10
error: 0:
msginf
error: 0:

figured it out whe i looked at something. whenn i typed it into the command line, i was typing it over, not cutting and pasting. i noticed i kept flipping something so the uid was mine and not sammys. the reason it worked on the dev server is that i was testing by sendning to myself. i have the to and from id dlipped. by using uid and not toid in the call, it works.

as you can see, this is the corrected version if you'd like to see. it's actually so simple and i was just so close to the code i kept missing it. i mised it for about 36 hours before posting it and saw it as i copied over the text into the command line jsut now.

The simplest mistakes cause the biggest headaches.

yeah. this is why i like to work with a partner. simple things that go unnoticed because you're too close will often be caught by the partenre, thus saving you the headache.