Problem with Temporary Tables

[latemodern]

Hi There,

 

I am trying to use a temporary table but it doesn't appear to be working.

 

//create the temporary table

 

$temp = "CREATE TEMPORARY TABLE temp (

id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,

user_id SMALLINT UNSIGNED NOT NULL,

name VARCHAR(50) NOT NULL,

gender VARCHAR (10) NOT NULL,

photo_file VARCHAR(30),

minbeds SMALLINT(6) NOT NULL,

maxbeds SMALLINT(6) NOT NULL,

minrent SMALLINT(6) NOT NULL,

maxrent SMALLINT(6) NOT NULL,

smoker VARCHAR(20),

smokingmix VARCHAR(20),

studentmix VARCHAR(20),

minage SMALLINT(6) NOT NULL,

maxage SMALLINT(6) NOT NULL,

email VARCHAR(50),

phone VARCHAR(20),

description TEXT,

stu VARCHAR(20),

gend VARCHAR(20),

comp_score SMALLINT,

PRIMARY KEY (id)

)";

 

if($tempresult = mysql_query($temp)){

echo 'Result';

}else{

echo mysql_error(). $temp;

}

 

 

//Insert temporary values

 

$temp_insert = "INSERT INTO temp (user_id, name, age, gender, photo_file, minbeds, maxbeds, minrent, maxrent,

smoker, smokingmix, studentmix, minage, maxage, email, phone, description, stu, gend, comp_score)

VALUES ('$user_id', '$name', $age, '$gender', '$photo_file', $minbeds, $maxbeds, $minrent,

$maxrent, '$smoker', '$smokingmix', '$studentmix', $minage, $maxage, '$email', '$phone', '$description',

'$stu', '$gend', $comp_score)";

 

 

//not sure if i need this bit

 

$temp_insert_result = mysql_query($temp_insert);

 

//then test whether there was a result

 

$megaquery = "SELECT name FROM temp";

if($megaresult = mysql_query($megaquery)){

echo $megaquery;

while($megarow = mysql_fetch_array($megaresult, MYSQL_ASSOC)){

echo '<p>'

.$megarow['name'].

'</p>';

}

} else {

echo mysql_error();

echo $megaquery;

}

 

I get the following text on the page (as you would expect) but nothing else. Have the queries worked? I was expecting to get a list of names. The variable values that I am trying to insert into the table aren't empty and they appear if I echo them before I try to insert them in the temporary tabel

 

Am I doing something wrong?

 

Thanks a lot

 

Chris