Re: problem s edna funkcijka

Здравей,
За да правиш заявка към MySQL сървъра, той трябва да знае къде искаш да
направиш insert. Затова трябва да му укажеш коя е базата данни. Това
става с функцията:

mysql_select_db(името на базата);

в твоя случай е

mysql_select_db($DB);

Логиката е следната:
1) връзваш се към базата с mysql_connect();
2) избираш базата данни с mysql_select_db();
3) изпълняваш заявка със mysql_query();

Това е

Успешна година
Богомил





Viktor Popov wrote:
> Zdravej Bogomile,
> 
> Moje li da mi obiasnish kakvo tochno triabva da napravia s tozi kod?
> 
> Blagodaria ti!
> 
> Viktor
> 
> 
> "Bogomil Shopov" <[email protected]> wrote in message 
> news:[email protected]...
> 
>>Здравей
>>
>><code>
>>mysql_pconnect ($DB_SERVER, $DB_LOGIN, $DB_PASSWORD) or
>>die(mysql_error());
>>mysql_select_db(DB);
>>mysql_db_query(query) or die (mysql_error());
>></code>
>>
>>Viktor Popov wrote:
>>
>>>Zdravej!
>>>
>>>Blagodaria ti za otgovora smenih funkciata taka:
>>>
>>>function doReg($fname1="",$family1="",$company1="", $MOL1="", 
>>>$dannum1="",
>>>
>>>$bulstat1="", $phone1="", $email1="", $username1="", $password1="",
>>>$payment1="",
>>>
>>>$maillist1="", $Addr1="", $City1="", $zipcode1="", $Country1="",
>>>$shippingName1="",
>>>
>>>$shippingFamily1="", $shippingphone1="", $shippingAddr1="",
>>>$shippingcity1="",
>>>
>>>$shippingzipcode1="", $shippingCountry1="")
>>>{
>>>
>>>  mysql_pconnect ($DB_SERVER, $DB_LOGIN, $DB_PASSWORD) or
>>>die(mysql_error());
>>> mysql_select_db($DB) or die(mysql_error());
>>>  mysql_query( "insert into users(name,family,company, MOL, taxnum, 
>>>bulstat,
>>>phone, email, username, password, payment, maillist, Addr, City, zipcode,
>>>Country,
>>>shippingName, shippingFamily, shippingphone, shippingAddr, shippingcity,
>>>shippingzipcode, shippingCountry) 
>>>values('$fname1','$family1','$company1',
>>>'$MOL1', '$dannum1', '$bulstat1', '$phone1', '$email1', '$username1',
>>>'$password1', '$payment1', '$maillist1', '$Addr1', '$City1', '$zipcode1',
>>>'$Country1','$shippingName1','$shippingFamily1',
>>>'$shippingphone1','$shippingAddr1', '$shippingcity1', 
>>>'$shippingzipcode1',
>>>'$shippingCountry1')")
>>>or die (mysql_error());
>>>
>>>}
>>>
>>>Dava mi slednoto saobshtenie:
>>>"No Database Selected"
>>>
>>>Globalnite parametri sa opisani v "common.inc"  i sa vkliucheni kakto vav
>>>daila s funkciite "functions.php", taka i v formata "register.php" po
>>>slednia nachin:
>>>
>>>require 'common.inc';
>>>
>>>common.inc izglejada taka:
>>>
>>><?php
>>> $DB_SERVER="localhost";
>>> $DB_LOGIN="admin";
>>> $DB_PASSWORD="******";
>>> $DB="emagazine";
>>> $HTTP_HOST="localhost:3000";
>>> $DOCROOT="emagazine";
>>>
>>>?>
>>>
>>>
>>>Znaesh li zashto ne moje da ne raboti?
>>>
>>>Blagodaria ti predvaritelno!
>>>
>>>Viktor