Getting a recordcount

Hi

I have opened a database in PHP and would like to know whether a particular
record exists.

i.e.

$ThisUsername = $_REQUEST['Username'];
mysql_pconnect("myHost","myLogin","myPass");
mysql_select_db("myDB");

$result = mysql_query("SELECT * FROM users WHERE Username = $ThisUsername");

This should generate a 1 Record recordset. How can i test if the recordset
only contains 1 record.

Thanks

Andy L

On 28-Oct-2003, "Andy Levy" <andy_levy@hotmail.com> wrote:

> I have opened a database in PHP and would like to know whether a
> particular
> record exists.
>
> i.e.
>
> $ThisUsername = $_REQUEST['Username'];
> mysql_pconnect("myHost","myLogin","myPass");
> mysql_select_db("myDB");
>
> $result = mysql_query("SELECT * FROM users WHERE Username =
> $ThisUsername");
>
> This should generate a 1 Record recordset. How can i test if the
> recordset
> only contains 1 record.



http://www.php.net/manual/en/functio...l-num-rows.php

--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to jamesbutler@willglen.net (it's reserved for spammers)

if(mysql_num_rows($result)==1)echo "only one record";

Greetz,

Mich

"Andy Levy" <andy_levy@hotmail.com> wrote in message
news:FOHnb.1895$0E5.667@news-binary.blueyonder.co.uk...
> Hi
>
> I have opened a database in PHP and would like to know whether a
particular
> record exists.
>
> i.e.
>
> $ThisUsername = $_REQUEST['Username'];
> mysql_pconnect("myHost","myLogin","myPass");
> mysql_select_db("myDB");
>
> $result = mysql_query("SELECT * FROM users WHERE Username =
$ThisUsername");
>
> This should generate a 1 Record recordset. How can i test if the
recordset
> only contains 1 record.
>
> Thanks
>
> Andy L
>
>

[sorry for the bottomquote, everyone in this thread seems to be doing it so
at least i'm consistent]

or:

$result = mysql_query("SELECT COUNT(*) FROM users WHERE
Username=$thisusername", $db);
$row = mysql_fetch_row($result);
if ($row[0] == 1) echo "only one record";

Floris

"Michel" <please_no@spam.nl> schreef in bericht
news:bnnlli$jce$1@news.cistron.nl...
> if(mysql_num_rows($result)==1)echo "only one record";
>
> Greetz,
>
> Mich
>
> "Andy Levy" <andy_levy@hotmail.com> wrote in message
> news:FOHnb.1895$0E5.667@news-binary.blueyonder.co.uk...
> > Hi
> >
> > I have opened a database in PHP and would like to know whether a
> particular
> > record exists.
> >
> > i.e.
> >
> > $ThisUsername = $_REQUEST['Username'];
> > mysql_pconnect("myHost","myLogin","myPass");
> > mysql_select_db("myDB");
> >
> > $result = mysql_query("SELECT * FROM users WHERE Username =
> $ThisUsername");
> >
> > This should generate a 1 Record recordset. How can i test if the
> recordset
> > only contains 1 record.
> >
> > Thanks
> >
> > Andy L
> >
> >
>
>