RE: [PHP] Problem with MySQL

2007-03-21 Thread Németh Zoltán
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 def

RE: [PHP] Problem with MySQL

2007-03-20 Thread Richard Lynch
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 app

RE: [PHP] Problem with MySQL

2007-03-20 Thread Németh Zoltán
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: > > > > > > SQL Query Sender >

RE: [PHP] Problem with MySQL

2007-03-20 Thread Ford, Mike
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: > > > > SQL Query Sender > > > > > $host=""; > > $user=""; > > $password=""; > > /* Section that execute

Re: [PHP] Problem with MySQL

2007-03-20 Thread Jochem Maas
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

RE: [PHP] Problem with MySQL

2007-03-20 Thread Jim Moseby
> > > > 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_qu

Re: [PHP] Problem with MySQL

2007-03-20 Thread Tijnema !
On 3/20/07, Pavel Kaznarskiy <[EMAIL PROTECTED]> wrote: Hello ! I have problem with access in mysql it is my code: SQL Query Sender {$_POST['database']} Query: $queryResults"; if($result == 0) echo "Error ".mysql_errno().": ".mysql_error(). ""; elseif (@mysql_num_rows($result) == 0) echo("Quer

Re: [PHP] Problem with MySQL

2007-03-20 Thread Németh Zoltán
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: > > SQL Query Sender > > $host=""; > $user=""; > $password=""; > /* Section that executes query */ > if(@$_GET['form'] == "yes") what do you want with that '@'

[PHP] Problem with MySQL

2007-03-20 Thread Pavel Kaznarskiy
Hello ! I have problem with access in mysql it is my code: SQL Query Sender {$_POST['database']} Query: $queryResults"; if($result == 0) echo "Error ".mysql_errno().": ".mysql_error(). ""; elseif (@mysql_num_rows($result) == 0) echo("Query completed. No results returned. "); else { echo " "; fo

[PHP] Problem with MySQL

2005-01-08 Thread Andrew Maxwell
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\bin>mysqld-opt C:\mysql\bin>

RE: [PHP] Problem with MySQL Query

2003-07-23 Thread Chris Kay
IL PROTECTED] Sent: Thursday, 24 July 2003 8:24 AM To: David Nicholson Cc: PHP 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" <

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
dnesday, July 23, 2003 6:19 PM Subject: Re: [PHP] Problem with MySQL Query > 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 = "s

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread David Nicholson
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 me

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Liam Gibbs
> > $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 pu

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
> > $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

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread David Nicholson
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 > Plan

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
gt; 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 > >

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread CPT John W. Holmes
27;"; You don't need quotes around '1' since 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 2

[PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
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 da

[PHP] Problem with mysql versions. help

2003-04-05 Thread NeXaS
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 loga

Re: [PHP] problem with mysql.

2003-04-01 Thread Ryan Vennell
source versions of MySQL, 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:0

Re: [PHP] problem with mysql.

2003-03-31 Thread Tim Burden
; Sent: Monday, March 31, 2003 5:00 PM Subject: 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 inste

RE: [PHP] problem with mysql.

2003-03-31 Thread Ryan Vennell
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

RE: [PHP] problem with mysql.

2003-03-31 Thread Jon Haworth
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:

[PHP] problem with mysql.

2003-03-31 Thread Ryan Vennell
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 t

Re: [PHP] problem with mysql / auto increment fields.. ?

2003-02-19 Thread Justin French
this value will always be unique. period. > > -Chris > > -Original Message- > From: Chad Day [mailto:[EMAIL PROTECTED]] > Sent: Wed 2/19/2003 1:16 PM > To: php general > Cc: > Subject: [PHP] problem with mysql / auto increment fields.. ? > > > >

RE: [PHP] problem with mysql / auto increment fields.. ?

2003-02-19 Thread Chris McCluskey
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

[PHP] problem with mysql / auto increment fields.. ?

2003-02-19 Thread Chad Day
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 t

Re: [PHP] Problem with MySQL

2002-06-14 Thread Chuck \"PUP\" Payne
myrow[title]; > $videoid = $myrow[videoid]; > $catergory = $myrow[catergory]; > $appraisal = $myrow[appraisal]; > > // blah blah blah everything else > } > > Tyler Longren > Captain Jack Communications > www.captainjack.com > [EMAIL PROTECTED] > > - Origi

Re: [PHP] Problem with MySQL

2002-06-14 Thread Tyler Longren
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 databas

[PHP] Problem with MySQL

2002-06-14 Thread Chuck Payne
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 WHER

Re: [PHP] problem with mysql

2002-04-11 Thread Jason Wong
On Thursday 11 April 2002 20:40, Roman Duriancik wrote: > Please send me info : how to set path for *.pid file and ho to set path > where will be mysql.sock in mysql database on linux ? > i want : mysql.sock and localhost.pid in directory /var/lib/mysql > > i install mysql with this command... >

[PHP] problem with mysql

2002-04-11 Thread Roman Duriancik
Please send me info : how to set path for *.pid file and ho to set path where will be mysql.sock in mysql database on linux ? i want : mysql.sock and localhost.pid in directory /var/lib/mysql i install mysql with this command... ./configure --localstatedir=/var/lib/mysql --bindir=/usr/bin --lib

[PHP] problem with mysql persistent connections; already read the FAQ!

2002-03-08 Thread Dustin Puryear
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 s

Re: [PHP] Problem with MySQL String limits?

2001-06-20 Thread David Robley
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

[PHP] Problem with MySQL String limits?

2001-06-19 Thread Null
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', NumComments