hno

HI I wrote this query:"DELETE FROM 'shop'.'comment' WHERE 'comment'.'id'=1 limit 1" and run it with php and mysqli_affected_rows shoes me that the query was successfully run but when I opened phpmyadmin it was still exist and didn't delete from there Why it's not delete ? thanks

Do you mean $_SERVER['PHP_SELF']; ? But when i use echo $_SERVER['PHP_SELF']; it didn't return anything?

HI How can get the current url of the open page? thanks

HI I use require_once function to include the connection page to the database .But in the function that I have created, $dbc function does not recorganize ($dbc has the connection information to databae and included by the require_once ) even I use 'global $dbc;' but I still have problem by the way $dbc recorganize in out of my function.What should I do now? thanks

HI IF the query doesn't return any value in select query what does mysqli_num_rows returns?Is that 11? thanks

Hi i have make a search page .now when I want to load the page it shows me this error and I know it declares twice . because it is include twice in the page one in the left panel and once in the search page.What shoud i do? thanks

$q="INSERT INTO `shop`.`ad_type` (id,ad_id, $which ,user_id) VALUES (null,'" . $ad_id . "','" .$value . "','" . $uid . "')";

HI I have a insert query that one of the value is:1,0 but when i run the query in php it said :"Column count doesn't match value count at row 1" and i know the problem is from that value so how should write it so that php knows it's the value of one filed. thanks

HI I have a select (combo box) in my form and I want when the user submit the form I get the selected number of combo box it means the number of selected row .How can i do that? thanks

HI I want a query that add 1 to the value that the query has been retrieve from the database.In the other hands a=a+1 and then update that field. thanks

HI I need a image validation system like captcha but I want it's be easy to install and do not use from database and has a fixed image size and easy to read.If you know something like that or a version of captcha that has these facilities plz tel me. thanks

HI How can return a field that related to the row that the query inserted it into the table.For example the query insert a new row into the table and after it was successful it should return the id of that row.How can I do that ? thanks

thanks but how should i escape it?

hi what do you do for increase the security when you want to get $_post array element from the users and store the values in the database or print it? For example you want to store $_post['name'] in the database?How do you check it for safe? thanks

Yes ,what should i do now?

Hi My host does not support mail function.I heard that it's possible to send mail from a mail server like gmail or yahoo but I don't know how to do that so what should i do for that? If it's possible gives me and example with gmail by the username:hno2005 and pass:123456 . Thnaks

HI What is the difference between these two queries : 1- select CONCAT(last_name , ',' , first_name)... 2-select CONCAT_WS(' ' ,first_name,last_name)... And what is the advantage of using them instead of this kind of query: "select first_name , last-name ....". Thanks

HI what is the diffrence between mysqli and mysql and which one is better? thanks

HI what is the advantage of using _clone in a class and what does it do? Could you give a example of usage of that. And in What situations we should use that? tnx

HI i'm is learning about using calss in php.I wrote this code: class Person { function __construct($name) { $this->name = $name; } function getName() { return $this->name; } private $name; }; $a= new Person("a") . "\n"; print $a->getName(); When I using this code ,it gives me the following error: "Catchable fatal error: Object of class Person could not be converted to string in C:\wamp\www\class\class.php on line 14" but when I change it to following ,it doen't have any errors and show me the result. class Person { function set($name) { $this->name = $name; } function getName() { return $this->name; } private $name; }; $a = new Person; $a->set("a"); print $a->getName(); What is the problem? thanks

No,it doesn't suppport mail() function.Is it possible to use gmail server to send mail from the script?How can i do that?

,i want to add a possibility to the users of my site that they can send emaisl to me .How can i do that? I use gmail for my emails.What code i should use to add this possibility to users to send emails?

No ,i want to add a possibility to the users of my site that they can send emaisl to me .How can i do that?

Hi I saw a connection to bank example and for connect to bank ,he is using from mysqli_connect .What is the deffrence between mysqli and mysql codes?Does the both is same?If so ,what's that otherwise which one is better to use? tnx

Hi For sending mail,does the web server should support SMTP or not?If so ,what setting i should adjust? tnx