Hello Harry,
you can use left join:
http://dev.mysql.com/doc/mysql/en/JOIN.html
$query = "
SELECT members.id, firstname, familyname, middlename, fathername,
region3.region3, region4, members.country, country.countryname,
MATCH(firstname, middlename, familyname, father
Hi all.
I am querying a database of single information multiple times using a
simple 'select' statement. However, whenever the data in the DB is
empty or is 0 (zero), then it throws an error. However, I don't want it
to throw an error, I just want it to move on to the next query.
This is being
What mail program are you using? I'm getting mail parsing errors.
In addition, you have your From set as:
"Harry G"
Likely, ( and ) aren't supposed to be in there (invalid chars) and it
also makes it impossible to reply to you. There is no other "from" or
"reply to" in the headers.
Answer to y
Pablo,
Hello Philip,
pse.. can you paste the error information?
There is no known "empty set" problem.
Here's my function:
function getMysqlSelectResultForUsername($identifier, $userName, $link)
{
$queryResult = mysql_query("select $identifier from theTable where
username = '$userName'
Why not...??
if (!($queryResult =
mysql_result($queryResult, 0)))
{
return 0;
}
- Original Message -
From: Philip Thompson <[EMAIL PROTECTED]>
Date: Monday, July 26, 2004 12:57 pm
Subject: Re: [PHP-DB] Empty query result
> Pablo,
>
> > Hello Philip,
> >
> > pse.. can you past
Hello Philip,
pse.. can you paste the error information?
There is no known "empty set" problem.
--
Best regards,
Pablo
PT> Hi all.
PT> I am querying a database of single information multiple times using a
PT> simple 'select' statement. However, whenever the data in the DB is
PT> empt
On Tuesday 27 July 2004 00:57, Philip Thompson wrote:
> Here's my function:
>
> function getMysqlSelectResultForUsername($identifier, $userName, $link)
> {
> $queryResult = mysql_query("select $identifier from theTable where
> username = '$userName'", $link);
>
> if (!($queryResult = mys
Hello Philip,
read:
http://www.php.net/manual/en/function.mysql-result.php
when you do $queryResult = mysql_result($queryResult,0) you get
the error... so, you can do something like this:
function getMysqlSelectResultForUsername($identifier, $userName, $link)
{
Thanks all! I will try some of the suggestions that you guys gave. I
appreciate it.
~Philip
On Jul 26, 2004, at 12:52 PM, Pablo M. Rivas wrote:
Hello Philip,
read:
http://www.php.net/manual/en/function.mysql-result.php
when you do $queryResult = mysql_result($queryResult,0) you
You should remove "(removethis)" to send via email. This is just a
precaution because often Newsgroups are scanned for email address and added
spammers list. Just want to avoid that.
"Justin Patrin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What mail program are you using? I'm
Thanks Pablo, that worked.
"Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello Harry,
> you can use left join:
> http://dev.mysql.com/doc/mysql/en/JOIN.html
>
> $query = "
> SELECT members.id, firstname, familyname, middlename, fathername,
> re
Hi
Here's the senario...
Table 1- members
id - firstname - middlename - - country - region3
Fields country and region3 hold the integer codes for country and region3 is state
Table 2- country
id - countryname
Countryname is where the actual Country name is stored and id is the country code
12 matches
Mail list logo