Simple PHP config problem.

Jack99uk

Hi all,

I have what I beleive to be an 'easy to fix' problem:

Having re-installed PHP on our dev server, some code that worked before now, does not work:

$result = mysql_query("SELECT * FROM films WHERE uni = $uni");

This returns the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/web/warner/php/filmadmin/editfilm.php on line 4

Now, if I put a value in for the variable, as below, the error goes:

$result = mysql_query("SELECT * FROM films WHERE uni = 106);

So, I'm thinking that theres something in the PHP config file that can be changed, to change the way PHP accepts variables..

Can anyone help? :-)

SOL-ion

As a quick fix try this

$result = mysql_query("SELECT * FROM films WHERE uni = ".$uni.");

There is way of making PHP concatenate strings automatically, but I can't remember how to do it of the top of my head.

Hope that helps

SOL

Jack99uk

Thanks for your reply Sol -

The problem is, I dont want to change the code, because i'll have to go through all the pages and change them.

It'd be a lot easier for me to change the PHP config, if anyone can remember/knows the fix! 😛

JAck

Weedpacket

You probably mean register_globals, but it was turned off by default for a reason.

Jack99uk

Ah, any idea why it would have been turned off by default?

ame12

It was turned off for security reasons - it's easy for someone to change key variables using crafted URL's. If you search google on register_globals security you'll get a bunch of threads on this topic...

===================================================
BadBlue: tiny personal web server for PHP & Windows

down.htm

Jack99uk

Aaah, thank you very much :-)