Original Message-----
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: 01 March 2003 11:55
To: MySQL-Lista
Subject: Query with php
Dear Mysql guru's
I have a sneaky suspision that the my current problem is related!
I want to display
There are '$number of records' in '$the ci
Dear Mysql guru's
I have a sneaky suspision that the my current problem is related!
I want to display
There are '$number of records' in '$the city you have selected'
However this is proving to be beyond my brains capacity to deal with :p
So,if any of you can spot what the obvious mistakes I am
Instead of
echo htmlspecialchars( stripslashes($row["$i"]));
use
echo htmlspecialchars( stripslashes($row[0]));
In fact , if you increase $i you increase the column thus , in the first
cycle you see col 0 , in the second col 1
for more information visit
http://www.php.net
Can someone please tell me what's wrong with the following code? This info
is inside a function that I defined. One of the arguments that I pass the
function is the actual query. Based on the info that I know is loaded in
the database (it's a development database...there are only 2 rows of info)
t;$tmpquery .= $filter2;
>$tmpquery .= " AND ";
>}
>
>$query=substr($tmpquery,0,strlen($tmpquery) - 4); // remove extra AND
>
>
>
>I haven't tried this with checkboxes, but you should get the idea. This
>works with other
>queries that I
($tmpquery) - 4); // remove extra AND
I haven't tried this with checkboxes, but you should get the idea. This
works with other
queries that I have done.
John Lodge
-Original Message-
From: Trelfa, Jonathon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 3:45 PM
To: SQL Mailing
I am attempting to generate a query statement (using PHP) that is generated
based on user input from 2 sets of checkboxes. You can see a
barely-functioning version at this URL:
http://www.nobleaccord.com/view/view.php
The top part of the form just shows what the query statement looks like.
The
KAZ> Hi
KAZ> I've got a question on how to exclude a data from a query. Suppose I
KAZ> have
KAZ> the following query that is being used in combination with a PHP web
KAZ> site:
KAZ> "SELECT * FROM activities WHERE month='$month' AND year='$year'"
KAZ> Now suppose the activities table looks like
SELECT * FROM activities WHERE month='$month' AND year='$year'
and username != 'myuen'
-Original Message-
From: Kelly Alexander Zia [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 1:45 PM
To: mySQL
Subject: Excluding Data from a Query with PHP
Hi
Hi
I've got a question on how to exclude a data from a query. Suppose I
have
the following query that is being used in combination with a PHP web
site:
"SELECT * FROM activities WHERE month='$month' AND year='$year'"
Now suppose the activities table looks like this:
ID username month
10 matches
Mail list logo
