As i know , i got this information for your 3 rd question:

you need to look at what makes each engine unique:

myisam -- fast for reading and inserting, table level lock which makes
it not...

sorry company_name is already inserted in person table, thats why use update or else...

post your updated code...

Form where $result_row comes from???
i thinks its $rowsql...
i hope so....check it...

try this code:

$qry=mysql_query("SELECT * FROM yourtablename ");
$num=mysql_num_rows($qry);
$start=0;
$len=1000;
$value=$_POST['field']
while($start<$num)
{
$f="update tablename set...

or try this:

SELECT t1.Name, SUM(t1.Salary + t2.Bonus) as Total From tb1 as t1, tb2 as t2 WHERE t1.Name = t2.Name group by t1.Name order by t1.Salary

try this:


$t=mysql_query("select * from headlines");
$result=mysql_fetch_array($t);
$r=mysql_query("select c as count(*) from comments where hidofctbl='".$result['hid']."'");

AVG(Votes) is exactly what you want......

desc is a keyword,
so change that name to any like desc1...
and try...

thank you heenix...

Hello Friends...

Tell me how to store my product information in xml file using php ...
Is this is a replacement of my database...

Please tell me any information on this...

Thanks in...

As i know Use multiple-row INSERT statements to store many rows with one mysQL statement is the best.....

For more information visit this...

use PHP String Functions to do this...
take a look at this (http://www.w3schools.com/PHP/php_ref_string.asp)

Shukriya...
So cool...

yes, save colors_pic with comma separated...and retrieve them appropriately...
see:

The implode() function takes an already existing array as
it's argument, and concatenates the contents of...

You can store them with comma separated...
And retrieve them with implode and explode functions...
And tel me , by which reason you are trying to store multiple image paths into single field...

select is DML command...

Truncate
1.Truncate Can be DDL Command.
2.it cannot be rollback.
3.we cann't use Where clause.
4.truncate=delete+commit so we cann't rollback.
5.truncate delete all record from the table....

see this:
http://dev.mysql.com/doc/refman/5.1/en/binary-log.html

yes , you can write joins to get your desired details...

select l.user_name,l.password,u.fname,u.lname,u.address from login_table as l,user_table as u where l.user_id=u.user_id;

yes,
if you put your order_id in session, after order is completed,then make your session destroy...
then you can write that query as:

select product_id from orders where...

Need more information on this.....

hello
try this instead of your 87th line:
if(!empty($_POST['master_id']))

select * from table where c_id like '% 4%';

echo $_POST['sel_id'];exit;
see what it prints...

hello dickersonka and pritaeas...
Please give clear explanation about mysql indexing...how to use??

Thanks in advance...

select * from tablename;
this statement will print all the columns, not the matter of null or empty..

then drop the table with same name.
or rename those tables and import them...

Export one table, then import it in the other database....
If you are using PHPMyAdmin then follow the below:
OK. For example, database name: db1 and db2
The table name is tb.
Export table
1)...

Welcome...

1.A NULL value represents the absence of a value for a record in a field (others softwares call it also a missing value).

2.An empty value is a "field-formatted" value with no significant data in...

hello...have you checked it???
have you got solved your problem...???

this is one of the best titorial:
http://www.tizag.com/mysqlTutorial/

see this link and try your self:
http://www.digitalpropulsion.org/Programming/Triggers_in_MySQL_5_0

i think you have to add one more column like month the you will calculate hours per month by using group by month column...

hello see this example will help you:
t1 table having 4 columns like year,month,day,points...
year month day points
2000 01 01 1
2000 01...

hello vssp...
there is a function called SUM in mysql to calculate total of any numerical column...and if you want to calculate per month,then use limit by 30 days...or created_date < last day of...

can u post your table structure...

It really depends on what you are trying to do, and versus what. MySQL versus Access? MySQL versus Oracle? MySQL versus DB2? MySQL versus a spreadsheet? MySQL is good for web apps, integrates nicely...

There are really no disadvantages to using a database. I use a MySQL database and PHP to interpret the information. The advantages of a database are numerous.

1. You can keep a LOT of information...