Hi Grega,
Probably you wanna define a primary key, if so, then change from
"uniqueid" to "primary key".
2011/5/6 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 unfa
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), o
On Thu, May 5, 2011 at 10:29, 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 va
: Grega Leskovšek
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, imepriimek
varchar(50
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), uniqueid(
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, 2
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
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 my
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
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
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
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
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 :)
O
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
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 s
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
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
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(mys
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 =
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 ph
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 -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 I was un
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 curl-devel
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(''.mysql_error());
WR> I get this MySQL error:
WR> You
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(''.mysql_error());
I get this MySQL error:
You have an error in your SQL sy
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 conne
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/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
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 ha
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 mysql.timerescue.
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
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.
which does not require a tick around the value. I 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
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
http://www.radinks.com/up
> 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 h
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 *
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 `
> `%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
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 cla
bject: 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
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 happ
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 u
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
--> 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
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:
i
36 while($row = 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] MyS
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
Hi,
I have following problem:
list.php3
line 36 while($row = mysql_fetch_row($mysql_result))
{
//get columns
$id = $row[0];
$ynimi = $row[1];
$ylahi = $row[2];
$ypostios = $row[3];
$ypostitmp = $row[11];
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: [PH
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 wit
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";
$databas
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:
[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' (Errco
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
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)
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
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
th
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 fin
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',
para
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
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()
http://www.php.net/manual/en/function.mysql-real-escape-
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
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 Haa
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
&g
Hi all,
I have got this code but I can get it to work, it doesnt make sense!
but I am getting this error - "Warning: Supplied argument is not a valid
MySQL result resource in /usr/home/e/a/eagadmin/public_html/main.php on line
14" but I dont understand why!
Can anyone help?
Regards, Ian.
-
> 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 mysq
:
> : Julien Bonastre [The-Spectrum.org CEO]
> : A.K.A. The_RadiX
> : [EMAIL PROTECTED]
> : ABN: 64 235 749 494
> : QUT Student #: 04475739
> :::::::::::
> - Original Message -
> From: "Dani" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, May 06, 200
he-Spectrum.org CEO]
: A.K.A. The_RadiX
: [EMAIL PROTECTED]
: 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
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 /www/host/doms/com/s
- 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
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
add
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 sit
- 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)
> {
>
> 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("
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 s
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
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
w
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
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 sa
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 $
- Original Message -
From: "James Holloway" <[EMAIL PROTECTED]>
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 usi
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 problem, but it seems to make more sense
than manually coding a random number (which is, perhaps, impractical
especiallyif
PROTECTED]]
> Sent: 23 July 2001 23:57
> To: [EMAIL PROTECTED]
> Subject: [PHP]MySQL error, what's wrong here..
>
>
>$id = rand(1,2);
> $query = "SELECT songname FROM mp3 WHERE sgid = " .$id;
> $result = mysql_query($query,$connection);
> $mp3d = mysql_f
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
<[EMAIL PROTECTED]>
Sent: 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
th
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."'";
>
> http://www.fplg.net/stream.php?songid=2"; class="hov1">
>
Uhh... maybe
;>
what's going 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:
>
>
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 songnam
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:
the server is telling me line 43(which starts with $mp3d) is not a valid
mysql result resource. what am i doing wrong??
chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list adm
- 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
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 ("ERROR: Update Query Failed$query") ;
if ($verbose) {
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
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());
>
> Outp
, 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(
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
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 HEL
Ensure your database name as listed in either mysql_select_db or
mysql_db_query is valid.
After that, it's probably a GRANT problem. Make sure the username/password
pair is correct, first of all, and check the privileges of that user.
My guess is that either the DB name is incorrect, or the user
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
On Fri, Feb 09, 2001 at 09:26:17AM -0200, Augusto Cesar Castoldi wrote:
> -
> Warning: 1 is not a MySQL result index in
> /home/httpd/html/fiesc_test/fiesccontato.php3 on line 24
>
Whenever you see this message, echo the sql that you are using and also
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("Não Encontrados registros na Tabela
1.")
1 - 100 of 102 matches
Mail list logo
