show options
Reply | Reply to Author | Forward | Print | View Thread | Show original
| Remove | Report Abuse | Find messages by this author
what wrong with my script?
<?php
require("connec t.php");
require("Sajax. php");
function show_mysql() {
// mysql query
$display="SELEC T * FROM Movies ORDER BY id";
$mysql_result=m ysql_query($dis play);
while ($row=mysql_fet ch_array($mysql _result))
{
$id=$row["id"];
$Name=$row["Name"];
$Link=$row["Link"];
$Description=$r ow["Descriptio n"];
$Image=$row["Image"];
$Type=$row["Type"];
$ang_rate=$row["ang_rate"];
return print"<table align=\"center\ ">
<tr>
<td><div align=\"center\ ">
<table width=\"376\" background=\"/images/bg.jpg\" align=\"center\ ">
<tr>
<td width=\"98\" rowspan=\"0\">< img src=\"$Image\" width=\"65\"
height=\"65\">< br><span class=\"style3\ ">$Name</span></td>
<td height=\"91\" colspan=\"3\">< span
class=\"style1\ ">$Descript ion</span></td></tr>
<tr>
<td width=\"130\">< div align=\"left\"> <a
href=\"play_mov ie.php?row_id=$ id\"><span class=\"style1\ ">Play
Game</span></a></div><div align=\"left\"> <a
href=\"comment. php?row_id=$id\ "><span class=\"style1\ ">Add
Comment</span></a></div></td>
<td width=\"264\">< form action=\"rating .php\" method=\"GET\">
<input type=\"hidden\" value=\"$id\" name=\"id\">
<select
name=\"rating\" >
<option
selected>Rate Movie</option>
<option
value=\"1\">1</option>
<option
value=\"2\">2</option>
<option
value=\"3\">3</option>
<option
value=\"4\">4</option>
<option
value=\"5\">5</option>
<option
value=\"6\">6</option>
<option
value=\"7\">7</option>
<option
value=\"8\">8</option>
<option
value=\"9\">9</option>
<option
value=\"10\">10 </option>
</select>
<input type=\"submit\"
value=\"Go\">
</form></td>
<td width=\"0\" height=\"28\">< div align=\"center\ "><span
class=\"style1\ ">Rating: $ang_rate</span></div></td></tr>
</table></div></div></td></tr></table>";
}
}
//starting SAJAX stuff
$sajax_request_ type = "POST";
sajax_init();
sajax_export("s how_mysql");
sajax_handle_cl ient_request();
?>
<html>
<head>
<title>MySiteSu cks Movies</title>
<script>
<?
sajax_show_java script();
?>
function show_me(date_se rver) {
document.getEle mentById("date_ div").innerHTM L =
date_server;
}
function mysql_display() {
//put the return of php's show_now func
//to the javascript show_me func as a parameter
x_show_mysql(sh ow_me);
}
</script>
</head>
<body onLoad="mysql_d isplay();">
<table id="date_div">L oading....</table>
</body>
</html>