<?php $db = mysql_connect("localhost","abuguet","CambiamE!!"); mysql_select_db("abuguet"); mysql_set_charset('utf8',$db); ?> <!DOCTYPE html> <html> <head> <title>Generador de Episodios de la Rosa de Guadalupe</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <style type="text/css"> *{margin: 0; padding: 0;} body{ background-image: url(bluebg.png); font-size: .625em; font-family: "Trebuchet MS", sans-serif; } #wrapper{ width:460px; margin: 0 auto; } #header{ display: block; background-image: url(proximoepisodio.png); height: 147px; } #header span{ display: none; } #episodio{ border-radius: 5px; border: 1px solid #757d83; box-shadow: 0 2px 0 #bdd7e6; font-size: 1.8em; color: #000; background-image: url(whitebg.png); } #episodio p{ margin: 10px; } #refresh{ font-size: 1.4em; color: #6a8294; text-shadow: 0 1px 0 #c0d7e5; text-align: center; margin-top: 10px; } </style> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-20018878-2']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> </head> <body> <div id="wrapper"> <a href="/" id="header"><span>En el proximo episodio de la rosa de guadalupe</span></a> <div id="episodio"><p> <?php $nombre = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'nombre' order by rand() limit 1"))or die(mysql_error()); $causa = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'causa' order by rand() limit 1")); $tema = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'tema' order by rand() limit 1")); $efecto = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'efecto' order by rand() limit 1")); $familiar = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'familiar' order by rand() limit 1")); printf("<strong>%s</strong> Hizo <strong>%s</strong> porque su <strong>%s</strong> <strong>%s</strong>. La tratan de matar, se da cuenta que <strong>%s</strong> es <strong>%s</strong>, y la virgencita le ayuda a sobresalir.", $nombre[1], $tema[1], $familiar[1], $causa[1], $tema[1], $efecto[1]); ?> </p></div> <div id="refresh">Refresca para más</a> </div> </body> </html>