On Tue, 13 Mar 2012 21:23:57 +0530, Gu®u 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 is empty echo out only t
On Tue, 13 Mar 2012 17:33:43 +0530, Gu®u 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.
plugin->ListViewValue()=="")
{
echo '';
}
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=="")
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u 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 is empty echo out o
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 f
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 faceb
>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
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u 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
$search->plugin->ListViewValue()=="" and
$sea
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 wrote:
> On Tue, Mar 13, 2012 at 1:03 PM, Gu®u wrote:
> > Hi,
> >
> > Please help me with this code. I have 2 different fields in mysql table.
> > What I want is if the fi
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u 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 wrong, what it outputs
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
wrote:
> 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 gr
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 wrote:
> Hehe. Then a method: ) just make a query builder method like 'findS
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
that'
DB is like more then 500MB
and it will grow day by day :)
On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont wrote:
> If the DB is very small use tablesorter plugin of jquery. Otherwise
> custumizable query method.
>
> On 17 May 2010 07:56, "nagendra prasad" wrote:
>
> Hi All,
>
> I have a datab
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
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.
>
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
different
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.
All
Abah Joseph wrote:
> I just saw something on pear.net
> http://pear.php.net/package/Services_Facebookmaybe it will work.
hi,
possible better is to have a look into the plattform
http://www.phpclasses.org. Maybe you find a class that doesn't based on
pear.
Regards,
Ruprecht
-
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 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 their faceb
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 facebook/
l1.field3
hth,
Yves
- Original Message -
From: "Yves Sucaet"
To:
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 field
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
(
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 checki
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
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
>> Incidents.id=Calls
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 Ma
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 un
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
>
reen Laghari" <[EMAIL PROTECTED]>Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Help in concatenation
1.
0?("?start=").$y:""));?>">
2. 0?("?start=").$next:""));?>"><<
turns into:
> $string = '' . $pg .
1.
0?("?start=").$y:""));?>">
2. 0?("?start=").$next:""));?>"><<
turns into:
> $string = '' . $pg . '';
> ?>
> $string2 = '';
> ?>
I can squeeze the if operation into the string but I can't see good cause
for this (this is less spageti this way)
On 06/06/2008, Nasreen Laghari <[EMAIL P
TED]
> Sent: Thu, 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
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 (h
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
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 * FR
> To: J. Hill; php-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
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 W
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) O
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
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 P
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 on
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 th
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
>
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 Tab
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 numb
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
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 qu
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 * S
- 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 un
NOT QUITE..ups.. my bad
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Suprie" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, March 29, 2007 6:53 AM
Subject: Re: [PHP-DB] help in database design
> Suprie wrote:
> > hi all,
> >
>
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 ordere
what is site mean in here??
- Original Message -
From: "Suprie" <[EMAIL PROTECTED]>
To:
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 list of items,
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 successf
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 ph
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 ar
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 th
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 b
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 th
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 ha
Stut wrote:
Tim McGeary wrote:
Oh, duh! Ok. I wrote this:
mysql_connect($hostname, $username, $password) or
die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT * FROM Requestor_type") or
die(mysql_error());
Tim McGeary wrote:
Oh, duh! Ok. I wrote this:
mysql_connect($hostname, $username, $password) or
die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$result = mysql_query("SELECT * FROM Requestor_type") or
die(mysql_error());
while($row = my
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(): Can'
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 er
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
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 '/var/
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 '/var/lib/mysql/mys
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| fin
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
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:
Subject: [PHP-DB] Help Needed!!
Date: Wed, 8
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.
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: php-db@
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: php-db@lists.php.net
Subject: [PHP-DB] Help displaying Column
Hi,
Thanks a lot,
That exactly wat I need
:)
Suad
Chris wrote:
suad wrote:
Hi,
I need some help in sql - postgresql:
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
suad wrote:
Hi,
I need some help in sql - postgresql:
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 be:
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
ot;, $data;
>
> When the file is saved, it begins with 0a followed by TEST TEXT and then
> the start of the file without another instance of 0a.
>
> Mickey
>
>
> -Original Message-
> From: Oskar [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 24, 2006 1:5
ith 0a followed by TEST TEXT and then the
start of the file without another instance of 0a.
Mickey
-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
Mick
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 somet
f
-Original Message-
From: 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
t: Tuesday, 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]&
Here's the code I'm using to upload if it helps:
";
echo "Continue";
}
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.ne
hp-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: [PHP-DB] help
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
:
You know bob who knows 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
t;- 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 TA
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));
You have friends!!";
while ($f = mysql_fetch_assoc($friends)) {
echo "{$f['
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
('$t
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) ORDE
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 $$righ
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
Because, if say, $myrow['article_title'] contained value "article1",
$$right_row would look for variable
$article1, which probably doesn't exist, hence n
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 application/x-httpd-ph
Anyone have any input? I am googling till my fingers hurt and everything I
find says it should be running. Whenever I try to open a test.php file all I
get is the web browswer trying to save the file instead of serving up the php
content.
On Friday 10 February 2006 21:28, CasperLinux wrote:
>
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 rep
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 s
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 autom
e-
From: Richard Hart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:06 PM
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
ully logged on.';
}
else {
echo "Your username and/or password have not been accepted. Please go back 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.ph
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
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 '
1 - 100 of 387 matches
Mail list logo