index and it returned successful. So that was
the problem all along.
Thanks for your suggestions.
Best regards
Alugo Abdulazeez.
> From: defati...@hotmail.com
> To: spa...@googlemail.com
> CC: mysql@lists.mysql.com
> Subject: RE: PHP-MYSQL Question
> Date: Tue, 7 Apr 2009 15:32
I've done that but it still gives the same error message.
Date: Tue, 7 Apr 2009 16:25:15 +0200
Subject: Re: PHP-MYSQL Question
From: spa...@googlemail.com
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
it is not the ENGINE as Eugene mentioned above, is that you need to use
UNS
ble2
> remains unsuccessful.
>
> > Date: Tue, 7 Apr 2009 17:56:49 +0400
> > From: evge...@kosov.su
> > To: defati...@hotmail.com
> > CC: mysql@lists.mysql.com
> > Subject: Re: PHP-MYSQL Question
> >
> > I suppose the problem is that table1.table1_id and tab
l@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> I suppose the problem is that table1.table1_id and table2.table1_id are
> of different types. The first one is INT UNSIGNED and the second is just
> INT.
>
>
> abdulazeez alugo wrote:
> > Table1 is as below:
>
mail.com
> CC: mysql@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> # perror 150
> MySQL error code 150: Foreign key constraint is incorrectly formed
>
> What does table1 look like?
>
> abdulazeez alugo wrote:
> >
> > Yeah I used the mysql_error
that be the problem?
> Date: Tue, 7 Apr 2009 17:48:16 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> # perror 150
> MySQL error code 150: Foreign key constraint is incorrectly formed
&g
Apr 2009 17:38:59 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_st
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150). So what does that say?
> Date: Tue, 7 Apr 2009 17:38:59 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> S
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_statement);
if($result){ print"Successful";}
else {print "Unsuccessful: ".mysql_error()}
abdulazeez alugo wrote:
Hi guys,
Please can anyo
This type of presentation must be produced by code - either your application
(i.e. in your PHP code) or by a report generator.
SQL statements always return data in a tabular format, i.e.
(Topic, Question)
1,1
1,2
1,3
1,4
2,1
2,2
...etc.
In your presentation loop (PHP), remember the "previous" va
Luie,
> Wouldn't replace change all the entries in your table row, same effect as update?
> I believe the question is how to test which entry in a form has a new value and
>replace/update only that value
in the table.
> If I have a form...
>
> __
> |Employee Reco
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
What about REPLACE?
http://www.mysql.com/doc/R/E/REPLACE.html
'REPLACE works exactly like INSERT, except that if an old record in the
table has the same value as a new record on a unique index, the old record
is deleted before the new record is inserted'
Regards,
Dan
> -Original Message---
Dave Lake wrote:
>
> Hi Folks
>
> I have used MySQL for some time and am just getting my head around PHP. I
> looked across a number of PHP sites for some input on this but failing to
> find an answer thought I would ask some MySQL users (surely many of you are
> using PHP right? ;-) ) for help.
you can use fetch_array:
$data = mysql_query("select * from Categories");
$aux="";
while ($row = mysql_fetch_array($data)) {
$aux.="".$row['Name']."";
}
$aux.="";
echo $aux;
this code will print in html a combobox with the options, in php, the
variable "$catagorie" will have the "id" number o
Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and
associated documentation...
";
}
?>
On Sun, 10 Jun 2001, Vladimir Kravtsov wrote:
> Here is my db hierarchy:
> Database: xtopsites
> Table: Categories
> idName
> 1Name1
> 2Name2
> 3Name3
> 4Name4
>
Hello Adrian,
Friday, June 08, 2001, 8:59:51 AM, you wrote:
ADC> Hi,
ADC> I am not sure whether this relates to this list or the (not working) php
ADC> list.
ADC> For simplicity: I have a form that displays data from a table. I will
ADC> take just one field that displays a name
ADC>
ADC> T
database,sql,query
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >magic_quotes_gpc = On ; magic quotes for
> >incoming GET/POST/Cookie data
>
> And, what about: magic_quotes_runtime ?
Off.
Adrian
--
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
> What you wrote here and what you wrote below are not the same
>
> update vusers set name="Adrian D'Costa" where id=3;
>
> update vusers set name='Adrian D\'Costa' where id=3;
>
> will both work. Look up the section on escaping special characters in the
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 17:47
Subject: Re: php/mysql question
> On Fri,
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
>
> - Original Message -
> From: "Adrian D'Costa" <[EMAIL PROTECTED]>
> To: "Mysql Mailing List" <[EMAIL PROTECTED]>
> Sent: Friday, June 08, 2001 13:59
> Subject: php/mysql question
>
>
> > Hi,
> >
> > I am not sure whether this relates to this
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
>
> >$tname =urldecode($name);
> >$tname1 = stripslashes($tname1);
> >$updtStmt = "update vusers set orgname='$tname1' where id=$tid";
>
> It all depends on these 2 variables settings:
>
> magic_quotes_gpc= On
> magic_quotes_runtime=
Did you try the following code
$updtStmt = "update vusers set orgname=\"$tname1\" where id=$tid";
Should do the job.
Regards
P. Miquet
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 7:59 AM
Subject
- Original Message -
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
> Hi,
>
> I am not sure whether this relates to this list or the (not working) php
> list.
>
> For simplicity: I ha
24 matches
Mail list logo
