robert_gsfame

haha....actually i missed this part...so just change if(!empty($result)) { echo "<table>"; while($result_array=mysql_fetch_array($result)) with this if(!empty($result_num)) { echo "<table>"; while($result_array=mysql_fetch_array($result)) 1000% WORK!!!

<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydb", $con); $result =mysql_query("SELECT DISTINCT Category FROM Categories"); $result_num=mysql_num_rows($result); if(!empty($result_num)) { echo "<table>"; while($result_array=mysql_fetch_array($result)) { $category=$result_array['Category']; echo "<tr><td style='border-bottom:dashed 1px #000000'>$category</td></tr>"; $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE ID='%s'", mysql_real_escape_string($category))); $check_table2_num=mysql_num_rows($check_table2); if(!empty($check_table2_num)) { while($check_table2_array=mysql_fetch_array($check_table2)) { $title=$check_table2_array['Titles']; echo "<tr><td>$title</td></tr>"; } } } echo "</table>"; } mysql_close($con); ?> just copy and paste above code...let see if it works

<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydb", $con); $result =mysql_query("SELECT DISTINCT Category FROM categories"); $result_num=mysql_num_rows($result); if(!empty($result)) { echo "<table>"; while($result_array=mysql_fetch_array($result)) { $category=$result_array['Category']; echo "<tr><td style='border-bottom:dashed 1px #000000'>$category</td></tr>"; $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE ID='%s'", mysql_real_escape_string($category))); $check_table2_num=mysql_num_rows($check_table2); if(!empty($check_table2_num)) { while($check_table2_array=mysql_fetch_array($check_table2)) { $title=$check_table2_array['Titles']; echo "<tr><td>$title</td></tr>"; } } } echo "</table>"; } mysql_close($con); ?> okay try that code...above, i just make a small change category with Category title with Titles

After you changed this part $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE Category='%s'", with this $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE ID='%s'", and change this part either $title=$check_table2_array['title']; with this $title=$check_table2_array['Titles']; It will work...!!!! 100%

could u please tell us the error being displayed?

i think i got this.... please specify link so that two tables can be connected if i read what you've mentioned before, you might have to do this. try changing this part $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE category='%s'", with this $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE ID='%s'", and let see if it works

<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydb", $con); ================================================= (the way you join two tables seems to be wrong....as category and id cannot be connected) movies: id - title - category - url categories: id - category (FK) $result =mysql_query("SELECT DISTINCT category FROM categories"); $result_num=mysql_num_rows($result); if(!empty($result)) { echo "<table>"; while($result_array=mysql_fetch_array($result)) { $category=$result_array['category']; echo "<tr><td style='border-bottom:dashed 1px #000000'>$category</td></tr>"; $check_table2=mysql_query(sprintf("SELECT * FROM movies WHERE category='%s'", mysql_real_escape_string($category))); $check_table2_num=mysql_num_rows($check_table2); if(!empty($check_table2_num)) { while($check_table2_array=mysql_fetch_array($check_table2)) { $title=$check_table2_array['title']; echo "<tr><td>$title</td></tr>"; } } } echo "</table>"; } well this code is not yet tested, but i think it should work...hope that helps!

really confusing... why dont try this way..let say u use POST method <form action="actionTq.html" method="post"> <input name="email" type="hidden" value="<?php echo $email;?>"> ===> pass the value <input type="submit" value="Request for Action" /> </form> then when submit button is being clicked, then go to actionTq.html use $to=$_POST['email']; $subject="xxx"; $body="xxx"; $header="xxxx"; $header.="Content-type: text/html r\n"; $message="xxxxx"; if(mailto($to,$subject,$message,$header)) { echo "Alright, your message has been successfully sent"; } else { echo "Oops error occured!"; } okay hope that helps

i don't really get, but let see if my explanation is what you need. Based on what you've explained to us, you wish to have this Category 1 --------------- title title Category 2 --------------- title title so why don't you check the what category exists (use DISTINCT in your mysql query) in table categories, loop it and then check what movies match the category and loop it either so in this case still u have to use 2 times looping ..but for sure there are so many ways to get the same results.

I have knowledges in javascript and still learning about AJAX. What i found here that AJAX only do a request to the server and execute particular script asked such as PHP, XML. I didn't find too much code for this , is that what AJAX all about..or i might have missed something?? thx in advance

thx garethp

this question seems so stupid, but i really want to know the best way to write this code. let say i have this code: if(empty($num)) { header("Location:index.php"); } is it okay if i write it down like this? if(empty($num)) { header("Location:index.php"); } i mean there is a whitespace behind header() thx in advance

i have a form <form name=frm1> <input type="checkbox" value="a" name="xxxx"> </form> i wish to get the name of the elements using document.frm1.elements to get the value, i simply use document.frm1.elements[1].value; when i try to use document.frm1.elements[1].name to get the name of the element, i cant get it

i have a chat room where i've created using AJAX n i wonder how can i add a webcam for my chatroom?? Is there anything i mean software to be added or installed?? Any guides?? Thx

i want to use preg_match() to check whether $val consists of a word "male" or not and i wish this way $val="my friend is a female" ---> FALSE $val="both male/female" -----> TRUE

I have this $val="my friend is a female"; how to check whether a word "male" is there or not using preg_match() i wish to get FALSE result for that case and TRUE if i modify a bit into $val="both male/female" thx in advance!

This is actually the problem i have two frames let assume this: 1st frame is for name.php which is consist of name of a person 2nd frame is detail.php which will display the detail of each chosen person so when u click on the name, 2nd frame will display the detail. I have something like favorite tag on the 2nd frame, so when they want to easily tag particular name to be easily memorized, they could just give a tag by clicking on the "favorite tag" button. When they click on it, i use header() and redirect them to another page to UPDATE the record and redirect them back to detail.php What i really want is to give some small flag symbol before each name if being "tagged" on name.php that is why i do refresh every second... . seems to be very easy if not doing it in frames

problem still exists even when i have closed the connection using mysql_close() actually i have 2 frames and when i update the second frame, i wish to display the updated one in the first frame either, that's why i update the 1st frame every second don't have any idea on how to refresh the first frame from the second frame.. please give me some guides. thx

will refresh a page every second will cause some crash or error ?? cause when i try this, it sometimes display this error "Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL " this is occur when i run it in my local server. I am so worried if this might also happen when i run it online. thx

still not working when i try to put echo rand(0,9) in page21.php and i cannot get the result yet of each <div>

Below is the script function refreshflag() { var totalx=document.getElementById("totaluser").value; var spx=totalx.split(";"); if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp=new XMLHttpRequest(); } else {// code for IE6, IE5 xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } for(i=0;i<spx.length;i++) { var parameters="em="+spx; xmlhttp.open("POST","refresh_flag.php",true); xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded") xmlhttp.onreadystatechange=function() { if(xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById("ref"+spx).innerHTML=xmlhttp.responseText; } } xmlhttp.send(parameters) } setTimeout("refreshflag()", 1000); The problem is that in refresh_flag.php, when i cannot get the result which is $_POST['em'] displayed as document.getElementById("ref"+spx).innerHTML) although in refresh_flag.php, i put this echo $_POST['em']; as if $_POST didn't pass the value thx for any help

I am new to ajax n i have problem in reloading multiple elements so let say i have this var textbox="aaaa;bbbb;cccc;dddd"; and in my page i also have <div id="aaaa"></div> <div id="bbbb"></div> <div id="ccccc"></div> how can i reload each element every 1 second.. i can only do this with single element need some clue or small code thx

dont really get it..okay i have modified certain script function refreshflag() { var x=0; if(x!=1) { setInterval(checkit(),1000); } } function checkit() { var totalx=document.getElementById("totaluser").value; var spx=totalx.split(";"); for(i=0;i<spx.length;i++) { counter(spx); } } function counter(x){ if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } var parameters="em="+x; xmlhttp.open("POST","refresh_flag.php",true); xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded") xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById(x).innerHTML=xmlhttp.responseText; } } //xmlhttp.send(parameters) alert(parameters); } and in refresh_flag.php <?php echo rand(0,9);?>

this is what i did so far to refresh page using ajax periodically function refreshflag() { var x=0; if(x!=1) { setInterval(checkit(),100); } } function checkit() { var totalx=document.getElementById("totaluser").value; var spx=totalx.split(";"); for(i=0;i<spx.length;i++) { counter(spx); } } function counter(x){ if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } var parameters="?em="+x; xmlhttp.open("POST","refresh_flag.php",true); xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded") xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { document.getElementById(x).innerHTML=xmlhttp.responseText; } } //xmlhttp.send(parameters) alert(parameters); } and in refresh_flag.php <?php echo rand(0,9);?> the problem is that when i user alert i have the looping correctly but when i tried to get the responseText, i didn't get any result for each x. assuming that the document.getElementById("totaluser").value="Ronan;Dean;Jay" thanks for any helps

How can i pass value to parent window? Let say page1.php <input type="button" value="open window" onclick="javascript:window.open('page2.php')"> <div id="test"></div> page2.php <input type="button" value="close window" onclick="passvalue('HELLO WORLD')"> so what should be written in function passvalue() so that the words "HELLO WORLD" shown up in <div id="test"></div>?? what i've tried so far in confusion and not working is this function passvalue(x) { window.parent.document.getElementById("test").innerHTML=x; window.close(); } thx for any help