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
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==)
{
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
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
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
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.
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
Hi Joseph,
With the sum() aggregate function you'll need to use a GROUP BY clause and
specify which fields you want from e1 and l1. Something like this:
SELECT e1.field1, e1.field2, l1.field3, SUM(a1.adp_amount) as amount
FROM a1 inner join e1 on (a1.loanID = a1.adp_loanID) inner join l1 on
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
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
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!
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
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
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
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 a
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
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
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
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|
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
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
On 9/14/06, Miguel Guirao [EMAIL PROTECTED] wrote:
You haven't searched at all, go to www.php.net and look up for
mysql_field_name() and related functions!!
-Original Message-
From: Grant Griffith [mailto:[EMAIL PROTECTED]
Sent: Jueves, 14 de Septiembre de 2006 10:22 a.m.
To:
suad wrote:
Hi,
I need some help in sql - postgresql:
snip
Yay a postgres question! :D hee hee
*The question is* : how can I force that the result of the col payed to
be zerro 0 insted of nothing (NULL)
and the order will be in way that the zerro's values comes first.
and the result will
Hi,
Thanks a lot,
That exactly wat I need
:)
Suad
Chris wrote:
suad wrote:
Hi,
I need some help in sql - postgresql:
snip
Yay a postgres question! :D hee hee
*The question is* : how can I force that the result of the col payed
to be zerro 0 insted of nothing (NULL)
and the order
The reason I had orginally singled out one column ['usr_d'] is so I could nest
it inside another loop to see if two values match. if usr_id matched returned
value from first loop.
The way I called it was if(!in_array(@$row_rsResults['id_subscribe'],$usrreg)) {
else{
now Im not
from the
queries and it put a newline at the end of the output data.
Thanks everyone for the help with this.
-Original Message-
From: Oskar [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 1:59 AM
To: Mickey Martin; PHP db
Subject: Re: [PHP-DB] help with file downloads from MySQL
Subject: Re: [PHP-DB] help with file downloads from MySQL
Mickey Martin wrote:
From what I can tell, the 0a is not in the file, but is being inserted
either with the echo or by the browser when it receives the file. Does
anyone know if a proxy server would cause this? There shouldn't be one
, March 24, 2006 1:59 AM
To: Mickey Martin; PHP db
Subject: Re: [PHP-DB] help with file downloads from MySQL
Mickey Martin wrote:
From what I can tell, the 0a is not in the file, but is being inserted
either with the echo or by the browser when it receives the file. Does
anyone know if a proxy
it is
configured today.
Thanks,
Mickey
-Original Message-
From: Giff Hammar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 3:50 PM
To: 'Mickey Martin'; 'Bastien Koert'; php-db@lists.php.net
Subject: RE: [PHP-DB] help with file downloads from MySQL
Can you use something like this (I haven't
If you load the data into the field with addslashes, have you tried
stripslashes on the way out?
Bastien
From: Mickey Martin [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] help with file downloads from MySQL
Date: Tue, 21 Mar 2006 12:55:56 -0600
Every time I try to download a
@lists.php.net
Subject: RE: [PHP-DB] help with file downloads from MySQL
If you load the data into the field with addslashes, have you tried
stripslashes on the way out?
Bastien
From: Mickey Martin [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] help with file downloads from MySQL
Date
was successfully added to the database.brbr;
echo a href='main.php'Continue/a;
}
mysql_close();
} else {
?
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 2:07 PM
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] help
, March 21, 2006 2:07 PM
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] help with file downloads from MySQL
If you load the data into the field with addslashes, have you tried
stripslashes on the way out?
Bastien
From: Mickey Martin [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject
: Mickey Martin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 4:05 PM
To: 'Bastien Koert'; php-db@lists.php.net
Subject: RE: [PHP-DB] help with file downloads from MySQL
I tried purposely corrupting the file by adding blank spaces at the
beginning of the echo:
echo ,$data;
The 0a
- bob - you
Etc.
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 10:28 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help needed creating a social network
CREATE TABLE `users` (userID int(11) not null auto_increment, primary
john who knows carrol who knows Sam.
Sam - carrol - john - bob - you
Etc.
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Monday, March 06, 2006 10:28 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help needed creating a social network
CREATE TABLE
CREATE TABLE `users` (userID int(11) not null auto_increment, primary
key(userID), name tinytext not null, email tinytext not null);
CREATE TABLE `links` (userID int(11), key (userID), friendID int(11),
key(friendID));
?php
$friends = mysql_query(select users.name, users.userID from users
Hi there,
I'm using asd just to test the search, here's the output from the statement
echoed to the screen:
SELECT word,def,photo, if(locate('asd',word),1,2) as meFirst
,MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) AS m FROM dictionary WHERE
MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE)
On 26/02/2006 3:03 PM, Chris Payne wrote:
Hi there everyone,
This line of code USED TO WORK but now it gives me a Coudln't Execute Query
error:
$query2 = SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword'
IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST
Thanks so much, Naintara, simplifying the field name in the way you
suggested seems to fix it.
Andrew
On 2/20/06, Naintara [EMAIL PROTECTED] wrote:
Hi,
Firstly, if you are assigning the value of variable $myrow['article_title']
to $right_row,
you should print $right_row and not $$right_row
Is the file you are trying to save parsed php? If it is parsed, I have no Idea
what your problem is, but its probably not apache-php.
otherwise, Its possible, you need to add handlers in your apache conf to
instruct apache to run .php files as php
something like
AddType
Hi,
Thanks for this, got a few reposnses regarding this.
This seems a more professional approach, I will try this and let you know
about it when I do it.
Thanks for your time.
Jerry
Ross Honniball [EMAIL PROTECTED] wrote:
Get rid of both your onload= statements and
Get rid of both your onload= statements and replace with...
window.onload=doboth
Then include the function below...
function doboth() {
changetext();
changead();
}
Not sure what you were getting at regarding the thing, but I think the browser
must just over-ride the previous onload
Martin is right...
carefully~
@ $db = new mysqli('localhost', 'root', 'password', 'database_table');
On 8/30/05, Richard Hart [EMAIL PROTECTED] wrote:
Hi
I'm new to PHP/MySQL and wondered if anyone on this list would be kind
enough to help me solve
this problem. I'm trying to
To: Bastien Koert; php-db@lists.php.net
Subject: RE: [PHP-DB] Help with. .
Thanks for your help Bastien.
I have changed the authentication procedure but have come up against
another
problem.
This time I am allowing the users to choose their unique usernames and
passwords which
will be stored
='javascript:history.back();'go back/a and try again.;
}
Thanks
Richard
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: 30 August 2005 00:59
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] Help with
you don't have a connection to the db...either because
you don't have a connection to the db...either because the name.password, db
name are wrong or you lack the needed permissions to allow the query...
note that this query is a really back idea...opens the whole db up...better
to provide one connection and allow the users basic read write access
Sorry, the data under 'Looking something like this' should be in a table
format with 3 columns and 4 rows.
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:46 PM
To: PHP
Subject: [PHP-DB] Help Needed
All,
I know this is the wrong distro to
ReClMaples a écrit :
Sorry, the data under 'Looking something like this' should be in a table
format with 3 columns and 4 rows.
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 8:46 PM
To: PHP
Subject: [PHP-DB] Help Needed
All,
I know this
You ROCK!!! Thanks so much, this worked perfectly!!!
Thanks
-Rich
-Original Message-
From: Alain Rivest [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 10:10 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help Needed
ReClMaples a écrit :
Sorry, the data under 'Looking
Ross Honniball wrote:
script1.php:
echo 'script 1 before';
require_once('script2.php');
echo 'script 1 after';
script2.php:
echo 'hello from script 2';
which in IE visually produces:
script 1 beforehello from script 2script 1 after
However if I view the source in IE, I get:
script 1
Perhaps there is an encoding issue in the file(s) that the server is not
recoginizing? Could you post the code you actually use?
Bastien
From: Martin Norland [EMAIL PROTECTED]
Reply-To: php-db@lists.php.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Help. I am losing the plot...
Date
1 - 100 of 334 matches
Mail list logo