[PHP-DB] Re: url return
In article <003101c1f23d$192952f0$0100a8c0@musicnircvthry>,
[EMAIL PROTECTED] says...
> I have the following query:
> $query = "SELECT * FROM netjuke_tracks ORDER BY id DESC";
> $latemp3 = mysql_query($query) or die("Select Failed!");
> $latemp3 = mysql_fetch_array($latemp3);
> echo "Latest MP3 : "; echo $latemp3[name];
>
> I also have a field called "location" which holds the file location. What I would
>like to know is how do I get it to return with the name as the name of the link and
>the url is the location of the link.
>
> Thanks in advance.
>
> B.J.Rumsey
>
Just echo the appropriate HTML with the relevant variables added in the
correct places.
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] url return
I have the following query:
$query = "SELECT * FROM netjuke_tracks ORDER BY id DESC";
$latemp3 = mysql_query($query) or die("Select Failed!");
$latemp3 = mysql_fetch_array($latemp3);
echo "Latest MP3 : "; echo $latemp3[name];
I also have a field called "location" which holds the file location. What I would like
to know is how do I get it to return with the name as the name of the link and the url
is the location of the link.
Thanks in advance.
B.J.Rumsey
Re: [PHP-DB] Re: Spaces Problem php & mysql
AddSlashes() or AddCSlashes()
-Szii
- Original Message -
From: "Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 4:11 PM
Subject: Re: [PHP-DB] Re: Spaces Problem php & mysql
> On Thursday 02 May 2002 10:10 am, you wrote:
> > - Original Message -
> > From: "Hugh Bothwell" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, May 02, 2002 6:23 AM
> > Subject: [PHP-DB] Re: Spaces Problem php & mysql
> >
> > > > I've been pounding my head (and the keyboard with searches) over this.
> > > > Do
> > >
> > > I
> > >
> > > > have to take the first entry apart with string functions to get my
> > > > desired end, which is the entire name in one field in the database?
> > >
> > > ... make sure the value is enclosed in quotes when you try
> > > to insert it into the database, ie
> > >
> > > INSERT INTO table ( name ) VALUES ( '$name' )
> >
> > Make sure you escape out all single quotes in $name.
> >
> > $name = " This is Paul's field."
> > .
> > .
> > .
> > INSERT INTO table ( name ) VALUES ( '$name' )
> >
> > Will fail, because you have VALUES ('This is Paul');
> >
> > Post the full value of $name via var_dump($name) and
> > var_dump($query) and we'll see what we can find with it.
> >
> > 'Luck
> >
> > -Szii
> Thank you David and Szii. The urlencode solved the sending problem. But I've
> had in the back of my mind to remember to deal with apostrophe's in names for
> some time and just haven't done it. Good reminder. Is there any easier way to
> do this than looping through each character in a string?
>
> Paul
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Using functions in SELECT statements
(in response to my own response)
By the way it just occured to me that the default SELECT statement is
already case insensitive. So is any of this is even necessary? If you want
to display the selected items in lower case, then do that in your script
with strtolower();
-Kevin
"Robin S McKenzie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I'm trying perform a case-insensitive test for a name. These are stored
> like "Association of ...", and I want to convert both the filter and the
> test data to lower- (or upper-) case. Why doesn't this work: ?
>
> SELECT *
> FROM [Organisation Membership]
> WHERE lower(organisation) LIKE lower('%$SearchBox$%')
>
> Robin McKenzie
> Department of Mechanical Engineering
> University of Bristol
> e:[EMAIL PROTECTED]
> e:[EMAIL PROTECTED]
> m:+44(0)7970 058712
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Using functions in SELECT statements
Is this in SQL server? It seems we don't have enough of the code to be able to tell
the problem. The query has to be put in a string and SearchBox has to exist, and this
all has to be run from a query function, and well, if you actually show your php
code it would help quite a bit. :-)
-Original Message-
From: Kevin Stone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 4:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Using functions in SELECT statements
Your problem may be the use of single quotes around your wildcard search
string. I haven't tested it but SQL probably works like PHP in that single
quotes denote exact values while double quotes allows evaluation of the
quoted string.
-Kevin
"Robin S McKenzie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I'm trying perform a case-insensitive test for a name. These are stored
> like "Association of ...", and I want to convert both the filter and the
> test data to lower- (or upper-) case. Why doesn't this work: ?
>
> SELECT *
> FROM [Organisation Membership]
> WHERE lower(organisation) LIKE lower('%$SearchBox$%')
>
> Robin McKenzie
> Department of Mechanical Engineering
> University of Bristol
> e:[EMAIL PROTECTED]
> e:[EMAIL PROTECTED]
> m:+44(0)7970 058712
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Using functions in SELECT statements
Your problem may be the use of single quotes around your wildcard search
string. I haven't tested it but SQL probably works like PHP in that single
quotes denote exact values while double quotes allows evaluation of the
quoted string.
-Kevin
"Robin S McKenzie" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I'm trying perform a case-insensitive test for a name. These are stored
> like "Association of ...", and I want to convert both the filter and the
> test data to lower- (or upper-) case. Why doesn't this work: ?
>
> SELECT *
> FROM [Organisation Membership]
> WHERE lower(organisation) LIKE lower('%$SearchBox$%')
>
> Robin McKenzie
> Department of Mechanical Engineering
> University of Bristol
> e:[EMAIL PROTECTED]
> e:[EMAIL PROTECTED]
> m:+44(0)7970 058712
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Global Connection object
Probably. However, you'll have to global($connection_obj) in each function to allow access to that. I think newer versions of PHP have an auto registering global namespace, however, and you may not need that global() call anymore. Why would you want to? I believe the PHP/Zend engine has pooling capabilities, so it's not really any overhead to "reconnect." If no pooling is available, then you limit yourself (and your webserver) to a single connection. (Will kill your performance.) HTH. 'Luck -Szii - Original Message - From: "Shaun Johnston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 5:03 PM Subject: [PHP-DB] Global Connection object > Is it possible to make a MySQL connection object global, so that it doesn't > need to be declared as a parameter to be accessed from individual functions? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Spaces Problem php & mysql
- Original Message -
From: "Hugh Bothwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 6:23 AM
Subject: [PHP-DB] Re: Spaces Problem php & mysql
> > I've been pounding my head (and the keyboard with searches) over this. Do
> I
> > have to take the first entry apart with string functions to get my desired
> > end, which is the entire name in one field in the database?
>
> ... make sure the value is enclosed in quotes when you try
> to insert it into the database, ie
>
> INSERT INTO table ( name ) VALUES ( '$name' )
Make sure you escape out all single quotes in $name.
$name = " This is Paul's field."
.
.
.
INSERT INTO table ( name ) VALUES ( '$name' )
Will fail, because you have VALUES ('This is Paul');
Post the full value of $name via var_dump($name) and
var_dump($query) and we'll see what we can find with it.
'Luck
-Szii
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Session Problem, Please Help.....
I believe it's because $CLIENTID is not set at ALL before you
register it. (ie, isset($CLIENTID) would fail) Therefore it cannot
register the variable...there's nothing for it to register or track.
Try...
$CLIENTID = "";
session_register("CLIENTID");
$CLIENTID="SOMEVALUE";
- Original Message -
From: "Hayan AL Mamoun" <[EMAIL PROTECTED]>
To: "PHPList (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 3:15 AM
Subject: [PHP-DB] Session Problem, Please Help.
> Dear all, I have a strange problem:
> I'm using IIS / WINNT4, PHP4
> Please check these two files:
> --
> logon.phtml:
> session_start();
> session_register("CLIENTID");
> $CLIENTID="SOMEVALUE";
> header("Location: clients/editclient.phtml");
> ?>
> --
> clients/editclient.phtml:
> session_start();
> echo "CLient ID VALUE IS : $CLIENTID";
> ?>
>
> When I run logon.phtml, it must create a session variable called CLIENTID
> and then move to the second page, which displays this variable.
> Each time I test this code I start a new instant of the IE and request
> logon.phtml (in order to create a new session), but it never works from the
> first time, while if I tested it a second time from the same instance of IE
> it works???!
> Please could anyone help, why it dosn't work from the first time?
>
> thnkx
> Hayan
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Using functions in SELECT statements
The problem is that you can't do a php function on a field name inside a
query, only on the contents after the query has already been executed!
The LIKE function in sql is case insensitive anyway, so you'll pull out all
the matches just by using:
$sql = "SELECT * FROM Organisation_Membership WHERE organisation LIKE
'%$SearchBox'";
if this is the wrong anser, and you were trying to do something different,
let me know!
Matt Stewart
[EMAIL PROTECTED]
-Original Message-
From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 15:11
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that was a copying error...
It gives the error " undefined function: lower"
R
Robin McKenzie Department of Mechanical Engineering University of Bristol
e:[EMAIL PROTECTED] e:[EMAIL PROTECTED] m:+44(0)7970 058712
"Peter Lovatt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
>
> Could it be the second $ in the lower('%$SearchBox$%') ?
>
> Peter
>
>
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> ---
>
> > -Original Message-
> > From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
> > Sent: 02 May 2002 14:34
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Using functions in SELECT statements
> >
> >
> >
> > I'm trying perform a case-insensitive test for a name. These are stored
> > like "Association of ...", and I want to convert both the filter and the
> > test data to lower- (or upper-) case. Why doesn't this work: ?
> >
> > SELECT *
> > FROM [Organisation Membership]
> > WHERE lower(organisation) LIKE lower('%$SearchBox$%')
> >
> > Robin McKenzie
> > Department of Mechanical Engineering
> > University of Bristol
> > e:[EMAIL PROTECTED]
> > e:[EMAIL PROTECTED]
> > m:+44(0)7970 058712
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Using functions in SELECT statements
Hi Robin
Instead of using sql to change the case of the search criteria try using php
as in the statement below
$query="
SELECT *
FROM [Organisation Membership]
WHERE lower(organisation) LIKE '%". strtolower($SearchBox) ."%')";
Hope this is of some help to you
Tony James
- Original Message -
From: "Robin S McKenzie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 3:11 PM
Subject: Re: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that was a copying error...
It gives the error " undefined function: lower"
R
Robin McKenzie Department of Mechanical Engineering University of Bristol
e:[EMAIL PROTECTED] e:[EMAIL PROTECTED] m:+44(0)7970 058712
"Peter Lovatt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
>
> Could it be the second $ in the lower('%$SearchBox$%') ?
>
> Peter
>
>
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> ---
>
> > -Original Message-
> > From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
> > Sent: 02 May 2002 14:34
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Using functions in SELECT statements
> >
> >
> >
> > I'm trying perform a case-insensitive test for a name. These are stored
> > like "Association of ...", and I want to convert both the filter and the
> > test data to lower- (or upper-) case. Why doesn't this work: ?
> >
> > SELECT *
> > FROM [Organisation Membership]
> > WHERE lower(organisation) LIKE lower('%$SearchBox$%')
> >
> > Robin McKenzie
> > Department of Mechanical Engineering
> > University of Bristol
> > e:[EMAIL PROTECTED]
> > e:[EMAIL PROTECTED]
> > m:+44(0)7970 058712
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that was a copying error...
It gives the error " undefined function: lower"
R
Robin McKenzie Department of Mechanical Engineering University of Bristol
e:[EMAIL PROTECTED] e:[EMAIL PROTECTED] m:+44(0)7970 058712
"Peter Lovatt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
>
> Could it be the second $ in the lower('%$SearchBox$%') ?
>
> Peter
>
>
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> www.sunmaia.net
> [EMAIL PROTECTED]
> tel. 0121-242-1473
> ---
>
> > -Original Message-
> > From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
> > Sent: 02 May 2002 14:34
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] Using functions in SELECT statements
> >
> >
> >
> > I'm trying perform a case-insensitive test for a name. These are stored
> > like "Association of ...", and I want to convert both the filter and the
> > test data to lower- (or upper-) case. Why doesn't this work: ?
> >
> > SELECT *
> > FROM [Organisation Membership]
> > WHERE lower(organisation) LIKE lower('%$SearchBox$%')
> >
> > Robin McKenzie
> > Department of Mechanical Engineering
> > University of Bristol
> > e:[EMAIL PROTECTED]
> > e:[EMAIL PROTECTED]
> > m:+44(0)7970 058712
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
FW: [PHP-DB] Using functions in SELECT statements
Could it be the second $ in the lower('%$SearchBox$%') ?
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original Message-
> From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2002 14:34
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Using functions in SELECT statements
>
>
>
> I'm trying perform a case-insensitive test for a name. These are stored
> like "Association of ...", and I want to convert both the filter and the
> test data to lower- (or upper-) case. Why doesn't this work: ?
>
> SELECT *
> FROM [Organisation Membership]
> WHERE lower(organisation) LIKE lower('%$SearchBox$%')
>
> Robin McKenzie
> Department of Mechanical Engineering
> University of Bristol
> e:[EMAIL PROTECTED]
> e:[EMAIL PROTECTED]
> m:+44(0)7970 058712
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Using functions in SELECT statements
I'm trying perform a case-insensitive test for a name. These are stored
like "Association of ...", and I want to convert both the filter and the
test data to lower- (or upper-) case. Why doesn't this work: ?
SELECT *
FROM [Organisation Membership]
WHERE lower(organisation) LIKE lower('%$SearchBox$%')
Robin McKenzie
Department of Mechanical Engineering
University of Bristol
e:[EMAIL PROTECTED]
e:[EMAIL PROTECTED]
m:+44(0)7970 058712
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Session Problem, Please Help.....
Hayan AL Mamoun wrote: try this logon.phtml: -- clients/editclient.phtml: the deZayner > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Spaces Problem php & mysql
"Paul" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a form on one server which takes a name in one field, intentionally > including spaces as a full name. That value shows up as a form variable as I > intended when I display it on the same server. It is sent to another server > and written to a mysql database there. At that time, only the first word in > the field is written. When the value is returned by the same php script that > received and wrote the database, the only thing left in the field is the > first word. Length of the word seems to have nothing to do with this. > > I've been pounding my head (and the keyboard with searches) over this. Do I > have to take the first entry apart with string functions to get my desired > end, which is the entire name in one field in the database? ... make sure the value is enclosed in quotes when you try to insert it into the database, ie INSERT INTO table ( name ) VALUES ( '$name' ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Form Submittion
I have a work-in-progress class to handle update/edit of forms, but my general strategy for checkboxes has been to include another hidden field which has a value of 1 so you know that there should be an accompanying field. e.g. f_checkboxname is your checkbox c_checkboxname is your fake field in the loop where you go through all the fields, look for antyhing that starts with f_ or c_ and if you get a c_, look for the accompanying f_. If it's got a value, then set the checkbox 1, else set it zero -- Jamie Thursday, May 2, 2002, 8:39:12 AM, you wrote: PN> I have made function that automaticly inserts/updates the fields in a mysql PN> database from the $HTTP_POST_VARS variable. So when a user submits a form is PN> will autimaticly update the database. The problem I am having is that i need PN> to be able to submit unchecked checkboxes. PN> Does anyone know how to do this, or any workaround. PN> Thanks. PN> -- PN> Cameron Cooke PN> Software Engineer PN> Toucan Resolve Ltd PN> Registered No 3900680 PN> Tel: 01273 422288 PN> Fax: 01273 272227 PN> Email: [EMAIL PROTECTED] -- Best regards, Jamesmailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Form Submittion
I have made function that automaticly inserts/updates the fields in a mysql database from the $HTTP_POST_VARS variable. So when a user submits a form is will autimaticly update the database. The problem I am having is that i need to be able to submit unchecked checkboxes. Does anyone know how to do this, or any workaround. Thanks. -- Cameron Cooke Software Engineer Toucan Resolve Ltd Registered No 3900680 Tel: 01273 422288 Fax: 01273 272227 Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Session Problem, Please Help.....
Dear all, I have a strange problem: I'm using IIS / WINNT4, PHP4 Please check these two files: -- logon.phtml: -- clients/editclient.phtml: When I run logon.phtml, it must create a session variable called CLIENTID and then move to the second page, which displays this variable. Each time I test this code I start a new instant of the IE and request logon.phtml (in order to create a new session), but it never works from the first time, while if I tested it a second time from the same instance of IE it works???! Please could anyone help, why it dosn't work from the first time? thnkx Hayan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: php-db Digest 1 May 2002 19:24:34 -0000 Issue 1181
Hi Frank,
Thank you for the help and example you included in your reply.
With the help gained by all that answered I concocted this work around which
works perfectly.
I have included the code to help anyone else who needs this kind of result.
It has two table references
the first gets admin data and the seconds uses the admin data to reference
the 2nd table for all instances.
-- My Code Snippet -
$whichadminsql = "select id, user from $tbn";
$whichadminres = mysql_query($whichadminsql);
while($adname = mysql_fetch_array($whichadminres)){
$adid = $adname[id];
$adnm = $adname[user];
$query = "select count(admin_id) as Admin1 from $tbn3 where admin_id=$adid
";
$result = mysql_query($query);
$object = mysql_fetch_object($result);
$Admin[$i] = $object -> Admin1;
$adminstatsshow .= "$adnm has $Admin[$i] posts.";
}
// Variables used are specific to my tables and needs and will need changing
to your suit your needs.
-- End My Code Snippet -
Once again Thank you
"Frank Flynn" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi Dave,
>
> The easiest, most direct, ANSI - SQL way to do what you ask is:
>
> SELECT count(*) as num_posts, Admin_id
> FROM <>
> WHERE <>
> GROUP BY Admin_id
> ORDER BY Admin_id
>
> This will give you:
>
> num_posts Admin_id
> -
> 3 1
> 4 2
> 5 3
>
> And naturally you can do whatever you like with these values in your PHP
> code. The only potential "got ya" is if you had an Admin_id 4 who had no
> records you would not get 0, 4 you would not get a row for 4 at all.
There
> is a way around. Ask me if you need it.
>
> Also GROUP BY has it's own kind of WHERE clause called HAVING. The WHERTE
> clause operates on the raw data (like any other query) but HAVING works on
> the aggregate functions (like count, min, max, ave) so in this example we
> could add this line right after the GROUP BY:
> HAVING count(*) > 4
> This would make the query only return the 5, 3 row.
>
> Good Luck,
> Frank
>
> On 5/1/02 12:24 PM, "[EMAIL PROTECTED]"
> <[EMAIL PROTECTED]> wrote:
>
> > From: "Dave Carrera" <[EMAIL PROTECTED]>
> > Date: Wed, 1 May 2002 13:02:51 +0100
> > To: <[EMAIL PROTECTED]>
> > Subject: Count and group ?
> >
> > Hi All
> >
> >
> >
> > I have added a row to my table which inputs which admin user has amended
> > a record in a table on my db.
> >
> >
> >
> > I have this working but what I would like to do is count how many
> > instances of the admin id I have stored.
> >
> >
> >
> > So if my list looks like this..
> >
> >
> >
> > Admin_id
> >
> > 1
> >
> > 2
> >
> > 2
> >
> > 2
> >
> > 3
> >
> > 3
> >
> > 3
> >
> > 3
> >
> > 3
> >
> > 2
> >
> > 1
> >
> > 1
> >
> > Then the result I would like to display is this..
> >
> >
> >
> > Admin (1) = 3 posts
> >
> > Admin (2) = 4 posts
> >
> > Admin (3) = 5 posts
> >
> >
> >
> > Basically displaying the total post each admin has made
> >
> >
> >
> > Any help or guidance is very appreciated and thank you in advance
> >
> >
> >
> > Dave Carrera
> >
> > Php Developer
> >
> > http://davecarrera.freelancers.net
> >
> > http://www.davecarrera.com
> >
> >
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
