Re: [PHP] mysql error

2011-05-10 Thread xianhua zhou
Hi Grega, Probably you wanna define a primary key, if so, then change from uniqueid to primary key. 2011/5/6 Curtis Maurand cur...@maurand.com: engine= --C Grega Leskovšek wrote: Can smbd please look  at this sentence - I got an error and do not know how to fix it - I am still very

Re: [PHP] mysql error

2011-05-06 Thread Curtis Maurand
engine= --C Grega Leskov¹ek wrote: Can smbd please look at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30),

[PHP] mysql error

2011-05-05 Thread Grega Leskovšek
Can smbd please look at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2),

Re: [PHP] mysql error

2011-05-05 Thread Andre Polykanine
: Grega Leskovšek legr...@gmail.com To: php-general Date created: , 5:29:44 PM Subject: [PHP] mysql error Can smbd please look at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log ( idlog int auto_increment not null

Re: [PHP] mysql error

2011-05-05 Thread Daniel Brown
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote: Can smbd please look  at this sentence - I got an error and do not know how to fix it - I am still very unfamiliar with MYSQL: CREATE TABLE log (  idlog int auto_increment not null,  imepriimek varchar(50),  clock

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Rahul P
Ok. I apologize for the mix. When I'm mailing someone, I simply don't get Google into mind. :) Thanks, Rahul On Sun, May 11, 2008 at 12:53 AM, Nathan Nobbe [EMAIL PROTECTED] wrote: On Sun, May 11, 2008 at 1:46 AM, Rahul P [EMAIL PROTECTED] wrote: Ok I removed mysql using yum remove mysql.

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Nathan Nobbe
On Sun, May 11, 2008 at 1:59 AM, Rahul P [EMAIL PROTECTED] wrote: Ok. I apologize for the mix. When I'm mailing someone, I simply don't get Google into mind. :) no problem, if it were emerge id be much more capable of helping ;) -nathan

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-11 Thread Shawn McKenzie
Rahul P wrote: Ok I removed mysql using yum remove mysql. But is there a special way to tell yum to install that version of mysql? On Sun, May 11, 2008 at 12:44 AM, Rahul P [EMAIL PROTECTED] wrote: On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED] wrote: On Sun, May 11, 2008

[PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Rahul
I am using Fedora Core 4. As I was unable to use PHP or MySQL together, I uninstalled both of them and installed again using the following commands: yum install mysql And then apt-get install php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc curl

[PHP] Re: PHP-MYSQL Error: Can't connect to MySQL socket. Can someone helpme out please?

2008-05-10 Thread Rahul
By the way it installed MySQL 6 and PHP 5.0.4 and from the console this command does not work: mysql -u root -p but only this works: mysql -h hostname -u root -p I tried doing the same while connecting to the database via php but it does not work. Rahul wrote: I am using Fedora Core 4. As

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 12:30 AM, Rahul [EMAIL PROTECTED] wrote: I am using Fedora Core 4. As I was unable to use PHP or MySQL together, I uninstalled both of them and installed again using the following commands: yum install mysql And then apt-get install php php-devel php-gd php-imap

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Rahul
Thanks a lot for your reply. I have tried using $host = localhost; $db = dbname; $table_main = tablename; $dbusername = root; $dbpass = passhere; mysql_connect($host, $dbusername, $dbpass) or die(mysql_error()); and $host = mycomputer.webaddress.com; $db = dbname; $table_main = tablename;

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someone help me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 12:42 AM, Rahul [EMAIL PROTECTED] wrote: Thanks a lot for your reply. I have tried using $host = localhost; $db = dbname; $table_main = tablename; $dbusername = root; $dbpass = passhere; mysql_connect($host, $dbusername, $dbpass) or die(mysql_error()); and

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Rahul
I have recorded both the errors by changing the variable: $host = mycomputer.webaddress.com PHP Warning: mysql_connect(): Lost connection to MySQL server during query in /export/home/rpo219/may/conf_global.php on line 18 Lost connection to MySQL server during query $host = localhost PHP

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 1:05 AM, Rahul [EMAIL PROTECTED] wrote: I have recorded both the errors by changing the variable: $host = mycomputer.webaddress.com PHP Warning: mysql_connect(): Lost connection to MySQL server during query in /export/home/rpo219/may/conf_global.php on line 18 Lost

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Rahul P
Thanks. I just stopped mysql and when I try to start it again it throws another set of errors: chown: changing ownership of `/home-public/mysql6': Operation not permitted So I guess something is messed up completely. I wish I installed it better. Now the installing is messed up I guess with all

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 1:22 AM, Rahul P [EMAIL PROTECTED] wrote: Thanks. I just stopped mysql and when I try to start it again it throws another set of errors: chown: changing ownership of `/home-public/mysql6': Operation not permitted So I guess something is messed up completely. I wish I

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Rahul P
Oh... This is the fourth time I'm doing that except that this time yum installed mysql6 instead of older versions... I don't see any way out other than reinstalling the OS itself... There are so many dependency failures I'm spending more time troubleshooting than actually coding something :)

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 1:29 AM, Rahul P [EMAIL PROTECTED] wrote: Oh... This is the fourth time I'm doing that except that this time yum installed mysql6 instead of older versions... I don't see any way out other than reinstalling the OS itself... There are so many dependency failures I'm

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Rahul P
On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED] wrote: On Sun, May 11, 2008 at 1:29 AM, Rahul P [EMAIL PROTECTED] wrote: Oh... This is the fourth time I'm doing that except that this time yum installed mysql6 instead of older versions... I don't see any way out other than

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Rahul P
Ok I removed mysql using yum remove mysql. But is there a special way to tell yum to install that version of mysql? On Sun, May 11, 2008 at 12:44 AM, Rahul P [EMAIL PROTECTED] wrote: On Sun, May 11, 2008 at 12:42 AM, Nathan Nobbe [EMAIL PROTECTED] wrote: On Sun, May 11, 2008 at 1:29 AM,

Re: [PHP] PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

2008-05-10 Thread Nathan Nobbe
On Sun, May 11, 2008 at 1:46 AM, Rahul P [EMAIL PROTECTED] wrote: Ok I removed mysql using yum remove mysql. But is there a special way to tell yum to install that version of mysql? ahh, this is where google comes in for sure. it looks like you could download an older rpm, like from mysql

[PHP] MySQL error

2005-07-01 Thread Wessley Roche
Hi, I'm having a problem with the following code: $sql = LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE `mytable` FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\n'; mysql_query($sql) or die('brbr'.mysql_error()); I get this MySQL error: You have an error in your SQL

Re: [PHP] MySQL error

2005-07-01 Thread Richard Davey
Hello Wessley, Friday, July 1, 2005, 10:55:16 AM, you wrote: WR $sql = LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE WR `mytable` FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED WR BY '\n'; WR mysql_query($sql) or die('brbr'.mysql_error()); WR I get this MySQL error: WR You

Re: [PHP] mysql error

2005-04-02 Thread Burhan Khalid
Mikey wrote: I have not changed any of my hostname/username/password code in the last 6 months and I can still connect to mysql.timerescue.co.uk via the command line interface. Has anyone seen this before - any ideas at all - just started happening today! :o( Strange indeed. I tried to

[PHP] mysql error

2005-04-01 Thread Glen Beamson
Hi, I have suddenly started getting an 'unknown host' error when trying to connect via php (see below). Unknown MySQL Server Host 'mysql.timerescue.co.uk' (0)2005 I have not changed any of my hostname/username/password code in the last 6 months and I can still connect to

Re: [PHP] mysql error

2005-04-01 Thread Angelo Zanetti
it cant find your host mysql.timerescue.co.uk try use an ip address... or try connect via the command line. Glen Beamson wrote: Hi, I have suddenly started getting an 'unknown host' error when trying to connect via php (see below). Unknown MySQL Server Host 'mysql.timerescue.co.uk' (0)2005 I

RE: [PHP] mysql error

2005-04-01 Thread Mikey
I have not changed any of my hostname/username/password code in the last 6 months and I can still connect to mysql.timerescue.co.uk via the command line interface. Has anyone seen this before - any ideas at all - just started happening today! :o( Strange indeed. I tried to connect

FW: [PHP] mysql error

2005-04-01 Thread Mikey
Oooops! My mistake, I had a typo in my config file - it connects just fine either way... -Original Message- From: Mikey [mailto:[EMAIL PROTECTED] Sent: 01 April 2005 13:16 To: 'php-general@lists.php.net' Subject: RE: [PHP] mysql error I have not changed any of my hostname

[PHP] MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary

[PHP] mysql error

2004-12-05 Thread Richard Kurth
Could somebody tell me way these query gets a error 1064 and does not work. error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM listing WHERE `state` = 'WA' AND `type` = 'RES' query=SELECT *

Re: [PHP] mysql error

2004-12-05 Thread Ligaya Turmelle
query=SELECT * FROM listing WHERE `state` = 'WA' AND `type` = 'RES' AND `county` = 'clark' AND (`price` '15' OR `price` = '20');; if that doesn't work - break it down into individual parts and find out where the problem is. Respectfully, Ligaya Turmelle --- Life is a game... so have

Re: [PHP] mysql error

2004-12-05 Thread Raditha Dissanayake
Richard Kurth wrote: Could somebody tell me way these query gets a error 1064 and does not work. no. wrong list. -- Raditha Dissanayake. -- http://www.radinks.com/print/card-designer/ | Card Designer Applet

Re: [PHP] mysql error

2004-12-05 Thread Travis Conway
also dont think that the back tick works. HTH Travis - Original Message - From: Richard Kurth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 05, 2004 3:05 PM Subject: [PHP] mysql error Could somebody tell me way these query gets a error 1064 and does not work. error=You

Re: [PHP] mysql error

2004-12-05 Thread Raditha Dissanayake
Travis Conway wrote: Try: SELECT * FROM listing WHERE listing.state = 'WA' AND listing.type = 'RES' AND listing.county = 'clark' AND (listing.price 15 OR listing.price =20) Once again you have posted to the wrong list. Please send this message to the mysql list. This is the php list.

[PHP] Php/mysql error....why?

2003-10-24 Thread Ryan A
Hi, I am running a very simple query to the database, basically select all the firms which start with 0-9, eg. 1stcompany 3isgood etc using this: $qry = select cust_no,firm from companies where firm LIKE `%0123456789%'; It gives me this error: Error: Unknown column '0123456789%'' in 'where

RE: [PHP] Php/mysql error....why?

2003-10-24 Thread Dan Joseph
`%0123456789%'; You have a ` instead a ' before the %0123. I believe that is what is causing your grief. -Dan Joseph -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Php/mysql error....why?

2003-10-24 Thread Tom Rogers
Hi, Saturday, October 25, 2003, 2:50:46 AM, you wrote: RA Hi, RA I am running a very simple query to the database, basically select all the RA firms which start with 0-9, RA eg. RA 1stcompany RA 3isgood RA etc RA using this: RA $qry = select cust_no,firm from companies where firm LIKE

[PHP] RE: PHP Mysql Error Code 1062 - Duplicates found

2003-06-26 Thread Ow Mun Heng
: PHP Mysql Error Code 1062 - Duplicates found Hi PHP'ers, I've got a question regarding the input of (multiple) data into mysql through PHP. If there is already an entry in the database, then an mysql will generate an error 1062 stating that the entry is a duplicate

[PHP] PHP Mysql Error Code 1062 - Duplicates found

2003-06-24 Thread Ow Mun Heng
Hi PHP'ers, I've got a question regarding the input of (multiple) data into mysql through PHP. If there is already an entry in the database, then an mysql will generate an error 1062 stating that the entry is a duplicate. (This will happen only if I input the data through mySQL

Re: [PHP] PHP Mysql Error Code 1062 - Duplicates found

2003-06-24 Thread Jeff Harris
On Jun 25, 2003, Ow Mun Heng claimed that: |Hi PHP'ers, | | I've got a question regarding the input of (multiple) data into |mysql through PHP. | |If there is already an entry in the database, then an mysql will generate an |error 1062 stating that the entry is a duplicate. (This will

[PHP] mysql error messages

2003-06-16 Thread Thomas Hochstetter
Hi. I have parsed the txt file and put it on my site . it's kinda ugly and messy, but maybe it helps someone. http://www.thomash.co.za/docs/errmsg.php T

[PHP] MySQL error

2002-12-12 Thread GWAD Mailinglist
Hi, I have following problem: list.php3 ? // connect to db include(connect_db.php3); // get everything from catalog table $query = SELECT * FROM yritykset ORDER BY ynimi ASC; $mysql_result = mysql_query($query, $mysql_link); // get each row

Re: [PHP] MySQL error

2002-12-12 Thread Brad Bonkoski
Well, are you getting a valied response from the database? Perhaps it would be nice to add some error handling into your code... i.e.: $mysql_result = mysql_query($query, $mysql_link) or die(Invalid query: $query); or echo out mysql_error(); GWAD Mailinglist wrote: Hi, I have following

RE: [PHP] MySQL error

2002-12-12 Thread Craig Thomas
= mysql_fetch_row($mysql_result)) Anyway, where do you define $row? HTH -Craig -Original Message- From: GWAD Mailinglist [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 6:01 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL error Hi, I have following problem: list.php3

Re: [PHP] MySQL error

2002-12-12 Thread Philip Olson
You need to do some error handling, as in: $mysql_result = mysql_query($query, $mysql_link); // get each row -- line 36 while($row = mysql_fetch_row($mysql_result)) Make sure $mysql_result is a valid resource as PHP is telling you it's not. Here's one way: if

RE: [PHP] MySQL error

2002-12-12 Thread Craig Thomas
-- line 36 while($row = mysql_fetch_row($mysql_result)) Anyway, where do you define $row? HTH -Craig DOH! it's been a long one... -Craig -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] MySQL Error

2002-12-01 Thread Stephen
Hello, I just recently switched to IIS from Apache since IIS came with Windows XP and I just love Microsoft. I installed PHP and MySQL with no problems but when I tried accessing a table, I got this error: No Database Selected In my script, I have this: $hostname_default = localhost;

Re: [PHP] MySQL Error

2002-12-01 Thread Brad Bonkoski
Perhaps you should try and do some error checking on the mysql_select_db() function, like printing out mysql_error(). Also, for the permissions issues, mysql has a very comprehensive online documentation on user permissions. Check them out, you may also wish to try and connect to the database

Re: [PHP] MySQL Error

2002-12-01 Thread Stephen
I did that and it didn't output anything... - Original Message - From: Brad Bonkoski [EMAIL PROTECTED] To: Stephen [EMAIL PROTECTED] Cc: PHP List [EMAIL PROTECTED] Sent: Sunday, December 01, 2002 2:55 PM Subject: Re: [PHP] MySQL Error Perhaps you should try and do some error checking

[PHP] php mysql error

2002-09-04 Thread ROBERT MCPEAK
Our box recently went down and after reconfiguring it we're left with a semi-operation mySQL. One error I'm getting is this: mysql select region from clip_art where region is not null and released = 'yes' group by region; ERROR 1: Can't create/write to file '/tmp/#sqld0e_76_1.MYI' (Errcode: 13)

Re: [PHP] php mysql error

2002-09-04 Thread Adam Williams
whats the permissions on /tmp? it should be set to 1777 Adam On Wed, 4 Sep 2002, ROBERT MCPEAK wrote: Our box recently went down and after reconfiguring it we're left with a semi-operation mySQL. One error I'm getting is this: mysql select region from clip_art

RE: [PHP] php mysql error

2002-09-04 Thread Jay Blanchard
[snip] Our box recently went down and after reconfiguring it we're left with a semi-operation mySQL. One error I'm getting is this: mysql select region from clip_art where region is not null and released = 'yes' group by region; ERROR 1: Can't create/write to file '/tmp/#sqld0e_76_1.MYI'

Re: [PHP] php mysql error

2002-09-04 Thread Marek Kilimajer
Check file and drectory permisions. ROBERT MCPEAK wrote: Our box recently went down and after reconfiguring it we're left with a semi-operation mySQL. One error I'm getting is this: mysql select region from clip_art where region is not null and released = 'yes' group by region; ERROR 1: Can't

[PHP] mysql error

2002-08-13 Thread victor
I get this error: Error submiting paragraph.You have an error in your SQL syntax near 'WHERE page_name='features' AND par_id='13' ' at line 1 But my code, I think is fine: // Insert the form information into the database mysql_query(INSERT INTO malibu_data SET heading='$heading',

Re: [PHP] mysql error

2002-08-13 Thread @ Edwin
Looks like you're updating your table so instead of "INSERT INTO...", try: "UPDATE malibu_data SET ..." HTH, - E I get this error: Error submiting paragraph.You have an error in your SQL syntax near 'WHERE page_name='features' AND par_id='13' ' at line 1 But my code, I think is fine: //

Re: [PHP] mysql error

2002-08-13 Thread Brad Bulger
it's the WHERE clause, it's illegal there. what are you trying to do? if you want to change the heading paragraph columns of every row in malibu_data where the page_name par_id match your values, this should be an UPDATE. if you want to create a new record in malibu_data for every record

RE: [PHP] mysql error

2002-08-13 Thread victor
Yes, thank you very much, I shouldn$B!G(Bt code late at night without any caffeine in me. - Vic -Original Message- From: @ Edwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 12:29 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql error Looks like

[PHP] PHP/MySQL Error Log Parser

2002-08-04 Thread Paul Maine
How can I set up MySQL error logging? Is there any PHP MySQL error log parsers? Thank You -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mysql error or PHP

2002-07-15 Thread Wilbert Enserink
Hi all, has anybody ever seen this? And knows what it means? thx. You have an error in your SQL syntax near 's self-supporting ribbed form was probably not strong enough to render the desig' at line 1 regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den

Re: [PHP] mysql error or PHP

2002-07-15 Thread Justin French
try add_slashes($string) before inserting into the database, or turn on magic quotes in php.ini justin french on 15/07/02 5:57 PM, Wilbert Enserink ([EMAIL PROTECTED]) wrote: Hi all, has anybody ever seen this? And knows what it means? thx. You have an error in your SQL syntax near

Re: [PHP] mysql error or PHP

2002-07-15 Thread Johan Holst Nielsen
Justin French wrote: try add_slashes($string) before inserting into the database, or turn on magic quotes in php.ini Or Mysql_Escape_String() http://www.php.net/manual/en/function.mysql-escape-string.php Or Mysql_Real_Escape_String()

[PHP] mysql error

2002-05-17 Thread Randum Ian
Hi all, I have got this code but I can get it to work, it doesnt make sense! snip ?php $host=localhost; $username=user; $password=pass; $database=admin; $mysqlconnect = mysql_connect($host, $username, $password) or die (Cannot connect to mySQL server, check it is running);

Re: [PHP] mysql error

2002-05-17 Thread Kevin Stone
giving you the error. Use like this.. $db = mysql_select_db(); mysql_query($query, $db); -Kevin - Original Message - From: Randum Ian [EMAIL PROTECTED] To: PHP [EMAIL PROTECTED] Sent: Friday, May 17, 2002 11:45 AM Subject: [PHP] mysql error Hi all, I have got this code but I can get

[PHP] MYSQL ERROR CONNECT

2002-05-06 Thread Dani
Hi, I have been using this code for while: //1. CONNECT TO DATABASE mysql_connect(localhost); //2. SELECT A DATABASE mysql_select_db(smpk2); to connect to MYSQL database. but I get this error: Warning: Access denied for user: 'nobody@localhost' (Using password: NO) in

Re: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread The_RadiX
] : ABN: 64 235 749 494 : QUT Student #: 04475739 ::: - Original Message - From: Dani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:49 PM Subject: [PHP] MYSQL ERROR CONNECT Hi, I have been using this code for while: //1

Re: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread Dani
] To: [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:49 PM Subject: [PHP] MYSQL ERROR CONNECT Hi, I have been using this code for while: //1. CONNECT TO DATABASE mysql_connect(localhost); //2. SELECT A DATABASE mysql_select_db(smpk2); to connect to MYSQL database. but I

RE: [PHP] MYSQL ERROR CONNECT

2002-05-06 Thread John Holmes
Warning: Access denied for user: 'nobody@localhost' (Using password: NO) in /www/host/doms/com/smpk2/create_tables.php on line 15 Hmm...let me see if I can decrypt that message. Apparently you were denied access with user nobody and you were not using a password. Read the manual page on

Re: [PHP] MySQL error checking/matching

2002-02-17 Thread Matt
- Original Message - From: Navid Yar [EMAIL PROTECTED] $query = select email from customers // Check for duplicate entry . where email = $email; $query = stripslashes($query); $result = mysql_query($query); $num_results = mysql_num_rows($result); // Get the number of rows in

[PHP] MySQL error checking/matching

2002-02-16 Thread Navid Yar
Hello everyone, I have a problem. I have a test database (used to learn MySQL) with a table called customers and a field called email. The email field is set to be unique, so I know that by using: $query = select email from customers where email = $email; I will get one cell with the e-mail

[PHP] MySQL error... but it works!!??

2002-01-05 Thread Simon Kimber
Does anyone have any idea why this is giving me a Warning: Supplied argument is not a valid MySQL result resource in... error? The funny thing is that apart from that error message it works perfectly!! --- $crdate = date(Y-m-d); $result = mysql_query(SELECT * FROM sites

Re: [PHP] MySQL error... but it works!!??

2002-01-05 Thread Adam Baratz
Does anyone have any idea why this is giving me a Warning: Supplied argument is not a valid MySQL result resource in... error? You'll have to give more code, which line you get that error from, etc., to give us a better idea why it's not working. However, a quick tip: $crdate = date(Y-m-d);

Fw: [PHP] MySQL error... but it works!!??

2002-01-05 Thread Adam Baratz
- Original Message - From: Bas van Rooijen [EMAIL PROTECTED] To: Adam Baratz [EMAIL PROTECTED] Sent: Saturday, January 05, 2002 4:39 PM Subject: Re: [PHP] MySQL error... but it works!!?? maybe try: if (!$result) { echo(mysql_error()); } bvr. On Sat, 5 Jan 2002 15:55:39

Re: [PHP] MySQL error... but it works!!??

2002-01-05 Thread Mehmet Kamil ERISEN
Hi, So far the best way to troubleshoot mysql+php for me has been to add an or die after the sql exec. $crdate = date(Y-m-d); $result = mysql_query(SELECT * FROM sites WHERE creation_date = '$crdate' AND status = 'T') or die ('CAN NOT EXEC SQL'); Or you can do $sql = SELECT * FROM sites

[PHP] MySql error

2001-11-29 Thread Carlos Gutiérrez
Hi ! I made the upgrade of MySQL, since 3.21 to 3.23, and, inmediatly this change, all perl programs that uses MySQL write at the STDERR, this bug SV = RV(0x84ec388) at 0xb2f0 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x8552d3c I've installed: DBD::mysql 2.0902 DBI 1.20 DBI::DBD 11.02

[PHP] PHP/Mysql error handling

2001-11-04 Thread George E. Papadakis
Hi, Is there any way to make php notify me of any errors through email? I know it may sounds funny, but imagine having this huge site and u just want it to run smoothly but u juct cant check it all the time . If there was a way that php would notify u for a an error on a specific page/line that

[PHP] mysql error on win2k

2001-09-21 Thread sagar N Chand
hi, i have installed win2k and configured apache and php4.0.6 but mysql is giving error 1016 or so. why is this happening. /sagar

[PHP] MySQL Error.

2001-08-17 Thread ERISEN, Mehmet Kamil
Hello All, I receive the following warning message. When I reload the page, the message is the error message does not show up again. Funny thing is, that there are other parts of the page generated from the same database using the same mysql_pconnect and they are fine. I am using a standard

Re: [PHP] MySQL Error.

2001-08-17 Thread David Robley
On Fri, 17 Aug 2001 16:49, ERISEN, Mehmet Kamil wrote: Hello All, I receive the following warning message. When I reload the page, the message is the error message does not show up again. Funny thing is, that there are other parts of the page generated from the same database using the same

RE: [PHP]MySQL error, what's wrong here..

2001-07-24 Thread Tim Ward
] Subject: [PHP]MySQL error, what's wrong here.. ?php $id = rand(1,2); $query = SELECT songname FROM mp3 WHERE sgid = .$id; $result = mysql_query($query,$connection); $mp3d = mysql_fetch_array($result); ? the server is telling me line 43(which starts with $mp3d) is not a valid

Re: [PHP]MySQL error, what's wrong here..

2001-07-24 Thread Wagner Tomy
] To: [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 11:05 AM Subject: Re: [PHP]MySQL error, what's wrong here.. Hi Chris, If you're using MySQL 3.23+, you might want to consider using something like: SELECT songname FROM mp3 ORDER BY RAND() LIMIT 1 Not that this answers your original

[PHP]MySQL error, what's wrong here..

2001-07-23 Thread Chris Cocuzzo
?php $id = rand(1,2); $query = SELECT songname FROM mp3 WHERE sgid = .$id; $result = mysql_query($query,$connection); $mp3d = mysql_fetch_array($result); ? the server is telling me line 43(which starts with $mp3d) is not a valid mysql result resource. what am i doing wrong?? chris

RE: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread James Bogosian
Try: $query = SELECT songname FROM mp3 WHERE sgid = ' .$id.'; an SQL query requires you to quote strings. james -Original Message- From: Chris Cocuzzo [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 6:57 PM To: [EMAIL PROTECTED] Subject: [PHP]MySQL error, what's wrong here

Re: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread Chris Cocuzzo
on with that... chris - Original Message - From: James Bogosian [EMAIL PROTECTED] To: Chris Cocuzzo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 23, 2001 7:25 PM Subject: RE: [PHP]MySQL error, what's wrong here.. Try: $query = SELECT songname FROM mp3 WHERE sgid = ' .$id.'; an SQL query

RE: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread James Bogosian
, then inside the brackets, you fetch a second (non-existing) result into $mp3d again. Try it without the third line of that segment. james -Original Message- From: Chris Cocuzzo [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 7:39 PM To: [EMAIL PROTECTED] Subject: Re: [PHP]MySQL error

Re: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread Christopher Ostmo
Chris Cocuzzo pressed the little lettered thingies in this order... alright, new problem, no more errors, but there's just nothing...here's the code: $query = SELECT name FROM mp3 WHERE songid = ' .$id.'; a href=http://www.fplg.net/stream.php?songid=2; class=hov1/a Uhh... maybe I'm

Re: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread Chris Cocuzzo
: Monday, July 23, 2001 10:38 PM Subject: Re: [PHP]MySQL error, what's wrong here.. Chris Cocuzzo pressed the little lettered thingies in this order... alright, new problem, no more errors, but there's just nothing...here's the code: $query = SELECT name FROM mp3 WHERE songid = ' .$id

Re: [PHP]MySQL error, what's wrong here..

2001-07-23 Thread David Robley
On Tue, 24 Jul 2001 14:10, Chris Cocuzzo wrote: - Original Message - From: Christopher Ostmo [EMAIL PROTECTED] To: Chris Cocuzzo [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 23, 2001 10:38 PM Subject: Re: [PHP]MySQL error, what's wrong here.. Chris Cocuzzo pressed

Re: [PHP] mysql ERROR: Update Query Failed problem with 4.0.6

2001-07-16 Thread David Wartell
- Original Message - From: David Wartell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 1:55 PM Subject: [PHP] mysql ERROR: Update Query Failed problem with 4.0.6 Im using PHP 4.0.6 install on Solaris x86 with mysql 3.23.39. The following code

[PHP] mysql error

2001-07-13 Thread andreas \(@work\)
hi all, my script was now working for month but now suddenly get this error: The table 'SQL90cb_0' is full SELECT DISTINCT t1.id,t1.textd FROM tblEntry AS t1,tblTopic AS t2 ORDER BY t2.named,t1.textd anyone know whats the problem ? thank you andreas

[PHP] mysql ERROR: Update Query Failed problem with 4.0.6

2001-07-13 Thread David Wartell
Im using PHP 4.0.6 install on Solaris x86 with mysql 3.23.39. The following code causes mysql_query to return false, but the database update works! $query .= WHERE User_Name = '$User_Name[$i]' ; $sth = mysql_query($query) or die (pERROR: Update Query Failedp$queryBR) ; if ($verbose) {

[PHP] mysql error, dont see why.. please help

2001-05-22 Thread PeterOblivion
Here is the command. mysql_query(UPDATE user_polls WHERE uid = '$UserName' AND type = '$type' SET url = '$file_name') or die(mysql_error()); Output You have an error in your SQL syntax near 'WHERE uid = 'Oblivion' AND type = 'music' SET url = 'test'' at line 1 This is SOOO weird. PLEASE HELP

Re: [PHP] mysql error, dont see why.. please help

2001-05-22 Thread Tyler Longren
Shouldn't it be: mysql_query(UPDATE user_polls SET url = '$file_name' WHERE uid = '$UserName' AND type = '$type) or die (mysql_error()); Maybe I'm wrong. -- Tyler Longren [EMAIL PROTECTED] Currently Unemployed www.noworkfortyler.com On Tue, 22 May 2001 17:00:35 EDT [EMAIL PROTECTED] wrote:

RE: [PHP] mysql error, dont see why.. please help

2001-05-22 Thread Chadwick, Russell
, May 22, 2001 2:04 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql error, dont see why.. please help Shouldn't it be: mysql_query(UPDATE user_polls SET url = '$file_name' WHERE uid = '$UserName' AND type = '$type) or die (mysql_error()); Maybe I'm wrong. -- Tyler Longren

Re: [PHP] mysql error, dont see why.. please help

2001-05-22 Thread Chris
Looks like this may be in wrong order: url = '$file_name') ^ I think you have ' when it should be ' Here is the command. mysql_query(UPDATE user_polls WHERE uid = '$UserName' AND type = '$type' SET url = '$file_name') or die(mysql_error()); Output You

[PHP] mysql error code - how to debug

2001-04-17 Thread pyz
Greetings, This is a mysql question, (but I'm using php with it). Most everything is working correctly; however, when I hit one button I get: Database error: cannot use database xx MySQL Error: 0 () Session halted. What should I be looking for? Is this a user/password problem? Is this

[PHP] MySQL error

2001-02-09 Thread Augusto Cesar Castoldi
I'm receiving this error message: - Warning: 1 is not a MySQL result index in /home/httpd/html/fiesc_test/fiesccontato.php3 on line 24 From this line: --- $dados=mysql_query($sql) or die("No Encontrados registros na Tabela

Re: [PHP] mysql error

2001-01-17 Thread Richard Lynch
mysql_select_db("jamesmc",$db); $result = mysql_query("SELECT * FROM comment WHERE pid='$poid' ORDER by cid desc",$db); $comm = mysql_fetch_array($result); This is in the FAQ, I think... Better re-read that. Start using or die() a lot: mysql_select_db("jamesmc",