Webmaster Forum / PHP / Database Access / January 2005

i did a 'SET @foobar = 1;' in php but when i do a "SELECT @foobar" in
mysql command line, it returns a null.  however, running the select in
php returns a 1.  why is that so?  is the variable not in scope?

i have a query as follows and is unsure whether it is mysql or php:
$result = mysqli_query("SELECT COUNT(*) > @foobar AS status ....") where
it's suppose to get a one row value of either '0' or '1' (false or true)
if i were to do a SELECT COUNT(*) FROM...

I cant make a primary ket for my send table, why not? i get this error
message
ALTER TABLE `reactie` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `logid` )

I'm looking for a snippet of code, if someone is willing please....
I have a map image on my page and am able to pick up the mouse co-ordinates
via JavaScript. I want to identify the co-ordinates that have been clicked
on, and use that information to retrieve some data from a ...

I am trying to install PHP with Mysql on a Windows XP machine
but I keep getting the following error
Fatal error: Call to undefined function mysql_connect() in
c:\Inetpub\wwwroot\test site\info.php on line 2

Hello all, i cant get something straight,
I have a table like this:
<table width="84%" border="1" align="center">
         <tr>

Fooled you !

Does anyone know of any good PHP/MySQL forums?
I am not a frequent newsgroup users and would find a forum handy to use.
Thanks

I'm trying to create a second table in my database, with the
following results:
***
SQL-query :

When I query mysql database and I expect more then one row; I use the
following statements :
$sqlBooks = "SELECT ...";
$resultBooks = mysql_query($sqlBooks, $db);

I always use mysql_connect; I retrieve data from database, the information
is displayed on webpage and that's it.
User clicks on a link, new page is build, connection to database opened and
used in page. Finito.

I was wondering what people's opinions are regarding the verious
merits of doing user/member authentication on a site? I have a
database of users with membership levels and would like a good secure
way of having people log on and access their information.

I have some questions about searching for images (tagged with metadata) in a
SQL database.
What I want to do is to have several metadata fields attached to each
picture. One of the fields should be a "general expression" field with

We found a very reasonable solution on the Net with a monthly fee of
35,-€
for full content- and projectmanagment.
Mainly we use calendar, adressbook, discussion, pinboard and timesheet

I am developing a site using php and mysql and I would like to be able to
let visitors know how many other visitors are currently browsing the site
i.e. 'There are currently x amount of visitors browsing this site'
You can see this in action in the following sites but I am not ...