problem with php mysql iis

[Vjeran]

Hi
I have one page: index.php - news portal - with headlines, every headline is
a link to whole news , and the code is like this:
....
$news_id=$row["news_id"];
echo "<a href='news.php?news_id=$news_id'>
....

the other page -news.php- that shows that news looks like this:
....
<?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
.....

and this works fine on the Internet (PHP/MySQL/Apache)
but locally, I tried the same thing, and it doesn't work - but on
PHP/MySQL/IIS

it seems like it doesn't bring $news_id to sql query... is this a IIS
problem or what?

thanks for any help
Vyeran

[iulian.ilea]

Vjeran wrote:

Hi
I have one page: index.php - news portal - with headlines, every headline is
a link to whole news , and the code is like this:
...
$news_id=$row["news_id"];
echo "<a href='news.php?news_id=$news_id'>
...

the other page -news.php- that shows that news looks like this:
...
<?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
....

and this works fine on the Internet (PHP/MySQL/Apache)
but locally, I tried the same thing, and it doesn't work - but on
PHP/MySQL/IIS

it seems like it doesn't bring $news_id to sql query... is this a IIS
problem or what?

thanks for any help
Vyeran

What is the error?

[Johnny]

"Vjeran" <vp******@MAKNIfoi.hrwrote in message
news:eg**********@ss408.t-com.hr...

Hi
I have one page: index.php - news portal - with headlines, every headline

is

a link to whole news , and the code is like this:
...
$news_id=$row["news_id"];
echo "<a href='news.php?news_id=$news_id'>
...

the other page -news.php- that shows that news looks like this:
...
<?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
....

and this works fine on the Internet (PHP/MySQL/Apache)
but locally, I tried the same thing, and it doesn't work - but on
PHP/MySQL/IIS

it seems like it doesn't bring $news_id to sql query... is this a IIS
problem or what?

thanks for any help
Vyeran

perhaps: relying on register globals to get $news_id in place of
$news_id = $_GET['news_id']

[Pedro Graca]

["Followup-To:" header set to comp.lang.php.]
Vjeran wrote:

<?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
....

It appears you have register_globals on.
http://php.net/register_globals

*Turn it off!*

And change your code to:

<?php
$result = mysql_query("select * from news WHERE news_id='".$_GET['news_id']."'") or die (mysql_error());
...
Happy Coding :)
--
File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot

[Vjeran]

thank you Pedro and Johnny, it's working now...

"Pedro Graca" <he****@dodgeit.comwrote in message
news:sl*******************@ID-203069.user.individual.net...

["Followup-To:" header set to comp.lang.php.]
Vjeran wrote:

><?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
....

It appears you have register_globals on.
http://php.net/register_globals

*Turn it off!*

And change your code to:

<?php
$result = mysql_query("select * from news WHERE
news_id='".$_GET['news_id']."'") or die (mysql_error());
...
Happy Coding :)
--
File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot

[Colin Fine]

Vjeran wrote:

thank you Pedro and Johnny, it's working now...

"Pedro Graca" <he****@dodgeit.comwrote in message
news:sl*******************@ID-203069.user.individual.net...

>["Followup-To:" header set to comp.lang.php.]
Vjeran wrote:

>><?php
$result = mysql_query("select * from news WHERE
news_id='$news_id'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
....

It appears you have register_globals on.
http://php.net/register_globals

*Turn it off!*

And change your code to:

<?php
$result = mysql_query("select * from news WHERE
news_id='".$_GET['news_id']."'") or die (mysql_error());
...
Happy Coding :)
--
File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot

.... but as I said to somebody else,

"doesn't work" doesn't tell us anything!

Colin