• Registered: 2009-03-09
  • Posts: 44

Topic: Klaida - sql query

<?php

$mysql_host = 'IP';
$mysql_user = 'Login';
$mysql_pass = '*****';
$mysql_db = 'baze1';

$ret_klaida2="klaida2";
$ret_klaida="klaida";
$ret_klaida3="klaida3";

$conn=mysql_connect($mysql_host,$mysql_user,$mysql_pass) or die($ret_klaida);

mysql_select_db($mysql_db,$conn) or die($ret_klaida2);

$sql=sprintf("INSERT INTO antroji (kodasx,data) SELECT pirmoji.kodas,pirmoji.data FROM pirmoji where vardas='jonas'");

mysql_query($sql,$conn);

die($ret_klaida3);
?>


==============================================

Gaunu klaida3, kas ce blogai?

  • From: Vilnius
  • Registered: 2008-06-11
  • Posts: 1,254

Re: Klaida - sql query

tai kad viskas cia gerai...

MongoDB Certified Developer
MongoDB Certified DBA
Zend Certified Engineer
  • Registered: 2009-03-09
  • Posts: 44

Re: Klaida - sql query

Nu man numeta Klaida3, ir nebuna i databaze irasyta eilute, kuria turetu irasyt sitas failas

4 Reply by zygis (edited by zygis 2009-05-16 10:20:24)

  • From: Vilnius
  • Registered: 2008-06-11
  • Posts: 1,254

Re: Klaida - sql query

tai pakeisk $ret_klaida3="klaida3"; i $ret_klaida3="skriptas baige darba nes taip pats parasiau";

kai skriptas daeina iki die()  baigia darba, ir isveda tavo pasirinkta teksta. kadangi die() iskvietimas nepriklauso nuo jokiu salygu tavo kode, tai jis visada ir meta tavo pasirinkta pranesima

MongoDB Certified Developer
MongoDB Certified DBA
Zend Certified Engineer
  • From: Vilnius
  • Registered: 2008-06-11
  • Posts: 1,254

Re: Klaida - sql query

o siaip :

mysql_query($sql,$conn);
//pakeisk i 
if (!mysql_query($sql,$conn)) {die(mysql_error($conn));}
//arba
mysql_query($sql,$conn) or die (mysql_error($conn));
MongoDB Certified Developer
MongoDB Certified DBA
Zend Certified Engineer

6 Reply by alien (edited by alien 2009-05-16 16:05:04)

  • Registered: 2009-03-09
  • Posts: 44

Re: Klaida - sql query

Fixed, klaida buvo durna ^^ databazeja nebuvo duota useriui privilegija insert xD