Dear Entrepreneur:
Can you honestly say that you're earning the type of income you
thought you would when you first began your networking career?
Unfortunately, the history of networking says that there's a 95%
chance you are not earning what you would like to earn.
How many different opportu
HI,
I have data on more than 1 db to separate in year name like these:
cust2000--> contain customer infomation in year 2000
cust2001--> contain customer infomation in year 2001
all db have the same field name. I have put db name and table na
Hi,
there was an typing error 'from Title' should be 'from Titles'. Anyway it's
working for me.
What error message it produce?
On Thursday 01 November 2001 05:09, you wrote:
> Petr Tuma wrote:
> > select *,(case when Title like 'The %' then substring (Title, 5, 255)
> >
> > ETC.
>
> Alas, My
Petr Tuma wrote:
> select *,(case when Title like 'The %' then substring (Title, 5, 255)
> ETC.
Alas, MySQL doesn't like that syntax either. :(
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com
--
PHP Database Mailing List (http://www.php.net/)
To u
Hi,
I would assume that MySQL doesn't support functions in the 'order by' clause.
Try this:
select *,(case when Title like 'The %' then substring (Title, 5, 255)
when Title like 'A %' then substring (Title, 3, 255)
when Title like 'An %' then substring (Title, 4, 255)
else Title end) as sort_co
Back when I was working with MSSQL I need to alphabetize movie titles in
the proper library format where 'A' 'An" and 'The" are ignored.
For MSSQL I was told to use:
select *
from Titles
order by case when Title like 'The %' then substring (Title, 5, 255)
when Title like 'A %' then substring (Ti
Hello Jim,
The problem isn't with the query. It's in the last two printf
statements:
printf("%s %s $s", $row->name, $row->room_num, $row->update_time);
printf("%s %s $s", $row->name, $row->update_time, $row->room_num);
In each line you have two occurrences of '%s' in the format string,
while t
Try replacing the values before you dump it into the database:
$value = str_replace("#0169", "©", $value);
Do that for all the values. You can make it do the reverse when you need to
display the values in HTML (although most browsers after Netscape v2.x and
IE v3.x recognize these characters wi
union available in version 4.0 (alpha) now
-Original Message-
From: Harpreet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 11:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Alternative for Union in MYSQL
I had a view on sqlserver which i am trying to convert to work with m
I had a view on sqlserver which i am trying to convert to work with mysql.
It uses a union which i believe does not work with mysql. What is another
alternative for union.
Sql with union:
select a.asset_id,a.material_id,b.material_id as parent_material_id from
lib_asset_tbl a inner join lib_asse
Hi,
PHP and MySQL are not talking to each other. Numerous tutorials available on
the web for getting MySQL, PHP, and Apache to work together... depending on how
you installed PHP and MySQL, the method varies. If PHP is compiled with support
for MySQL, it may be as simple as uncommenting or add
Thanks alot... right now I cannot really work on it but I am going to setup
a test table to work with so I make sure I get the correct results on the
test before I impliment it on our main tables. Thanks again, all of you guys
on this newsgroup have been a great help to a newbie like myself. =)
Ja
one problem I see, you are trying to populate the variable after you
register it.
session_start();
$myvar = "something";
session_register('myvar');
echo $myvar;
Jim Lucas
- Original Message -
From: "Russ Michell" <[EMAIL PROTECTED]>
To: "Steve Cayford" <[EMAIL PROTECTED]>
Cc: "Matthew
I'm experiencing a strange problem with HTML entities in
form input using
PHP v. 4.0.4pl1.
My form consists of three fields:
- A "select" pulldown menu (generated from database) to
enable users to select an existing record;
- A text field in which users enter a headline;
- A textarea fie
* session_register('myvar'); creates a session var called $myvar
* session_start(); needs to be called from the top of each script that will need the
session var
$myvar
* session_destroy('myvar'); rids you of $myvar completely.
* session_destroy('HTTP_SESSION_VARS'); rids you off *all* current
This is really off-topic for this list, but...
From my understanding of sessions, you really don't want session_start()
in an if{} block. Every time you hit this script, it will have no memory
of any session variables until you call session_start().
-Steve
On Tuesday, October 30, 2001, at 02
Tx.
Yep I have read it now and understood it better than the first time I read
this part of the manual (it's amazing how things make more sense when you
can apply them to what you are doing).
"Jesse Goerz" <[EMAIL PROTECTED]> wrote in message
0110301727.19453@reign">news:0110301727.19453
Actually relational databases are set-based. The answer to
your tree structures question is that it is possible. It
is quite complicated though, so have a look at this phphoo
tutorial:
http://www.webreference.com/perl/xhoo/php1/
Rick Emery <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]
Domonique,
To use ODBC from Linux under PHP, you will need to link PHP with a Driver
Manager.
iODBC is a free, Open Source Driver Manager available at www.iodbc.org.
Your configure will have to include --with-iodbc=/path/to/odbcsdk
More information is available in the PHP HOWTOs at www.iodbc.org.
HI.
I have PHP4, Linux Red Hat 7.1, Inofrmix Dynamic Server 7.31 UD1 and Apache.
I would like to communicate with Informix from PHP via an ODBC driver. I
have the Merant 3.7, but I am not sure that it supports the version of
Informoix mentionned above.
Do you know if I can use this driver ?
If n
uncomment the line that enables the extension in your php.ini:
extension=mysql.so
if it don't work verify the line "extension_dir = /usr/lib/php4" and if the
file mysql.so is in this directory.
Bruno Gimenes Pereti.
- Original Message -
From: "JIM" <[EMAIL PROTECTED]>
To: <[EMAIL PROT
21 matches
Mail list logo
