freelanceprogrammers.org Forum Index » PHP

View previous topic :: View next topic

mysql error message by error number

taujago Posted: Sun Sep 04, 2005 10:14 pm

Joined: 04 Sep 2005

Posts: 2

mysql error message by error number

dear all,
i`m newbie in php and mysql database.
i would like to ask about error description in mysql database.
for example : 1026 means duplicate entry
anyone know the others? or
anyone knows where to find the complete documentation about that ?
i`ll be thankful for your answer.
viva php

your regards,

firman

dewebbster Posted: Tue Sep 06, 2005 2:29 am

Joined: 06 Sep 2005

Posts: 16

mysql error message by error number

Heyo,
I`m new to the group but have a few php snippets I`ve come to rely upon
the recycling of...
I build my querystring as $qs and then run it so:

$yep = mysql_query($qs);
IF ($yep) {
$id = mysql_insert_id();
} ELSE {
$msg .= "Sorry, there has been an error.<br>mysql said:
"".mysql_error().""<br>$qs = $qs";
}

This lets php tell me the new record`s id or why not. The mysql_error()
function looks up the text message for me.
HTH.

-m

On Sep 4, 2005, at 12:14 PM, taujago wrote:

> dear all,
> i`m newbie in php and mysql database.
> i would like to ask about error description in mysql database.
> for example : 1026 means duplicate entry
> anyone know the others? or
> anyone knows where to find the complete documentation about that ?
> i`ll be thankful for your answer.
> viva php
>
> your regards,
>
>
>
> firman
>

[Non-text portions of this message have been removed]

sha_sher Posted: Tue Sep 06, 2005 11:55 pm

Joined: 22 Aug 2005

Posts: 3

mysql error message by error number

You can download the MysQL reference Manual from here.
http://dev.mysql.com/doc/

--- Michael Slavin <mini@...> wrote:

> Heyo,
> I`m new to the group but have a few php snippets I`ve
> come to rely upon
> the recycling of...
> I build my querystring as $qs and then run it so:
>
> $yep = mysql_query($qs);
> IF ($yep) {
> $id = mysql_insert_id();
> } ELSE {
> $msg .= "Sorry, there has been an error.<br>mysql
> said:
> "".mysql_error().""<br>$qs = $qs";
> }
>
> This lets php tell me the new record`s id or why not. The
> mysql_error()
> function looks up the text message for me.
> HTH.
>
> -m
>
> On Sep 4, 2005, at 12:14 PM, taujago wrote:
>
> > dear all,
> > i`m newbie in php and mysql database.
> > i would like to ask about error description in mysql
> database.
> > for example : 1026 means duplicate entry
> > anyone know the others? or
> > anyone knows where to find the complete documentation
> about that ?
> > i`ll be thankful for your answer.
> > viva php
> >
> > your regards,
> >
> >
> >
> > firman
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
>

شكيب الله شير

___________________________________________________________
To help you stay safe and secure online, we`ve developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com

dewebbster Posted: Wed Sep 07, 2005 12:42 am

Joined: 06 Sep 2005

Posts: 16

mysql error message by error number

Thanks! :)

On Sep 6, 2005, at 1:55 PM, Shakeeb Ullah wrote:

> You can download the MysQL reference Manual from here.
> http://dev.mysql.com/doc/

[Non-text portions of this message have been removed]

freelanceprogrammers.org Forum Index » PHP

All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help