On Tue, 13 Mar 2012 17:33:43 +0530, Gu®u nagendra802...@gmail.com sent:
Hi,
Please help me with this code. I have 2 different fields in mysql table.
What I want is if the field is empty don't show the image. Please look at
the code below.
?php
if($search-plugin-ListViewValue()==)
On Tue, 13 Mar 2012 21:23:57 +0530, Gu®u nagendra802...@gmail.com sent:
No Michael, your code is also not working. What you have understood is
correct. let me explain it to others too.
If variable twitter and facebook are empty don't echo anything,
if variable twitter has a value and facebook
Hi,
Please help me with this code. I have 2 different fields in mysql table.
What I want is if the field is empty don't show the image. Please look at
the code below.
?php
if($search-plugin-ListViewValue()==)
{
echo 'a
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote:
Hi,
Please help me with this code. I have 2 different fields in mysql table.
What I want is if the field is empty don't show the image. Please look at
the code below.
I have looked at it.
Maybe you should tell what is
The issue is both the images are echoing and no if else statement is
working.
On Tue, Mar 13, 2012 at 7:22 PM, Matijn Woudt tijn...@gmail.com wrote:
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote:
Hi,
Please help me with this code. I have 2 different fields in mysql
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u nagendra802...@gmail.com wrote:
The issue is both the images are echoing and no if else statement is
working.
First of all, please bottom post on this (and probably any) mailing list.
You should perhaps provide what the contents of
From looking at your code, the issue is that your if statements are
checking for the same criteria as your else statements, meaning that if the
string is empty () the if statements will be triggered, and since the if
statements are true, the elseif statement will not be. Or if the string
isn't
No Michael, your code is also not working. What you have understood is
correct. let me explain it to others too.
If variable twitter and facebook are empty don't echo anything,
if variable twitter has a value and facebook is empty echo out only twitter,
if variable twitter has no value and
Hmm, what happens with the code I sent you? Just tested it on my end and
worked exactly as expected.
Try doing a
var_dump($search-plugin-ListViewValue(), $search-facebook-ListViewValue());
to make sure the data being returned is what's expected... you should be
getting string(0) returned for
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u nagendra802...@gmail.com wrote:
No Michael, your code is also not working. What you have understood is
correct. let me explain it to others too.
If variable twitter and facebook are empty don't echo anything,
if variable twitter has a value and facebook
I tried the below code too considering may be the localhost is really dumb
and we need to tell each and every condition. But still its not working :(
$tweet = $search-plugin-ListViewValue();
$fb = $search-facebook-ListViewValue();
if($tweet== $fb==)
{
Hi Everyone
I am trying to figure out how to write a SELECT query that will give me the
average of `bible_anagrams`.`views` starting on the date specified in
`bible_anagrams_rss_feed`.`rss_feed_date` and the previous 6 calendar days (for
a total of 7 days). What I am trying to figure out is
Hi All,
I have this code where user can search a song or the entire song title. It
looks like when a user search a single word its searching and giving the
proper results. However if the user wants to search the entire sentence its
not giving the proper results. For example let say I have
Hi All,
I have a database of MP3's in mysql. The database contains MP3 name, artist,
date, size etc. I need to order the search results in both ascending and
descending order. For example if user wants to see the size of all mp3's in
ASC order he will click on size column and again if he wants to
DB is like more then 500MB
and it will grow day by day :)
On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont ejsmont.ar...@gmail.comwrote:
If the DB is very small use tablesorter plugin of jquery. Otherwise
custumizable query method.
On 17 May 2010 07:56, nagendra prasad
Hehe. Then a method: ) just make a query builder method like 'findSongs'
with all the params ( optional or mandatory ) like page, limit, sortby,
filters etc. then inside build SQL based on args. Just be careful - SQL
injection is your enemy here. From app pass all the args from get/ post and
Hi Artur,
I am a beginner to this stuff. So, If you or anyone can give me some example
codes or may be some links for my reference that would be a great help.
Best,
Guru.
On Mon, May 17, 2010 at 12:57 PM, Artur Ejsmont ejsmont.ar...@gmail.comwrote:
Hehe. Then a method: ) just make a query
take a look at this:
http://datatables.net/examples/data_sources/server_side.html
On Mon, May 17, 2010 at 5:30 PM, nagendra prasad
nagendra802...@gmail.comwrote:
Hi Artur,
I am a beginner to this stuff. So, If you or anyone can give me some
example
codes or may be some links for my
Hello Guys,
I am developing an application, which would have a front end in Flash, and
the backend would be MySQL, now what I am thinking is to package this as an
exe file, similar to WAMP, which installs everything, So my exe should have
all my files, the MySQL data dump and should auto install
On Jan 7, 2010, at 2:36 PM, Vinay Kannan wrote:
Hello,
Theres this project that I am working on, and a specific module does take
few secs to process, I am thinking it would be cool to be showing a progress
bar(some kind on a .gif image) while the script runs, does any one have an
idea how
Hello,
Theres this project that I am working on, and a specific module does take
few secs to process, I am thinking it would be cool to be showing a progress
bar(some kind on a .gif image) while the script runs, does any one have an
idea how to implement this?
Thanks,
Vinay K
Hi everyone, first thank you for ALL help and the understanding that I am new
to PHP and MySQL. This is a long email and for that I apologize but I am trying
to provide as much detail as possible. If this is the wrong list to ask for
help, kindly direct me to the proper authority.
I am trying
Hi
Hi everyone, first thank you for ALL help and the understanding that I am new
to PHP and MySQL. This is a long email and for that I apologize but I am
trying to provide as much detail as possible. If this is the wrong list to
ask for help, kindly direct me to the proper authority.
I
John Burns wrote:
I did that but the php_mysql.dll is not in any of the zips from any of
the packages I tried downloading. I need to stay in PHP 4 because of
some applications. No matter what zip package I downloaded,
php_mysql.dll was not in the extensions directory. I tried a bunch of
I'm using Windows 2003, IIS and PHP 4.4.4 with MySQL 4.1. I had this
same setup on a server that got corrupted by a virus. I can't use any
of the files from the old setup so I'm trying to reinstall the same
versions. However, I can't find a php_mysql.dll file that will work.
All of the zip
John Burns wrote:
I'm using Windows 2003, IIS and PHP 4.4.4 with MySQL 4.1. I had this
same setup on a server that got corrupted by a virus. I can't use any
of the files from the old setup so I'm trying to reinstall the same
versions. However, I can't find a php_mysql.dll file that will work.
i get the error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL
server during query in /home/www/broadwaysecure.biz.nf/Index.php on line 9
Could not connect : Lost connection to MySQL server during query
I have done everything to connect to my database but its
Hello PHP people,
I`m looking for facebook and myspace API that will enable user to login on
my site using their facebook and myspace id. if this is not possible, can i
find something closer like, user will be able to perform
some activities from my site like inviting facebook/myspace friends,
Abah Joseph wrote:
Hello PHP people,
I`m looking for facebook and myspace API that will enable user to login on
my site using their facebook and myspace id. if this is not possible, can i
find something closer like, user will be able to perform
some activities from my site like inviting
I just saw something on pear.net
http://pear.php.net/package/Services_Facebookmaybe it will work.
On Wed, Jan 21, 2009 at 10:27 PM, Chris dmag...@gmail.com wrote:
Abah Joseph wrote:
Hello PHP people,
I`m looking for facebook and myspace API that will enable user to login on
my site using
I have this SQL
SELECT e1.*, l1.* FROM e1
INNER JOIN l1 WHERE e1.entre_active = 'Y' AND l1.entreID = e1.entre_id
The above query works but i want to add the one below
SELECT SUM(a1.adp_amount) as amount FROM a1 WHERE a1.adp_loanID = e1.loanID;
the last part of the query is to SUM the part
on
(l1.entreID = e1.entre_ID)
WHERE e1.entre_active = 'Y'
hth,
Yves
- Original Message -
From: Abah Joseph joefa...@gmail.com
To: php-db@lists.php.net
Sent: Tuesday, January 13, 2009 6:46 AM
Subject: [PHP-DB] help me JOIN 3 tables.
I have this SQL
SELECT e1.*, l1.* FROM e1
INNER JOIN
hth,
Yves
- Original Message -
From: Yves Sucaet yves.suc...@usa.net
To: php-db@lists.php.net
Sent: Tuesday, January 13, 2009 7:49 AM
Subject: Re: [PHP-DB] help me JOIN 3 tables.
Hi Joseph,
With the sum() aggregate function you'll need to use a GROUP BY clause and
specify which
Hi,
I have a mysql database with one table in it, currently it contains 36,807
records and it costs 6.8MB of space, every night another thousand~ of rows
are being added to the table.
The scheme (as taken from phpmyadmin) is like follows:
CREATE TABLE IF NOT EXISTS `search` (
`id` int(11) NOT
It should be a rapidshare links database (which updates with a PHP crawler I
wroted last Saturday).
I would like to change the snippet to title and add another column for the
snippet,
My main queries are INSERT's - a big insert (usually 10-100 links per
insert) in each hour.
My crawler is
On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten [EMAIL PROTECTED] wrote:
How about select Incidents.* from Incidents inner join Calls on
Incidents.id=Calls.incidentid where Calls.status='Open'?
...
Dee Ayy wrote:
...
The status column never has the text Open.
...
--
PHP Database Mailing List
Use an appropriate status.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Dee Ayy wrote:
On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten [EMAIL PROTECTED] wrote:
How about select Incidents.* from Incidents inner join Calls on
On Sat, Aug 9, 2008 at 1:32 AM, Niel Archer [EMAIL PROTECTED] wrote:
Hi
You do not say how you identify the last call (there is no date/time
field for example), so a complete answer is not really possible
With the id (auto incremented int), the last record of either table
would be the
Hi
You do not say how you identify the last call (there is no date/time
field for example), so a complete answer is not really possible
Do not use NOT LIKE 'Completed', it's an inefficient way of doing !=
'Completed'
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To
A database was designed with the following tables:
Incidents
_
id (auto incremented int)
...
Calls
_
id (auto incremented int)
incidentId (foreign key)
status (varchar 32)
...
The status of the last Call is the status of the related Incident.
Statuses can be Not started through
How about select Incidents.* from Incidents inner join Calls on
Incidents.id=Calls.incidentid where Calls.status='Open'?
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Dee Ayy wrote:
A database was designed with the following tables:
Incidents
_
1.
a class=?php print($class);? href=?php
print($thispage.($y0?(?start=).$y:));??php
print($pg);?/a
2. a href=?php print($thispage.($next0?(?start=).$next:));?/a
turns into:
?php
$string = 'a class=' . $class . ' href=' . $thispage;
if ($y 0) $string .= \$start= . $y;
$string .= '' . $pg
PROTECTED]Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Help in concatenation
1.
a class=?php print($class);? href=?php
print($thispage.($y0?(?start=).$y:));??php
print($pg);?/a
2. a href=?php
print($thispage.($next0?(?start=).$next:));?/a
turns into:
?php
$string = 'a class=' . $class . ' href
Hi,
I need to change PHP embeded in HTML to HTML embeded in PHP as trying to use
modularity approach.
I'm stuck on below these lines where concatenation is the big issue. I have
researched, read but couldnt sort this out after try really hard.
Could any one please help me to change this code
Hi I am a PHP beginner and using Namo Webeditor trial version in
order
to access an Excel file via ODBC...and I get no result
Namo generates the following code:
=
?
$a_startrow = $startrow;
$a_maxrows = $maxrows;
require('wed_php_odbc.inc');
?html
head
Hi,
I'm testing a program and I need you assistance.
Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program.
It will display an ID, please mail me back the ID.
If you can use it on several computers, it will be even better for me, I need
to have as much results as
I am using the odbc support in PHP 5.2 to connect to a sqlserver 2005
database. The odbc driver being used is the SQLSRV32.dll provided
as part of the install.
In the code below I find that if I use SQL_CUR_USE_ODBC as an option
to odbc_connect, the odbc_fetch_row() call below fails even though
I can't see how to accomplish what I need so if anyone has any
suggestions they would be gratefully received...
I'm using mysql 4.0.20 by the way.
I have two tables :
TableA
record_id
product_ref
TableB
timestamp
record_id
action
I want to create a SELECT that joins these 2 tables where the
Hi!
Graham Cossey wrote:
TableA
record_id
product_ref
TableB
timestamp
record_id
action
I want to create a SELECT that joins these 2 tables where the JOIN to
TableB only returns the most recent entry by timestamp.
For instance, to select all columns:
select * from TableA
join TableB on
On Thu, Mar 6, 2008 at 6:54 PM, Krister Karlström
[EMAIL PROTECTED] wrote:
Hi!
Graham Cossey wrote:
TableA
record_id
product_ref
TableB
timestamp
record_id
action
I want to create a SELECT that joins these 2 tables where the JOIN to
TableB only returns the
Hi!
Graham Cossey wrote:
I was hoping to avoid joining everything as there can be many entries
in TableB for each record in TableA.
Also wouldn't your query only return one record? I need to return all
records from TableA with the latest action from TableB as well.
Yes, sorry - I realised
Hi again!
We're getting a bit of topic here, since this is pure SQL.. But anyway...
I've played around with this one a bit since it seemed quite
interesting... The best I can do is to get the oldest action...
select TableA.record_id, product_ref, action, time_stamp from TableA
join TableB
You can try adding a quick test to the ON statement...
SELECT * FROM TableA
INNER JOIN TableB
ON TableA.record_id = TableB.record_id
AND TableB.timestamp = MAX(TableB.timestamp)
Now, I haven't tested it.
I can only say the theory of it is accurate.
- Jon L.
On Thu, Mar 6, 2008 at 12:46
This will give you:
ERROR : Invalid use of group function
It seems like the use of an aggregate (or how is it spelled?) function
is not allowed in a join statement...
/Krister
Jon L. wrote:
You can try adding a quick test to the ON statement...
SELECT * FROM TableA
INNER JOIN TableB
I may be a little confused: the desire is to return all the rows from
TableA that match the record_id of a row in TableB that has the MAX
timestamp?
If so, why not something like:
SELECT * FROM TableA a, TableB b WHERE a.record_id=b.record_id
timestamp=(SELECT MAX(timestamp) FROM TableB)
On Thu, Mar 6, 2008 at 9:54 PM, J. Hill [EMAIL PROTECTED] wrote:
I may be a little confused: the desire is to return all the rows from
TableA that match the record_id of a row in TableB that has the MAX
timestamp?
If so, why not something like:
SELECT * FROM TableA a, TableB b WHERE
-db@lists.php.net
Subject: Re: [PHP-DB] Help with JOIN query
On Thu, Mar 6, 2008 at 9:54 PM, J. Hill [EMAIL PROTECTED] wrote:
I may be a little confused: the desire is to return all the
rows from
TableA that match the record_id of a row in TableB that has the MAX
timestamp?
If so
Mysql doesn't support subselects in 4.0.x. That was added in 4.1.
-Roberto
J. Hill wrote:
I may be a little confused: the desire is to return all the rows from
TableA that match the record_id of a row in TableB that has the MAX
timestamp?
If so, why not something like:
SELECT * FROM
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL
Server.
Sorry if I caused confusion.
Gary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, Mar 6, 2008 at 10:59 PM, Gary Wardell [EMAIL PROTECTED] wrote:
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL
Server.
Sorry if I caused confusion.
Gary
You were getting my hopes up there Gary :-(
--
Graham
--
PHP Database Mailing List
, March 06, 2008 6:33 PM
To: Gary Wardell; php-db@lists.php.net
Subject: Re: [PHP-DB] Help with JOIN query
On Thu, Mar 6, 2008 at 10:59 PM, Gary Wardell
[EMAIL PROTECTED] wrote:
Ahh, to bad, I started using it with 5.0. I'm also a long
time user of SQL Server.
Sorry if I caused
Hi Guys,
When inserting a value like 123567.8956 in my table it is rounding it to 2
decimal place. The field type is set as float.
Can anyone tell me why it's not taking all the decimals? and How to insert
the number with all the decimals?
Thanks
Velen
--
PHP Database Mailing List
Velen wrote:
Hi Guys,
When inserting a value like 123567.8956 in my table it is rounding it to 2
decimal place. The field type is set as float.
Can anyone tell me why it's not taking all the decimals? and How to insert
the number with all the decimals?
Thanks
Velen
Hello Velen,
Your
On Feb 17, 2008 10:59 AM, Velen [EMAIL PROTECTED] wrote:
Hi Guys,
When inserting a value like 123567.8956 in my table it is rounding it to 2
decimal place. The field type is set as float.
Can anyone tell me why it's not taking all the decimals? and How to insert
the number with all the
Daniel Brown wrote:
On Feb 17, 2008 10:59 AM, Velen [EMAIL PROTECTED] wrote:
Hi Guys,
When inserting a value like 123567.8956 in my table it is rounding it to 2
decimal place. The field type is set as float.
Can anyone tell me why it's not taking all the decimals? and How to insert
the
This is kind of db related since the error appears to be occurring when
accessing a MySQL file.
This install is on Fedora 6 with Apache 2 and MySQL 5.0.45.
While doing the php install the config script errors out when it gets to
creating main/internal_functions_cli.c.
This is part of the
On 8/20/07, Asim [EMAIL PROTECTED] wrote:
can anyone provide me code of basic website structure having member
area and can use mysql database to show results of search by PAGINATION?
For pagination refer this :- http://www.phpfreaks.com/tutorials/43/5.php
Hope this will help you.
--- R *
- Original Message -
From: Karl James
To: 'bedul'
Sent: Thursday, March 29, 2007 10:40 AM
Subject: RE: [PHP-DB] Help creating tables and fields
bedul,
wow great information and so quick.
very greatfull for that.
Would you mine baby stepping for me?
[bedul]
i don't understand what u
hi all,
i need help in design a database, our office is hospital equipment supplier,
we had a list of items, each items had it's own configuration, and
each item could consist of several item. we also had contract that
have a lot of site, sometimes equipmend that have been ordered
different from
what is site mean in here??
- Original Message -
From: Suprie [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Wednesday, March 28, 2007 5:03 PM
Subject: [PHP-DB] help in database design
hi all,
i need help in design a database, our office is hospital equipment
supplier,
we had
Suprie wrote:
hi all,
i need help in design a database, our office is hospital equipment
supplier,
we had a list of items, each items had it's own configuration, and
each item could consist of several item. we also had contract that
have a lot of site, sometimes equipmend that have been
NOT QUITE..ups.. my bad
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Suprie [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Thursday, March 29, 2007 6:53 AM
Subject: Re: [PHP-DB] help in database design
Suprie wrote:
hi all,
i need help in design a database, our
Team,
I am in need of your help.
I have tried over the years to do this.
But, I seem not to be able to get it to the way I want.
I want to start from scratch.
What I want to do is build site that has team management
for your roster of players, and display stats in a nut shell.
As far as
Tim McGeary wrote:
Chris wrote:
Tim McGeary wrote:
Stut wrote:
Ok, so I did the recommended process of:
mysql UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
- WHERE Host = 'some_host' AND User = 'some_user';
mysql FLUSH PRIVILEGES;
This allows the CLI script to run
Chris wrote:
Tim McGeary wrote:
Stut wrote:
Ok, so I did the recommended process of:
mysql UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
- WHERE Host = 'some_host' AND User = 'some_user';
mysql FLUSH PRIVILEGES;
This allows the CLI script to run successfully, but the web php
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (13) in
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect(): Can't connect to local MySQL server through
socket
Please include the list in replies.
Sorry, I meant to, but hit the wrong button.
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following error via the PHP web
Tim McGeary wrote:
Please include the list in replies.
Sorry, I meant to, but hit the wrong button.
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to another
specific PHP list, please let me know.
I am getting the following
Stut wrote:
Tim McGeary wrote:
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
I am new to this list today, so if I should be sending this to
another
specific PHP list, please let me know.
I am getting the following error via the PHP web page I am building:
Warning: mysql_connect():
Tim McGeary wrote:
Oh, duh! Ok. I wrote this:
?php
$hostname = localhost;
$username = softread;
$password = XXX;
$dbname = software;
mysql_connect($hostname, $username, $password) or
die(mysql_error());
mysql_select_db($dbname) or
Stut wrote:
Tim McGeary wrote:
Oh, duh! Ok. I wrote this:
?php
$hostname = localhost;
$username = softread;
$password = XXX;
$dbname = software;
mysql_connect($hostname, $username, $password) or
die(mysql_error());
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or are you saying that the PHP libs
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or are you saying that
Tim McGeary wrote:
Thank you for the link. I think that's probably the best way to go in
this case, since it's only on a dev/test server. When I build the
production server, I should probably upgrade to PHP5 anyhow. I assume
that should not have this problem, right?
It might. PHP5 can be
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or are you saying that
Tim McGeary wrote:
Stut wrote:
Tim McGeary wrote:
But I do have a MySQL 5 client:
[EMAIL PROTECTED] html]# rpm -qa MySQL*
MySQL-shared-compat-5.0.27-0.rhel3
MySQL-client-standard-5.0.27-0.rhel3
MySQL-python-0.9.1-6
MySQL-server-standard-5.0.27-0.rhel3
MySQL-devel-standard-5.0.27-0.rhel3
or
Can anyone help me figure out how to solve my inventory listing problem?
I am using php_5 and mysql_5.0 w/apache on fbsd.
I need to figure out a way to make a subtitle for every category (genre)
in the inventory so when I list the entire inventory on a sheet (at
client's request), it is
goolge cross tab query ... that is what you are looking for
bastien
From: Suprie [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help on query report...
Date: Wed, 15 Nov 2006 13:28:15 +0700
dear all,
i have this table
id | contract No | site id | handover date |status
dear all,
i have this table
id | contract No | site id | handover date |status| finishing date |
contract value|actual value
1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 |
12,000 | 12,000
2 | T0002 | LOS02 | 12-Apr-06| Done | 11 Apr-06 |
Suprie wrote:
dear all,
i have this table
id | contract No | site id | handover date |status| finishing date |
contract value|actual value
1 | T0001 | LOS01 | 12-Apr-06| Done | 11-Apr-06 |
12,000 | 12,000
2 | T0002 | LOS02 | 12-Apr-06| Done | 11
Hello,
I have an input field that inserts data into an oracle table. The users
of the system will be composing the data that goes into this input field
in Microsoft Word.
They will also be using Microsoft Word formatting features.
1. Is it possible for my input box to retain the formatting and
Forgive me for saying this, but you should be posting this to the Oracle
mailing list, not here.
David Skyers wrote:
Hello,
I have an input field that inserts data into an oracle table. The users
of the system will be composing the data that goes into this input field
in Microsoft Word.
1. yes, user a rich text editor plugin in you web page
(http://www.kevinroth.com/rte/ is one such beast)
2. sure, in a text / blob field
3. yes, but likely you'll need to do it as CDATA
hth
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help
Hello, all. I'm having a problem with a php/mysql app which is
probably in the SQL, so please don't get angry at me. Basically, I
have a CASE statement that works on my localhost, but doesn't seem to
get recognised on the production server (i'm running php/mysql 5.x on
my localhost, 4.x of both
Hello All,
I am fairly new to PHP but have coded in asp and asp.net for years. I
am trying to find the code that will allow me to display the name of the
column's from the table I am using. Below is the code where I am
writing all the data out in a comma delimited fashion, but I want to
make
@lists.php.net
Subject: [PHP-DB] Help displaying Column Names
Hello All,
I am fairly new to PHP but have coded in asp and asp.net for years. I
am trying to find the code that will allow me to display the name of the
column's from the table I am using. Below is the code where I am
writing all
hi
I have a problem whith inforcing the result of a selekect query, here is
my tables and the query:
I create this 4 tables:
CREATE TABLE a (
a_id SERIAL PRIMARY KEY,
a_name text );
CREATE TABLE b (
b_id SERIAL PRIMARY KEY,
b_price INT2 );
CREATE TABLE c (
c_id SERIAL PRIMARY KEY,
a_id
Hi,
I need some help in sql - postgresql:
I create this 4 tables:
CREATE TABLE a (
a_id SERIAL PRIMARY KEY,
a_name text );
CREATE TABLE b (
b_id SERIAL PRIMARY KEY,
b_price INT2 );
CREATE TABLE c (
c_id SERIAL PRIMARY KEY,
a_id INT4 REFERENCES a ON UPDATE CASCADE ON DELETE CASCADE,
b_id INT4
1 - 100 of 533 matches
Mail list logo