03.2018 um 22:59 schrieb Roger House:
>>> >>> In all respects except one, the treatment of Unicode works just
>>> fine.
>>> >>> I can write Unicode to database tables, read it, display it,
>etc.,
>>> >>> with no problems.
2:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works just
fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute
ects except one, the treatment of Unicode works just fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>
ust fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>> containing the Venus and Mars Unicode ch
treatment of Unicode works just fine.
I can write Unicode to database tables, read it, display it, etc.,
with no problems. The exception is mysql, the MySQL Command-Line
Tool. When I execute a SELECT statement to see rows in a table
containing the Venus and Mars Unicode characters, here is what I
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I
can write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool. When I
execute a SELECT statement to see
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use a
2017/10/18 18:32 ... Roger House:
I get the same behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with mysql itself.
What do you know about the displays to which the client is writing?
In the case of "cmd" under
n, all tables are created with these parameters:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
In all respects except one, the treatment of Unicode works just fine. I can
write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysq
On Wed, Oct 6, 2010 at 11:15 PM, Hank wrote:
> Ok, I can see that.
>
Oh, I wasn't implying that mine was necessarily better - I didn't even think
of doing it that way. I suggested a benchmark because different fuctions
might have different execution speeds. Now actually thinking about this,
I've
Ok, I can see that. Here's a different approach that gets it down to
two function calls and some math.. and the DATE_FORMAT call might not
even be needed depending on the actual application.
select
DATE_FORMAT(start_time, "%Y-%m-%d %h:" ) as dhour,
10*(minute(start_time)%6) as dtime
Two people already who suggested a text-based approach vs. my numeric
approach.
Analysing, my method takes a single function call per record (to_unixtime);
Travis' takes 4 (concat, date_format, truncate, minute) and Hank's 3
(concate, left, date_format).
Someone feel like benchmarking ? :-D
On
Here's what I came up with:
select concat(left(DATE_FORMAT(start_time, "%Y-%m-%d %h:%i"
),15),"0") as time, count(*) from table group by time
-Hank
>>
>> How would one go about to construct a query that counts items within an
>> increment or span of time, let's say increments of 10 minutes?
>>
our_table;
-Travis
--
From: "Pascual Strømsnæs"
Sent: Wednesday, October 06, 2010 4:20 AM
To: "[MySQL]"
Subject: Constructing query to display item count based on increments of
time
Hi!
How would one go about to construct a query that counts it
convert to unixtime, convert your interval to unixtime, creatively combine
with integer division to get a base number for each period, group by that
and count().
2010/10/6 Pascual Strømsnæs
> Hi!
>
> How would one go about to construct a query that counts items within an
> increment or span of t
Hi!
How would one go about to construct a query that counts items within an
increment or span of time, let's say increments of 10 minutes?
Imagine a simple table where each row has a timestamp, and the query
should return the count of items occurring within the timespan of a
defined period.
designs.com
> Subject: Getting Array to display on SELECT
> Date: Tue, 20 Apr 2010 18:16:52 -0400
>
> I'm frankly not sure if this is a MySQL question or PHP, but I thought I
> would start here.
>
> I have a form that I have a (ever growing) list of checkboxes, Here is
This is a PHP question.
-Original Message-
From: Gary [mailto:g...@paulgdesigns.com]
Sent: Tuesday, April 20, 2010 3:17 PM
To: mysql@lists.mysql.com
Subject: Getting Array to display on SELECT
I'm frankly not sure if this is a MySQL question or PHP, but I thought I
would start her
I'm frankly not sure if this is a MySQL question or PHP, but I thought I
would start here.
I have a form that I have a (ever growing) list of checkboxes, Here is a
sample of the code for it.
It seems to go in, when I say seems to, I get a result of Array in the
table, the code is listed
field showing 1 for
the display priority of the first author and 2 for the second?
Question 2 is: How to retrieve and display the two authors on one line
as Author_1 "and" Author_2 without some incredible conditional
contortions to achieve the goal?
--
Phil Jourdan --- p...@ptahhotep.c
Hi All,
A small doubt.
In oracle we have something like
dbms_out.put_line('abc')..to display messages from plsql.
Do we have any thing similar to this, what is the way to display user
friendly message from PLSQL in mysql.
I am trying to write some stored proc's and wanted t
Hello again,
I inserted "double" values, like :
mysql> insert into t (n) values ('0.54316E+11');
then I display it as :
5431600
which is not easy to read.
Is there a way to tell Mysql to display such numbers
with exponent ?
I could not find a trick through and arou
The first question that occurs to me is, Why on earth would you want an app
to display 2500 rows? You must have one incredible monitor with a resolution
beyond my wildest dreams! I would look into the LIMIT predicate and use it
to grab say 50 rows at a time, or fewer, and post a marker so you know
Velen wrote:
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it
between
The only limit is the size of the VARCHAR field
-Original Message-
From: Andrey Dmitriev [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 08, 2008 12:34 AM
To: mysql@lists.mysql.com
Subject: group_concat display limit
All,
We are using group_concat but there seems to be some
learnt.
On Jan 8, 2008 2:11 PM, Werner Puschitz <[EMAIL PROTECTED]> wrote:
> Andrey Dmitriev wrote:
> > All,
> >
> > We are using group_concat but there seems to be some sort of display
> > limit.
> > Is there are a way to unset or increase it?
> >
Andrey Dmitriev wrote:
> All,
>
> We are using group_concat but there seems to be some sort of display
> limit.
> Is there are a way to unset or increase it?
>
> Thanks,
> Andrey
>
You can change the maximum length by setting the group_concat_max_len
system varia
You should change your sql to related sub query.
On Jan 8, 2008 1:34 PM, Andrey Dmitriev <[EMAIL PROTECTED]> wrote:
> All,
>
> We are using group_concat but there seems to be some sort of display
> limit.
> Is there are a way to unset or increase it?
>
> Thanks,
>
All,
We are using group_concat but there seems to be some sort of display
limit.
Is there are a way to unset or increase it?
Thanks,
Andrey
est tout | 4 |
+--++
AS YOU SEE, THE DISPLAY IS NOT GOOD AT ALL :
how could I got the column WELL ALIGNED ???
thank you.
WHAT I HAVE DONE :
mysql> SHOW VARIABLES LIKE 'character_set_system';
+--+---+
| Variabl
I searched some more and then I found
Bug # 10897 - FLOAT and DOUBLE obeying precision and scale. No
documentation.
http://bugs.mysql.com/bug.php?id=10897
Regards,
Martin.
>
> Hi,
>
> I've recently changed MySQL versions and I am puzzled by the difference in
> dis
Hi,
I've recently changed MySQL versions and I am puzzled by the difference in
display of float values.
CREATE TABLE test (
id int unsigned NOT NULL auto_increment,
val1 float default NULL,
val2 float(3,3) default NULL,
val3 float(5,3) default NULL,
val4 float(10,6) default
08 | Debian Woody | 1004 | 0 |
> > | 10 | 1 | 10 | Vermischtes | 0 | 0 |
> > +----+---+-+---+---+-+
> > 10 rows in set (0.24 sec)
> >
> > and I want to display a tree like:
> >
> > Software
&
| 10 | Vermischtes | 0 | 0 |
> ++---+-+---+---+-+
> 10 rows in set (0.24 sec)
>
> and I want to display a tree like:
>
> Software
> Virenscanner
>Linux
>Debian Woody
>
In theory, theory and practice are the same;
In practice they are not.
On Sun, 29 Jan 2006, Jochen Kaechelin wrote:
> To: mysql@lists.mysql.com
> From: Jochen Kaechelin <[EMAIL PROTECTED]>
> Subject: display a hierarchic tree
>
> I have the following table:
>
Jochen,
...I want to display a tree like:
Software
Virenscanner
Linux
Debian Woody
Windows
Windowsd XP
Packprogramm
Sniffer
Hardware
Vermischtes
It looks more like a
000 | Vermischtes | 0 | 0 |
++---+-+---+---+-+
10 rows in set (0.24 sec)
and I want to display a tree like:
Software
Virenscanner
Linux
Debian Woody
Wind
of every group" doesn't mean anything without
explicit ordering.
What do you mean?
PB
-
Dan Bolser wrote:
On Mon, 11 Apr 2005, Rhino wrote:
- Original Message -
From: "Dan Bolser" <[EMAIL PROTECTE
cit ordering.
What do you mean?
>
>PB
>
>-
>
>Dan Bolser wrote:
>
>>On Mon, 11 Apr 2005, Rhino wrote:
>>
>>
>>
>>>- Original Message -
>>>From: "Dan Bolser" <[EMAIL PROTECTED]>
>>>To:
>&g
r 2005, Rhino wrote:
- Original Message -
From: "Dan Bolser" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 11, 2005 5:58 AM
Subject: Display 1st row of every group?
I read with great interest this
http://www.artfulsoftware.com/queries.php#4
Dis
On Mon, 11 Apr 2005, Peter Brawley wrote:
>/>I guess that entry is either wrong or misleading./
>
>Ordering by another column which isn't mutually dependent with the
>grouping column will have unpredictable results. Is that what you mean
>by the example being "wrong or misleading"?
No, I mean t
r 2005, Dan Bolser wrote:
I read with great interest this
http://www.artfulsoftware.com/queries.php#4
Display 1st row of every group
SELECT id
>FROM tbl
GROUP BY id
HAVING count(*) = 1;
I want to use this syntax with an 'order by' like this...
SELECT *
On Mon, 11 Apr 2005, Rhino wrote:
>
>- Original Message -
>From: "Dan Bolser" <[EMAIL PROTECTED]>
>To:
>Sent: Monday, April 11, 2005 5:58 AM
>Subject: Display 1st row of every group?
>
>
>>
>> I read with great interest th
- Original Message -
From: "Dan Bolser" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 11, 2005 5:58 AM
Subject: Display 1st row of every group?
>
> I read with great interest this
>
> http://www.artfulsoftware.com/queries.php#4
>
> Display 1st row of ev
a unique minimum value per id group.
On Mon, 11 Apr 2005, Dan Bolser wrote:
>
>I read with great interest this
>
>http://www.artfulsoftware.com/queries.php#4
>
>Display 1st row of every group
>
>SELECT id
>FROM tbl
>GROUP BY id
>HAVING count(*) = 1;
>
>I wa
I read with great interest this
http://www.artfulsoftware.com/queries.php#4
Display 1st row of every group
SELECT id
FROM tbl
GROUP BY id
HAVING count(*) = 1;
I want to use this syntax with an 'order by' like this...
SELECT *
FROM tbl
GROUP BY id
HAVING count(*) = 1
ORDE
I am trying to store images in the longblob text type in one of my
tables, and then display the picture on a Coldfusion MX 6.1 page.
When I try to get it to display, I get the following error:
ByteArray objects cannot be converted to strings.
The error occurred in C:\Web Sites\Scooter2\Scooters
- Original Message -
From: "Tracy Gems" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 28, 2004 5:59 PM
Subject: display only populated fields
>
> How do I go about only displaying fields that have data and are not empty
or have NULL?
fields that have data and are not
> empty or have NULL?
>
> It's a 112 column table so I only want to display the fields that have
data.
>
> Thanks.
>
> select * from table where .
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
How do I go about only displaying fields that have data and are not empty or have NULL?
It's a 112 column table so I only want to display the fields that have data.
Thanks.
select * from table where .
-
Do you Yahoo!?
Yahoo! Ma
content of the table - all
> fields, all records. Depending upon the content of different fields in
> different tables, I need to display certain fields of certain records
> within the full recordset. What's the syntax for selecting a particular
> record for display relativ
I have a recordset that retrieves the full content of the table - all
fields, all records. Depending upon the content of different fields in
different tables, I need to display certain fields of certain records
within the full recordset. What's the syntax for selecting a particular
recor
On Wed, 14 Jul 2004 11:17:20 -0500, "Peter Brawley"
<[EMAIL PROTECTED]> said:
> Match() returns a graded "relevance rating", snip...
> you are looking for, though what you're looking for isn't entirely clear
> from your post.
It'll do OK. I would like to suggest if there's a wish list to make
Fax to:
07/14/2004 10:06 Subject: Search one table
ld put them both in the MATCH...OK, it
> works.
> $query="SELECT * FROM balloon_txt WHERE
> MATCH(access_no, recs_txt)
> AGAINST ('robin')";
> $result = MySQL_query($query);
>
> /
> OK, right here - next below I'm gonna displa
sion logic to find the matches you want, so have a look
at in the manual.
Once you reslve these two problems, probably simple JOIN syntax will get you
the SQL result you need.
HTH.
PB
- Original Message -
From: leegold
To: mySQL mailinglist
Sent: Wednesday, July 14, 2004 9:06 AM
If you would entertain a MYSQL/PHP, hope not too off-topicIt's
probably not difficult to solve - but you would be helping me
with some SQL logic.
The only way I can think of to explain what I want to do
is to give you my working newbie MSQL/PHP code that I'm learning
MYSQL/PHP with, and at a cert
On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote:
> We discovered a rather odd situation where some space characters where
> being displayed as "?".
>
> In tracking this down, it was determined that the server had stored the
> hex value "A0" rather than "20" by using this query:
All:
We discovered a rather odd situation where some space characters where
being displayed as "?".
In tracking this down, it was determined that the server had stored the
hex value "A0" rather than "20" by using this query:
select LocationId, LevelId, Hex(NameLn),NameLn
from Location
w
On 10 Jun 2004 at 7:02, Daniel Venturini wrote:
> Hello I am using PHP, mysql. How would I query mysql to display the last
> time a table was last modified/changed/or updated. For example I have a user
> that updates a stats page via the web, and I would like it to say (Current
> up
Daniel Venturini <[EMAIL PROTECTED]> wrote:
> Hello I am using PHP, mysql. How would I query mysql to display the last
> time a table was last modified/changed/or updated. For example I have a user
> that updates a stats page via the web, and I would like it to say (Current
> up
QL General
Subject: Last Modified
If your table contains a timestamp field, it will update each time the row
is altered. Otherwise I don't think it's possible.
You Wrote -
Hello I am using PHP, MySQL. How would I query MySQL to display the last
time a table was last modified/cha
Hello I am using PHP, mysql. How would I query mysql to display the last
time a table was last modified/changed/or updated. For example I have a user
that updates a stats page via the web, and I would like it to say (Current
up to "The last date the stats table was modified"). Thanks for
Hi,
I wrote an jdbc application and inserted strings data into the
database. I can correctly selected them back. However, I can not visually
see the data stored in the data through the MySQLCC GUI. Is there a way to
explicitly specify the character set for MySQLCC? Any idea?
Regards,
Micha
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2004-04-24 19:40 +0200]:
> I want to know if there is a way to change the display of the mysql
> query results.
If you're under GNU/Linux, type "\P less -S" at the mysql prompt.
This sets the pager to "less", which a
hi,
I want to know if there is a way to change the display of the mysql
query results.
itz confusing to see if you have a lot of fields in the table. and if the
string is a long string for a particular string there are lot of lines that
are being printed.
Liz
--
MySQL General
Original Message-
> From: Hunter, Jess [SMTP:[EMAIL PROTECTED]
> Sent: Sunday, December 14, 2003 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Help with "JOIN" and Record Display
>
> This being the first time I have tried to do a JOIN statement (and still
>
This being the first time I have tried to do a JOIN statement (and still not
yet fully understanding it). If someone could take a look at the below code
and see what I may be doing wrong.
I have the actual code working and it displays the information from
$TableName2.notes, however in this table t
Hello:
I'm using mysqlcc version 0.9.3 on RH 9.0.
When I upgraded from RH 7.2, the application seems
to have changed into a bizarre, unreadable font.
Does anyone know what could be the problem?
Obviously, this renders the application entirely
unusable. I suspect a QT problem, will look for
sou
> > > >while (list($fid, $title, $lname, $fname) =
> > mysql_fetch_row($result))
> > > > {
> > > > echo " > cellspacing=2>";
> > > > echo " > > >href=FacDetails.php?fid=$fid>$fname $lname > > >width=200>$title&
name) =
> mysql_fetch_row($result))
> > > {
> > > echo " cellspacing=2>";
> > > echo " > >href=FacDetails.php?fid=$fid>$fname $lname > >width=200>$title";
> > > echo "";
> > > }
> > >?
arning on this. Pls. excuse me if I simply overlooked
> >something.
> >
> >Originally I had this:
> >
> > >// list matches
> >
> >while (list($fid, $title, $lname, $fname) = mysql_fetch_row($result))
> > {
> > echo "";
> > ech
hen used within quotes.
At 01:32 PM 10/17/2003, Jordan Morgan wrote:
Hi,
I'm still learning on this. Pls. excuse me if I simply overlooked
something.
Originally I had this:
while (list($fid, $title, $lname, $fname) = mysql_fetch_row($result))
{
echo "";
echo "$fname $lna
Hi,
I'm still learning on this. Pls. excuse me if I simply overlooked
something.
Originally I had this:
";
echo "$fname $lname$title";
echo "";
}
?>
to list the search results and display them as a link which will take
the user to a detailed page. However,
Hi folks
I wrote an application which uses japanese characters. I can display
japanese characters, fetching from a mysql database on my WindowsXP
machine.
I moved the same to a Linux machine and could see only junk characters.
Any suggestions?
MySQL version 4.0.13 on Win XP Japanese
MySQL
ROM tablename
> WHERE TO_DAYS(NOW(()_TO_DAYS(date_column)<=30;
>
> (This query selects all records with a 'date_column' value within the last 30 days.)
>
> Now my question is: What if I would like to display data for the CURRENT MONTH
> and the last 11 months???(May al
is query selects all records with a 'date_column' value within the last 30 days.)
Now my question is: What if I would like to display data for the CURRENT MONTH
and the last 11 months???(May also said to be the LAST MONTHS)
HOw should my select query be like??
Hope to receive some help soon.
Dwight Trumbower <[EMAIL PROTECTED]> wrote:
> I'm sure this has been discussed before, I just haven't found it.
>
> When creating numeric data types you have the option of putting a display
> attribute. After reading the docs, I'm not really sure why you would
I'm sure this has been discussed before, I just haven't found it.
When creating numeric data types you have the option of putting a display
attribute. After reading the docs, I'm not really sure why you would want
to do this.
From a DBA point of view, I don't care how the
-->To: [EMAIL PROTECTED]
-->Subject: How to Dispaly Column heading after every 15 records display
-->
-->Hello All,
-->
--> By default Mysql select statement displays column names header only
-->once
--> at the first row.
-->
-->I want the column names for the se
Hello All,
By default Mysql select statement displays column names header only once
at the first row.
I want the column names for the select statment to be displayed after
every say 15 rows of display. ( This is very much equal to set line size 15
in oracle) .
can any one Help ASAP
>
>
>
>
use this:
echo '';
where "0,0" is the result-set index for your mysql field. you might
use other mysql functions of course, but the place to put the output
in is the same
the html-source code will look like it is only a normal image path,
but the server sends the binary data
Dan Anderson wrote:
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
I've done some notes on this at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html
- assuming of course you're using PHP as a WWW backend to
dig the stuff o
Good luck,
Jef
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 15, 2003 4:31 PM
> To: Partap Davis
> Cc: [EMAIL PROTECTED]
> Subject: Re: How can I display images from a mySQL Database in a web
page?
>
> > I think there
On 15 Jul 2003 at 18:31, Dan Anderson wrote:
> > I think there is a way to insert binary image data in your html, but
> > is there any particular reason you need to do that?
>
> Yes, my client's server is running with particularly restrictive PHP
> safe mode settings and has informed me that dyna
> I think there is a way to insert binary image data in your html, but is
> there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic images are a /must
have/. :: bangs head against wal
> I think there is a way to insert binary image data in your html, but is
> there any particular reason you need to do that?
>
> First you would need to encode it in some ascii equivalent (check
> w3c.org, I think) ...and it would increase the size of your html page
> while rendering the browser's
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
First you would need to encode it in some ascii equivalent (check w3c.org, I
think) ...and it would increase the size of your html page while rendering
the browser's image cache
THis is kinda offtopic.. it depends on what frontend you are using to
access mysql (php,java,perl,etc) ..
You just need to pull the binary data and output it with the correct http
headers and it will show up in a browser.. search the list for more
info. www.php4.com has an example using php..
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ssage ---
From: gerald_clark <[EMAIL PROTECTED]>
To: vernon <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Sent: Mon, 23 Jun 2003 11:13:53 -0500
Subject: Re: SQL query - 3 tables - 3rd one conatins records to not display
> And what happens if you leave off the 'distinct'
And what happens if you leave off the 'distinct' ?
vernon wrote:
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
pen
OK so now I have:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_fav LEFT JOIN penpals_privmsgs_block ON
penpals_fav.user_id = penpals_privmsgs_block.user_id
WHERE penpals_fa
; To: [EMAIL PROTECTED]
> Subject: RE: SQL query - 3 tables - 3rd one conatins records
> to not display
>
>
> OK so now I have something like this:
>
> SELECT distinct useronline.uname, penpals_fav.fav_user_id,
> penpals_fav.ID,
> penpals_privmsgs_block.user_id, penp
OK so now I have something like this:
SELECT distinct useronline.uname, penpals_fav.fav_user_id, penpals_fav.ID,
penpals_privmsgs_block.user_id, penpals_privmsgs_block.blocked_id
FROM useronline, penpals_privmsgs_block left join penpals_fav on
penpals_privmsgs_block.user_id
WHERE penpals_fav.f
- 3 tables - 3rd one conatins records to
> not display
>
>
> I have a SQL query that needs to reference three different
> tables. I'm
> creating an online buddy list of members who are online. I
> have all of this
> functioning but am trying to also reference anothe
I have a SQL query that needs to reference three different tables. I'm
creating an online buddy list of members who are online. I have all of this
functioning but am trying to also reference another table where the user is
being blocked, in which case I do not what the user's name to be shown in
PRIMARY KEY (id)
);
heres the output i get in my web page
3 Test2 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan
2 Test1 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan
Can i tweak the query so that i can display BLOB data
);
heres the output i get in my web page
3 Test2 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan
2 Test1 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan
Can i tweak the query so that i can display BLOB data properly.
Possibly, but you specify neither what's wrong the th
1 - 100 of 184 matches
Mail list logo
