Webmaster Forum / PHP / Database Access / May 2004

Is there any way to find out the value of the id (wich is autoincrement)
when using the following statements:
$query = "INSERT into rfc values
('','$gebruiker','$omschrijving','$reden','$aanspreekpunt')";

been subscribed for a few days and havent seen anybody ask what I want
to know and I apologise for the question
I have php/mysql webspace and can do simple stuff & install pre written
apps without any problem

I have a problem.  I insert in the table "Categorie" a record and I
increment the primary key with auto_increment.
After I recuperate the primary key with the function max() here max(id) and
I insert this key in a second table "Moderateur".

this is really a mysql question rather then php. But, i am writing very
small CMS (yes i know there are free ones but I dont like them) for myself
and I wanted to achieve the following.
When a user looks at an article on the site, I would like to make it so

just looking into a couple of things for a project I am working on and was
wondering if it is possible to select all data that is not distinct ie
something like:-
SELECT NOT DISTINCT domain FROM domain_list

Can anyone advise,
I'm trying to build a bunch of php forms to add, update, delete and list
data from a mysql database.
What I'm trying to do is enter data via a form, and then use the an insert

I currently searching a table across a number of fields - The user can type
a single search term e.g. "Sony" and the system does a LIKE match in
manufacturer and search_words.
search_words is used to provide additional search terms (e.g. TV, HI-FI,

Can anyone advise,
I'm trying to build a bunch of php forms to add, update, delete and list
data from a mysql database.
What I'm trying to do is enter data via a form, and then use the an insert

I have an PHP page that contains several checkboxes. I need to know if the
user has check all of the checkboxes before they can proceed to the next
page.
How do I check there status?

Hello, I have a script with the following line
       // Upload the data to file to the usps db.
       exec("mysqlimport --replace --fields-terminated-by=','
--fields-optionally-enclosed-by='\"' --user=$db_user

OK,
I know I can found it somewhere, I tried to use ORDER BY merk DESC in
the post of Ryan Hagg but I can't get out... :-(
This is my script:

I have a page and a sponsor. Every time a user click on a banner from our
sponsor their webpage is opened. I'd like to reward these users, but how to
check who clicked on a banner. I can't do anything on sponsor's webpage?
Thanks for helping,

Just when I though I knew what I was doing. I ran into a roadblock.
I have two tables, organizations & users
I am building a form online for orgs to input their own information.
How do I insert into both tables when the org table needs to know what the

I'm not too experienced with MySQL, so I'm not too sure how to go about
doing this. I had an idea, but the MySQL docs are too vague.
I have two tables :
News-

   Anyone had a problem with mysql_query() not returning anything?  Not
false, not true, nothing.  I have an active connection, I checked my sql
syntax and it returns nothing.  Any insights would be helpful...  Thanks!
/T