Php MySql problem

okay, so i had a file accessing my mysql db and i moved it to a subdirectory, and suddenly it cant query the table….gets no return. i move it back, and it works again…. any idea whats wrong?

i wouldnt have thought that was a sql problem. check through the code see if theres anything directory related?

$con = mysql_connect("localhost","userhere","passhere"); mysql_select_db("db",$con); $result = mysql_query("SELECT * FROM table WHERE item='" . $item . "'"); $row = mysql_fetch_array($result);

okay….so that code is obviously removed all the database info…but i assure you it works, or did in the root dir (public_html), but in the subdir….no dice

hmm :/ ive never had that problem before… does all your mysql stuff have that problem?

nope only in that one subdir. i literally copied this file from root to here…and BAM! problem heres the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/samurain/public_html/place/file.php on line 7

thats just odd. maybe you didnt notice a lil bit of code that was wrong?

yea. but its odd that it would work in one place but not another

fixed yet?

neg…still working at it

does the script have any includes / requires in it?

if so, i'd guess that as you move directories you dont compensate the rinclude/requires locations.

exactly what i was saying lol

nah none…..the only line of code before that is <?php

alright. got it