variables disappear entirely

[XpertWorlock]

The script creates a file, although when it creates it.  the variable changes in the newly created file.

 

$row = (mysql_fetch_array($result));

 

when the file is created, the below is the only thing that shows up.

 

 = (mysql_fetch_array());

 

what could cause this?

 

it goes for all variables in the code, if you need the whole thing, it is below.

 

$Content = ("

<?php

include 'siteLayout.php';

dbConnect();

$result = mysql_query('SELECT * FROM users WHERE userName == '$signUpName' ');

$row = (mysql_fetch_array($result));

if(mysql_num_rows($result)==0){
   echo 'No results';
  };
  

mysql_query('INSERT INTO users (userName, userPassword, userEmail) 
VALUES ('$signUpName', '$signUpPassword', '$signUpEmail')');

echo '<table border='1'><tr><td>
Your account has been activated.<br><br>Please log in.
</td></tr></table>';
?>

\r\n"); 

$handle = fopen($fileName, 'x+'); 
fwrite($handle, $Content); 
fclose($handle); 

[dezkit]

Is that really your code?

[XpertWorlock]

yes, it's a piece of script in a php file that creates another php file (it's isn't the full file, because the rest of the file runs right)

 

dbConnect() creates the connection to the MYSQL database

[unrelenting]

Try:

 

$row = mysql_fetch_array($result);

[XpertWorlock]

nah it didn't work, I had it like that before and that's why I switched it to this, but I had to try again.

 

It confuses me.

[unrelenting]

You also don't need the semi-colon after this line:

if(mysql_num_rows($result)==0){
   echo 'No results';
  };