At the beginning of the code add following lines
error_reporting(E_ALL);
ini_set('display_error',1);
On Sat, Aug 29, 2009 at 8:28 AM, Keith Davis keithda...@pridedallas.comwrote:
But how are you getting the data from the db?
Does $rowqry represent a call using the mysql_fetch_array()
Is there anything special I have to do to output a mysql date field as
text? When I try to output it nothing appears on the web page.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Devendra Jadhav wrote:
No need to do anything special. It should display date as string. Can
you provide little more information or code snippet?
$tweettable .=
preg_replace('@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.]*(\?\S+)?)?)?)@',
'a href=$1$1/a',$row[TWEET_TEXT]) . br . Sent at: .
John Meyer wrote:
Devendra Jadhav wrote:
No need to do anything special. It should display date as string. Can
you provide little more information or code snippet?
$tweettable .=
preg_replace('@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.]*(\?\S+)?)?)?)@',
'a href=$1$1/a',$row[TWEET_TEXT]) . br .
But how are you getting the data from the db?
Does $rowqry represent a call using the mysql_fetch_array() function?
Sent from my magic iPhone,
Keith Davis 214-906-5183
On Aug 28, 2009, at 7:39 PM, John Meyer
johnme...@pueblocomputing.com wrote:
Devendra Jadhav wrote:
No need to do
Keith Davis wrote:
But how are you getting the data from the db?
Does $rowqry represent a call using the mysql_fetch_array() function?
mysql_fetch_assoc()
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
2007. 03. 21, szerda keltezéssel 00.04-kor Richard Lynch ezt írta:
On Tue, March 20, 2007 11:08 am, Ford, Mike wrote:
what do you want with that '@' here?
that operator can be used to suppress error messages when calling
functions but not when using a variable
This is most definitely way
Hello !
I have problem with access in mysql
it is my code:
html
headtitleSQL Query Sender/title/head
body
?php
$host=;
$user=;
$password=;
/* Section that executes query */
if(@$_GET['form'] == yes)
{
mysql_connect($host,$user,$password);
mysql_select_db($_POST['database']);
$query =
2007. 03. 20, kedd keltezéssel 15.09-kor Pavel Kaznarskiy ezt írta:
Hello !
I have problem with access in mysql
it is my code:
html
headtitleSQL Query Sender/title/head
body
?php
$host=;
$user=;
$password=;
/* Section that executes query */
if(@$_GET['form'] == yes)
what do you want
On 3/20/07, Pavel Kaznarskiy [EMAIL PROTECTED] wrote:
Hello !
I have problem with access in mysql
it is my code:
html
headtitleSQL Query Sender/title/head
body
?php
$host=;
$user=;
$password=;
/* Section that executes query */
if(@$_GET['form'] == yes)
{
mysql_connect($host,$user,$password);
Warning: mysql_select_db(): Access denied for user
'ODBC'@'localhost' (using password: NO) in
z:\home\localhost\www\2.php on line 12
Warning: mysql_select_db(): A link to the server could not
be established in z:\home\localhost\www\2.php on line 12
Warning: mysql_query(): Access
Németh Zoltán wrote:
2007. 03. 20, kedd keltezéssel 15.09-kor Pavel Kaznarskiy ezt írta:
Hello !
...
what do you want with that '@' here?
that operator can be used to suppress error messages when calling
functions but not when using a variable
not true - although it's a lazy/bad* way
On 20 March 2007 13:26, Németh Zoltán wrote:
2007. 03. 20, kedd keltezéssel 15.09-kor Pavel Kaznarskiy ezt írta:
Hello !
I have problem with access in mysql
it is my code:
html
headtitleSQL Query Sender/title/head
body
?php
$host=;
$user=;
$password=;
/* Section that
2007. 03. 20, kedd keltezéssel 16.08-kor Ford, Mike ezt írta:
On 20 March 2007 13:26, Németh Zoltán wrote:
2007. 03. 20, kedd keltezéssel 15.09-kor Pavel Kaznarskiy ezt írta:
Hello !
I have problem with access in mysql
it is my code:
html
headtitleSQL Query
On Tue, March 20, 2007 11:08 am, Ford, Mike wrote:
what do you want with that '@' here?
that operator can be used to suppress error messages when calling
functions but not when using a variable
This is most definitely way wrong.
What complete tosh! @ is a unary operator, so can be applied
Hello,
Im fairly new to PHP and I am running an Apache web server on my
computer, set up as localhost, and i recently installed MySQL 4.1 . I
am having trouble making a DB and a table in the DB. when i try to
create it from a command prompt it tells me this:
C:\mysql\binmysqld-opt
Problem with mySQL Query
This is the query I have:
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and type!=\Meal+Plans\ ;
What I want to do is to select everything from tempuserpurchase that matchs the user
session and the day, so
it's an integer, but MySQL is
forgiving.
---John Holmes...
- Original Message -
From: Phillip Blancher [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 5:08 PM
Subject: [PHP] Problem with MySQL Query
Problem with mySQL Query
This is the query I have
Subject: [PHP] Problem with MySQL Query
Problem with mySQL Query
This is the query I have:
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type!=\Meal+Plans\
;
What I want to do is to select everything from tempuserpurchase that
matchs
Hello,
This is a reply to an e-mail that you wrote on Wed, 23 Jul 2003 at
22:28, lines prefixed by '' were originally written by you.
As per your suggestion
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=$User_Shopping_Id) and day=1 and
type!='Meal
Plans'
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type'Meal Plans'
Tryed both methods and it is still not excluding anything matching Meal
Plans
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
$dbqueryshipping1 = select * from tempuserpurchase where
(usersessionid=\$User_Shopping_Id\) and day=\1\ and
type'Meal Plans'
Tryed both methods and it is still not excluding anything matching Meal
Plans
Been a short while since I used SQL with my PHP, but try putting NOT instead
Hello,
This is a reply to an e-mail that you wrote on Wed, 23 Jul 2003 at
22:54, lines prefixed by '' were originally written by you.
$dbqueryshipping1 = select * from tempuserpurchase
where
(usersessionid=$User_Shopping_Id) and day=1 and
type'Meal Plans'
Tryed both methods and it
Tried NOT LIKE and that didnt exclude it either.
I am trying to exclude only 'Meal Plans'
Phil
- Original Message -
From: David Nicholson [EMAIL PROTECTED]
To: Phillip Blancher [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 6:19 PM
Subject: Re: [PHP] Problem
List
Subject: Re: [PHP] Problem with MySQL Query
Tried NOT LIKE and that didnt exclude it either.
I am trying to exclude only 'Meal Plans'
Phil
- Original Message -
From: David Nicholson [EMAIL PROTECTED]
To: Phillip Blancher [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July
Hello, I wrote the code for deleting the oldest string in the mysql if
it reaches over 15 strings, but it works only under 4.x.x series of MySQL and i have
3.x.x. What should I change in the code that it would work under 3.x.x
version of MySQL? Here`s the code:
$quer = SELECT COUNT(id) FROM
, in that
case, use
--with-mysql=/usr/local
- Original Message -
From: Jon Haworth [EMAIL PROTECTED]
Newsgroups: php.general
To: Ryan Vennell [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 5:00 PM
Subject: RE: [PHP] problem with mysql.
Hi Ryan,
when configuring php i use
ok i've reinstalled phpseveral times now, reinstalled mysql, and even reinstalled
apache once but i am still getting this same problem.
when configuring php i use --with-mysql and it configures just fine. i've even added
an =/path/to/php after it to no avail.
i keep getting this on pages
Hi Ryan,
when configuring php i use --with-mysql and it configures just
fine. i've even added an =/path/to/php after it to no avail.
Try --with-mysql=/path/to/mysql instead of --with-mysql=/path/to/php.
Cheers
Jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Sorry about that. i did use /path/to/mysql. i wasnt paying attention when writing my
pervious post.
-Ryan
Jon Haworth[EMAIL PROTECTED] 03/31/03 04:00PM
Hi Ryan,
when configuring php i use --with-mysql and it configures just
fine. i've even added an =/path/to/php after it to no avail.
: RE: [PHP] problem with mysql.
Hi Ryan,
when configuring php i use --with-mysql and it configures just
fine. i've even added an =/path/to/php after it to no avail.
Try --with-mysql=/path/to/mysql instead of --with-mysql=/path/to/php.
Cheers
Jon
--
PHP General Mailing List (http
On my website there are a couple places where people can sign up ..
The querys after the sign up process look like
$blahblah = query(insert firstname lastname) values (blah blah blah)
$userid = mysql_insert_id($blahblah);
$insertintoothertable = query(userid, blah blah blah) etc.
it then uses
To: php general
Cc:
Subject: [PHP] problem with mysql / auto increment fields.. ?
On my website there are a couple places where people can sign up ..
The querys after the sign up process look like
$blahblah
]]
Sent: Wed 2/19/2003 1:16 PM
To: php general
Cc:
Subject: [PHP] problem with mysql / auto increment fields.. ?
On my website there are a couple places where people can sign up ..
The querys after the sign up process look like
$blahblah = query(insert firstname lastname) values
I'm stuck. I have been to the MySQL lists for this.
Now I'm reconsidering my PHP code.
http://ccl.flsh.usherb.ca/print/display.table.inc.phps
I just don't know where I'm going wrong anymore.
If I run this SQL in PHPMyAdmin, it works. jdaxell.ccl should have one
entry for ready maria.
SELECT
On Mon, 2 Dec 2002, jtjohnston wrote:
SELECT id,AU,ST,BT,AT FROM jdaxell.ccl WHERE MATCH
(TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST
('ready maria' IN BOOLEAN MODE) ORDER
BY id asc
When I run the same (copied and pasted) SQL in PHP, it is as though
MySQL is doing a
Chris, or anyone,
I have tried to escape the slashes. Debugging ...
$sql = 'SELECT ... ...
AGAINST (\'ready maria\' IN BOOLEAN MODE) ...';
This works. But if I addslashes or stripslashes, or do nothing, it does not
work.
See these 3 variations. Neither work. What should I do? A part from hang
Hi,
I am working on a movie database I have two database that I am calling from
but the problem I am having when I ask it to go and fetch all the movies
with the same title, it stops and only shows one.
Here is a basic layout...
if($videoid) {
$result = mysql_query(SELECT * FROM library
www.captainjack.com
[EMAIL PROTECTED]
- Original Message -
From: Chuck Payne [EMAIL PROTECTED]
To: PHP General [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 11:03 PM
Subject: [PHP] Problem with MySQL
Hi,
I am working on a movie database I have two database that I am calling from
but the problem
else
}
Tyler Longren
Captain Jack Communications
www.captainjack.com
[EMAIL PROTECTED]
- Original Message -
From: Chuck Payne [EMAIL PROTECTED]
To: PHP General [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 11:03 PM
Subject: [PHP] Problem with MySQL
Hi,
I am working
We are running Apache 1.3.20 with PHP 4.0.6/rfc1876-patch built as a
module. We are using PHP on a load-sharing cluster with n web servers.
Our cluster supports an application that makes extensive use of mysql
connections via the PHP mysql_* functions.
The application was tested on a single web
first, u have to install the mysql. :-)
and u have to know your mysql password...
maybe you can try this...
$connection=mysql_query(localhost,root,);
if ($connection) {
echo brConnection to mysql Good;
} else {
echo brConnection to mysql Failed;
}
hope this can help u..
Rio Uniwaly
Hello,
I have installed php4 rpm in my machine.while connecting php with
mysql it is giving fatal error.I have given like this
mysql_connect($servername,$username,$password);
Why it is so ..
Is there any other files i have to install to access the database??
Regards,
Uma
--
What was the error message given? Are you sure that mysql is running and
working properly?
Jeff
Hello,
I have installed php4 rpm in my machine.while connecting php with
mysql it is giving fatal error.I have given like this
mysql_connect($servername,$username,$password);
Why it is
Hello,
I have installed php4 rpm in my machine.while connecting php with
mysql it is giving fatal error.I have given like this
mysql_connect($servername,$username,$password);
Why it is so ..
Is there any other files i have to install to access the database??
Regards,
Uma
--
On Fri, 22 Jun 2001 19:52, Null wrote:
In a script I have an update query adding on to a LONGTEXT field in my
database. Strangely it will no longer work after seemingly random
string lengths. So far, one row stopped adding at 440 bytes and another
at 1049 bytes.
mysql_query(UPDATE dod_news
In a script I have an update query adding on to a
LONGTEXT field in my database. Strangely it will no longer work after seemingly
random string lengths. So far, one row stopped adding at 440 bytes and another
at 1049 bytes.
mysql_query("UPDATE dod_news SET
Comments='$comments',
47 matches
Mail list logo
