Webmaster Forum / PHP / Database Access / June 2003

so...  there's a php script with this sql query in it...
SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id IN
($matching_userids)
what does the IN part of the query do?  trying to look for it on

I have a question about counting arrays in a mysql query :
How to sort the sql reply by the number of matching arrays ?
for example :
SELECT uid, COUNT(*) GROUP BY uid -> will give me :

i have a page that have links that load a category in this form
www.mysite.com/index.php?cats=xxx
where xxx is the number and it can go from 0 to 500000 or even more.
so how can i validate the number just in case someone inputs some letters or

How I can select the bigest unigue rekord named ID from table? I write this
code but this is very slow:
==================================================================
<?

http://www.rackspeed.net/index.php?m_id=2  for example (just an example my
site is not frames)
  Is it possible to run the query in the index.php of a frameset and have
the array available to the 2 php files(left frame & right Frame).

I have the following code:
-------------------
<?php header("Location: http://www.mysite.com/");
exit; ?>

Dear newsgroup,
I have a three-table database:
table 1:
ID | GID | GDESCRIPTION

I've been using mysql for a few months now, and I just got around to
full text searching.
I'm using the following query on my table to get only records with
titles that have "word1" AND "word2":

I'm developing a web driven database using PHP and MySQL.  Basically the
main table will have a field containing the category each row is part of.
However, it is possible that a row could belong to more than one category
(represented by an integer), is there a sensible way to do ...

I have the following .php file called test8.php
I have Sambar server 5.3 set up on my Windows 98 system, along with
PHP version 4 and MySQL. I can add data into the database and I can
serve .php pages. I can poll the database and get data out of it and

I am making some queries on a table with comments. The comment table is
designed like this: Key, Lineno, Comment
When i make a query i get the following result:
Key      Lineno       Comment

i'm looking for someone to help me develop an online e-commerce application,
where users is able to pay through worldpay e-payment gateway... anyone
interested ?