[greymoose]

Hi all,

I've got the following script set up to get the address of the website for advertisers on my site from a MySQL database.

Code:

$advnum = param('advname');	    	

	$dbh = DBI->connect($databaseName, $databaseUser, 
   	$databasePw) || die "Connect failed: $DBI::errstr\n";

#Get style of page for this advertiser
	$stmt = "SELECT advwww FROM advertisers WHERE advnum = ?";

	# Prepare and execute the SQL query
		$sth = $dbh->prepare($stmt) || die "prepare: $stmt: $DBI::errstr";
		$sth->execute($advnum) || die "execute: $stmt: $DBI::errstr";
		$sth->bind_columns( undef, \$advwww);
		$sth->fetchrow();

It works fine in Firefox, Galeon and Konqueror but MSIE doesn't pick up the value from the database. When I get it to print the value of $advwww after this script it comes up empty.

The real life version is here: http://www.martoncentral.co.nz/comp.html (click on the sponsors name).

I'm picking there is some IE bug I'm not aware of (not that I'm discounting mistakes on my part). Can anyone see what I am doing wrong?

Cheers,

Phil

[jfulton]

php is processed on the server and has nothing to do with a user's web browser. Make sure your output is formatted correctly in the page source. There's probably an error in it that IE can't parse, but the other browsers can. Could you post the output? What it's supposed to produce, and what it actually does produce?

[greymoose]

Originally Posted by jfulton

There's probably an error in it that IE can't parse, but the other browsers can.

I followed that line of thought and found that I hadn't allowed for an IE bug in the form sending the data to the script. It works fine now.

Thanks for your excellent insight.

Have a great festive season.