URL Variables

payjo

Hey guys, I'm using url variables to pass from one page to the next. For some reason it's not working right now. Any suggestions on what's wrong with it? I'm using Apache 2, with php 4.2.3 on RH. Thanks!!!

dcjones

can you show some of your script, it would help

DCJ

payjo

Sorry,

http://olie.ucdavis.edu/migration/article.php?id=20&issue=2&p=0

When I write this on article.php:
echo "id = $id";

Nothing comes up.

dcjones

I do think that if we are to try and help you we will need more code

Code from your calling script and code from your called script

DCJ

payjo

I dont know if I understand you correctly...but here's the code from the scripts that calls it. It is in index.php:

echo "<p class=\"title\"><a href=\"article.php?id=$articleID&issue=$latestIssue&p=$past\">".$row["title"]."</a><br>\n";

Where title is just a text.
id = int
issue = int
p = bool

Inside article.php, I'm trying to run a query:
$query = "SELECT section, title, article_text, source
FROM ARTICLE
WHERE article_id = $id";

This query doesn't work since $id is undefined. Hope this is what your asking for.

dcjones

Looking at what you have given the only thkng I can see is

Your Script:

$query = "SELECT section, title, article_text, source
FROM ARTICLE
WHERE article_id = $id";

My correction '$id'

$query = "SELECT section, title, article_text, source
FROM ARTICLE
WHERE article_id = '$id'";

try that

DCJ

leatherback

Hi,

Maybe you have named the variable correctly, or.. check your caps/names:

In the url:
a href=\"article.php?id=$articleID
In the tablequery: WHERE article_id = $id";

Is that correct: you use different var name then the table colum?

Else: Does the ID come up in the pagelink itself? (If you look at the url it creates, is there a values in the url for $id ?)

Then in the querystring: Is there a value?

payjo

Great point, dcjones, but this script worked just fine til I had to scratch the box and reinstall everything. In addition, I have

echo "$id";

And still nothing shows up. Is there something in the php.inc file that I need to configure?

Edit: Sorry I didn't read the last post in time. Yes there is a value on the link.

dcjones

Does this show an error or just no data

DCJ

payjo

no data

leatherback

Hi,

Could you perhaps paste the echo $query
here?

But if the link used to work, and you did not change the tables / structure.. Then it is odd, and I am not sure what it could be!.

BuzzLY

If you had to reinstall "everything" meaning Apache and PHP, PHP now defaults to having register_globals turned OFF (as of version 4.2, I believe). Edit your php.ini file and turn it on, and you should be able to see your data.

If this is not an option, change your code to use $_GET["id"]

Hope that helps.

payjo

BuzzLY, you saved the day. I knew it was something in the php.inc file. Thanks!!!

BuzzLY

excellent. Glad I could help! That will be 3 RKTs, please... 😃