Recent content by queryguy

$pq="pmid, count(*) from cmp group by pmid"; $pqresult = mysql_query ($pq); while($pqlist = mysql_fetch_array($pqresult)) { echo "$pqlist[]pmid]"; } hmm.. I got no results display, any helps?

This code will count the numbers of rows each name have and add up. $pqfinal=0 $pq="select * from cmp where cid='$cid'"; $pqresult = mysql_query ($pq); while($pqlist = mysql_fetch_array($pqresult)) { $q="select * from cmp where pid='$pqlist[pmid]'"; $results = mysql_query...

Any helps?

this error will only occurs when I entered 2 keywords to search, with one keyword, it display results without problems.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR items LIKE '%%' and listid LIKE '%1%' and listed LIKE '1 this is all it displayed

$terms = explode(&quot; &quot;, $_GET[&quot;items&quot;]); $query = &quot;SELECT * FROM warehouse WHERE&quot;; $numterms = count($terms); for($b = 0; $b < $numterms; $b++) { $terms[$b] = trim($terms[$b]); if($b > 0) { $query .= &quot; OR&quot;; } $query .= &quot; items LIKE '%&quot...

thanks please keep me update

Hi experts, is there a way to update my database upon closing the browser without any popup window? For example like a chat room, when you close the browser it update the database and let other know you have left the chat room. I tried onunload but it doesn't seem to work... maybe the closing...

I don't understand what is this? $cltdescr=$row&quot;cltdescr&quot;; What is $cltdescr you are referring to?

=ohh.. so I have to insert the line? $query=&quot;SELECT * from clienttypetable order by cltdescr&quot;; $rsclt=mysql_query($query,$conn); $list = mysql_num_rows($rsclt); while($i < $list) { $row = mysql_fetch_array($rsclt); $cltid=$row[&quot;cltid&quot;]...

thanks for the reply but on the form field should I change anything? or remain the same? <input type=&quot;checkbox&quot; name=&quot;book[]&quot; value=&quot;love&quot;> <input type=&quot;checkbox&quot; name=&quot;book[]&quot; value=&quot;business&quot;> <input type=&quot;checkbox&quot...

so which script language can do server side commands ? But how about those java applet script? like a java applet chat room, when the user left (Close the browser) it can update? How they do it?

Hi experts, is there a way to update my database upon closing the browser without any popup window? For example like a chat room, when you close the browser it update the database and let other know you have left the chat room. I tried onunload but it doesn't seem to work... maybe the closing...

Hello, How can display the list of checked checkbox according to database value? So when the uses want to edit the info, he/she knows that which are the one already being check. ok this is my form <form action=&quot;submit.php&quot; method=&quot;post&quot;> <input type=&quot;checkbox&quot...

Oh now it works, because my ip changed. Sorry for the trouble and thanks for the help.