:icon_redface: After numerous attempts, I found out the solution. Here it is.

INSERT INTO a (name, age, postcode, city )
SELECT name, age, postcode, city
FROM b where counter = 1
AND NOT ...

Bingo! You are right. Check this link!
http://www.webmasterworld.com/forum88/9091.htm

<?php
// open database connection code and then my code as follows

//$id = mysql_insert_id(); << This line wouldn't work ie., $id will be null because there isn't any insert statement before...

You are welcome :)

update journey j, passengers p, shuttle s set j.occupancy=j.occupancy - 1 where p.journey_id = j.id and s.id = j.shuttle_id and s.id = 1 and p.passenger_name='bill gates'

wouldn't this work ? Many...

Yep. It will create a user called "naveen" with password "password1" and grant SELECT,INSERT,UPDATE,DELETE permissions for that user.

Hmm.. Well, Thats because the limits are not being set properly.

if ($_GET[pg]==0) $pg = 1;
$lines = (int)$lines;
if ($lines==0) $lines = 5;
$left_limit = ($_GET[pg]-1)*$lines;

This...

update table set number=number+300 where condition;

You mean like this ?

Edit: Or are you talking about concatenation ?

update table SET number = concat( number, "00" ) WHERE condition;...

;)

Then you can truncate the table instead of dropping it and creating a new one ! mysql_query("Truncate table tablename"); will do the trick !

Do you have these files on a server so that we can check the output ? Because, I don't understand what exactly is the problem..

Yes. It is possible to store the path of the file. The datatype is varchar as you have mentioned. Store the path, then display the image by retrieving the path from the table and use it in the image...

And you don't have that syntax error anymore. Right ? Now, if that solves your problem, well and good. If it doesn't, you need to be specific about your problem.

Ah! correct.. I couldn't spot that one!

In php, if we want to echo something, its done like this. echo "Welcome...";

As far as I know, you can't have insert and update in the same query. The only case where you can have insert and update in the same query is when you use on duplicate clause ...

:(

LOL.. i know.. you have already given me reps for a php question(and you can give reps only once per day!)

SELECT eid, title, SUBSTRING(content, 1, 200), thumb_image FROM diary ORDER BY eid DESC LIMIT 3

:) Now, gimme my virtual high five!

select orderid from bOrders where userid IN (select userid from email = 'John@abc.com');

Thats wrong. You are missing where clause.. :)
select orderid from bOrders where userid IN (select userid...