Webmaster Forum / PHP / Database Access / May 2005

I have put together an online estate agent but the search results are coming
back wrong it will retrieve the correct results if you search with the lower
at 0 and the greater price at 1,000,000 but if you search from 1 to 600,000
or any combinations it only brings back one result ...

One table of my database could contain multiple values  eg student_courses,
each student could have done many different courses.
For a search engine, I want to be able to tick a checkbox and get all the
students who have done that course. However, if I tick two or more

I use mysql_escape_string() to escape all my form-entered fields,
mainly to prevent malicious code injection. But what is the best way
to unescape them in the code? I can see stripslashes() does the job,
but it seems very cumbersome and i'd need to stripslashes() every

I need know when the session expired. I intend to create two messages, one  
when the session was not created and other when it's expired. e.g:
Was not created:
Message: Login in the site

You know "Ask seller to question" of ebay, exists something of similar
written in php with mysq or not?  Thanks

is there sombody who can helpme witht he following, i am ''pretty new'' to
php and am looking for a script to show images randomly at a 10/ 15 seconds
interval. is there anybody who can help me with this or does know where to
find a good template script for this?

I want to insert values in 2 tables from a form, but in the second table, I
want to get the (new) id (auto_incr) of the first table in one of the column
in 2nd table.
Is it at all possible and how to do this if possible?

I have a SELECT * query that returns info such as 'name', 'date',
'cost', and 'notes'.  At the head of this query return it reads how
many records were found.  I would like to append that with 'how many
records were found at a cost of' ...

This is probably quite easy but I think I'm getting the syntax wrong
somewhere.
I have a form to update user details and it would be NICE if I could obtain
those user details from the database and place it directly into the form on

I'm new to PHP & MySQL. I want to be able to process a form with 4
input fields according to how many fields are filled out. If only one
is filled, it searches on that, if two it searches accordingly etc. I
have all the select statements for each instance working I just don't

I currently have a webpage (
http://www.tourney.com/tournament-poker-rankings.html ) that is just
html. As you can see, it's a huge list of information that includes
names, numbers, $$$ amounts, etc. I'd like to have this info able to be

I hope this is an obvious question, but I'm very new to classes.
I have created a class that have a number of variables defined for it.
class cart {
   var $username = "blah";

Gentlemen,
We have a 0907 tee-off on Monday at Garrison. I hope that is acceptable.
Brian

i am looking for a good tutorial on how to place (links to) images in a
mysql database.
anyone a good address?
my major problem is finding out what the url of the db is, in order to have

I am a Windows admin who has an intermediate knowledge of Linux with a
question for the Linux/database techies out there.
I recently added a Samba server to my 2003 AD network just for extra file
storage.  I installed MySQL on it and it is running and populated with