Problem with script! HELP!!!

loureiro

Hello,

I am currently having a problem with a specific area of my script...on the edit customers page there seems to be a problem after I select a user to edit...it use to get all the details but now it is messing up. Can someone take a look at my code and help me out please!

LordShryku

Well, maybe if you explain what "messing up" means. Like an error or what it's doing or something. Then, after you've narrowed it down to a certain page, or hopefully just a portion of that page, post that. Don't expect us to sift through your entire web directory.

loureiro

the problem is on line 92 in the edit.php file...it doesnt run the query properly on my household table. here is what the php error log shows for this:

[07-Sep-2004 21:05:43] PHP Warning: mysql_query(): 7 is not a valid MySQL-Link resource in C:\apache2triad\htdocs\php_functions\edit.php on line 92

loureiro

also if anyone can help me out with fixing my clear button on the editCustomers page that would be awesome...it wont delete maybe cause there are default values in there...i dont know! please help!

loureiro

can anyone help please?

loureiro

ok i did some more analysis on the problem and here is what I came up with...it is a problem with my connection...it appears to be fine but it says:

PHP Warning: mysql_query(): 14 is not a valid MySQL-Link resource in C:\apache2triad\htdocs\php_functions\edit.php on line 89

it says resource #14 both when i create it and just before i run the command but as soon as i do that then it screws up and wont let me make the query.

anyone know whats going on? has anyone had this problem?

loureiro

i changed it to a persistent connect and it worked. does a regular connection only exist for 3 queries? cause thats whats happend to me...is there a way to change this? does anyone know?