outputting php file from mysql

[orbitter]

:'( hi there if anyone can help me please, i have a mysql database which stores php files. what i need help with is how to actually output the content of those files randomly in a web browser, can anyone help me pleaseeee??? :'(

 

 

the code for inserting the data in the files is this:

 

<?php

$script1 = "file1.php";

mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script1')");

 

$script2 = "file2.php";

mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script2')");

 

$script3 = "file3.php";

mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script3')");

?>

 

 

 

can anyone help me with the code to actually output the content of these files randomly??

[pocobueno1388]

Try this:

 

<?php

$query = mysql_query("SELECT script_name FROM my_scripts")or die(mysql_error());
$row = mysql_fetch_assoc($query);

//this will add the content (hopefully)
include "{$row['script_name']}";

?>

[orbitter]

thanks for the script, this seems to be outputting just one file. could you show me how to output the content of a randomly selected file???

[pocobueno1388]

<?php

$query = mysql_query("SELECT script_name FROM my_scripts ORDER BY RAND() LIMIT 1")or die(mysql_error());
$row = mysql_fetch_assoc($query);

include "{$row['script_name']}";

?>

[orbitter]

works liek a charm thanksss