What the... PHP and IE incompatible?

[highaspen]

Anybody know why a PHP script that runs fine in Mozilla will not run in IE? I'm just doing a simple MySQL record update.

[Jessica]

There is probably more to it than that. Is IE set to accept cookies?

[highaspen]

Hummm... yeah, I have the privacy setting on low and have the domain set as a site to accept cookies.

[Jessica]

Post the code then. And a link to the site if you don't mind.

[highaspen]

Here is the code that is writing to the DB

----------------------

while($row= mysql_fetch_array($rs) )

{

 

if (!$row['call1']){

$sql6="UPDATE xocai SET call1='$callid' WHERE id='$id'";

$rs6=mysql_query($sql6,$conn)

or die("Could not execute query". mysql_error());

header ("location:../../membersignup3.php?id=$id&org=$org");

exit();

-----------------

 

Site link is: www.remindem.com/mxi Set up a membership (first option) and I'm having trouple on the second page (membersignup3.php)

[Jessica]

There is nothing wrong with the code you've posted. What doesn't work?

Use code tags please.

[highaspen]

sorry really new at php.. what are code tags?

[highaspen]

As far as what doesn't work... it doesn't write to the DB. but doesn't give me an error either, just redirects the the header as if it did write.

[Jessica]

In the forum, the code tags.

Write [.code][./code] around your code, without the .s

 

Try adding this:

$sql6="UPDATE xocai SET call1='$callid' WHERE id='$id'";

print $sql6;

 

See if it is what you think it should be.

[highaspen]

Interesting... it gave me this: UPDATE xocai SET call1='' WHERE id='157'

 

but my code looks like this: $sql6="UPDATE xocai SET call1='$callid' WHERE id='$id'";

[Jessica]

So $callid is not set. Where is it supposed to be set to a value?

[highaspen]

Viewing the source, it is set and is being passed in a hidden field.

[highaspen]

The interesting thing is... Mozilla is fine with it. CRAZY!

[highaspen]

ok I lied... the $callid is being passed in an image...

 

<input type='image' src='images/addreminder.jpg' name='callid' value='59'>

 

maybe IE doesn't like that huh?

[Jessica]

So are you doing $_POST['callid']? You need to access it correctly.

Browsers do not influence PHP, the only thing that they affect is stuff like cookies - not MySQL.

There has to be another problem than the BROWSER. Don't worry about that for now, just look at the errors.

Add this to the top of your pages:

ini_set('display_errors', 1);
error_reporting(E_ALL);

 

Edit: Yeah, IE probably doesn't submit images. Make it a hidden field.

[highaspen]

Okay.. getting somewhere now... I think. Here is what I got.

-------------

 

Notice: Undefined variable: list3 in /var/www/vhosts/remindem.com/httpdocs/mxi/membersignup3.php on line 231

 

Notice: Undefined variable: list4 in /var/www/vhosts/remindem.com/httpdocs/mxi/membersignup3.php on line 261

 

-----------

[Jessica]

Okay, same as before - you need to figure out where these variables you're using are supposed to be coming from.

[highaspen]

Okay I think I know what is going on... I'm querying the DB to see which fields are empty. by doing this:

--------------

$call1 = $row['call1'];

$call2 = $row['call2'];

$call3 = $row['call3'];

$call4 = $row['call4'];

$call5 = $row['call5'];

$call6 = $row['call6'];

$call7 = $row['call7'];

$call8 = $row['call8'];

$call9 = $row['call9'];

$call10 = $row['call10'];

--------------

 

if a field is empty it is saying it is "undefined" right? so I should set a default value in the DB then compaire that? right?