cool! thanks Sam and Jeff, for your responses!
best,
a
> -----Original Message-----
> From: Sam Masiello [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 1:48 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP] test for empty $result??
>
>
>
> Then you can use:
>
> if (mysql_num_rows($result) == 0) {
> stuff here
> }
>
> This will check the number of rows returned from your query. If zero,
> then do something....modify as you need.
>
> HTH
>
> Sam Masiello
> Software Quality Assurance Engineer
> Synacor
> (716) 853-1362 X289
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> From: Andrew [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 1:45 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP] test for empty $result??
>
> thansk, but $result here is a Resource ID, and will be present even if
> the
> result set associated with it is null.
>
> best,
> a
>
>
> > -----Original Message-----
> > From: Jeff Lewis [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 10, 2001 1:43 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: [PHP] test for empty $result??
> >
> >
> > Just use:
> >
> > if (!$result){
> > code here
> > }
> >
> > Jeff
> >
> > > -----Original Message-----
> > > From: Andrew [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 10, 2001 1:34 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] test for empty $result??
> > >
> > >
> > > I know that this has been discussed before, but I cannot find
> > the threads
> > > so...
> > >
> > > I have a function that does a mysql_query and want to break if
> > > the SQL query
> > > didn't return any rows in $result.
> > >
> > > empty(), isset() will not work, for obvious reasons.
> > >
> > > Can anyone suggest an alternative?
> > >
> > > $sql="select row from table where field = \"1\"";
> > > $link_id = mysql_connect($hostname, $username, $password);
> > > mysql_select_db($database, $link_id);
> > > $result = mysql_query ($sql, $link_id) or die;
> > >
> > > //this doesn't work...right?
> > > if (empty($result)) break;
> > >
> > > best,
> > > andrew
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> > >
> > >
> > >
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
