All of a sudden, I can't address my passed variables

[judi]

I was working on a script yesterday, when all of a sudden I had problems with a script I hadn't changed in days. I begin displaying categories and that works fine. Then when I go to display the details, I get the following message: Warning: mysql_result(): supplied argument is not a valid MySQL result resource in c:\phpdev\

http://www\show_lights.php

on line 129. That wasn't the script I was working on. Here is what I did:

1 - I downloaded the production versions of the scripts in question and it still doesn't work even though the same scrips work in production.
2 - The same problem occurs whether I hit the production database of the test database.
3 - I deleted, then reinstalled my apache, PHP and MySQL

The previous script is passing the variables just fine. Here is the URl for the script it bombed in:

http://localhost/show_lights.php?catname=Low Voltage<BR>Path Lights&catid=3

But I cant address either catname or catid. BTW, there are two possible programs the display categories can go to and the error occurs in both.

I also ran a chkdsk last night and it didn't help.

Oh and it reacted the same whether I had my register_globals on or off. I did try $id = $_GET['id']; as well as just addressing the variable as $catid.

Any other ideas?

 

[Chacalinc]

$id = $_GET['id']?
$catid?

should not it be $catid = $_GET['catid']?
but you have &quot;catname&quot; in

http://localhost/show_lights.php?catname=Low Voltage&...

did you try $catname=$_GET['catname'] ?

could you post the code with problems?

 

[sleipnir214]

I'm pretty certain reloading Apache, PHP, and MySQL was unnecessary.

But after doing so, what error message are you getting?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!