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,
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 harry (removethis)@gabha.net
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
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 paste the
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 empty or
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 =
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,
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
11 matches
Mail list logo