Maq

Although, I think you have valid syntax try changing these lines respectively. 1) $rs0=mysql_fetch_array(mysql_query("select * from freetplclassified_products where id=$id)); 2) $rs1=mysql_fetch_array(mysql_query("select * from freetplclassified_members where id={$rs0['uid']})); 3) You cannot have have a header redirect after output to the browser, including whitespace. Read more here - HEADER ERROR. If solutions for 1 and/or 2 don't work then temporarily add a "or die(mysql_error())" clause to the end of your mysql_query call.

Good. There are also examples in the MySQL manual: http://dev.mysql.com/doc/refman/5.0/en/delete.html.

If you've implemented roopurt's comment, can you post your current query?

Remove the *.

We need more information. What exactly does 'priority basis' mean? Relevant code? DB structure? Ya know, stuff we need to help you.

What a d-bag.

By using DISTINCT, RAND(), and LIMIT. There are plenty of examples on phpfreaks and the net.

What you are asking is completely relative to the person coding. This has nothing to do with syntax. You can put all of your code on a single line if you want to and not receive syntax errors.

The manual uses the second style but I prefer the first style due to the Java formatting standards I have at work. I'm not really sure what the actual PHP standard is.

Gotcha. I mean the header text looks fine if you have it one color with the addition of a few simple effects. The 'Fast', 'Free', and 'Quality' list should go in the main container of the page somewhere. I understand the correlation between the TV and video tutorials, but you don't watch tutorials on your TV, do you? Looks out of place anyway. Check out some other tutorial sites and see how they designed their site. Remember, all of my comments are subjective and just my opinion. I wouldn't start thinking about this until you're attracting a large amount of traffic.

I'm sorry, but I think you need to scratch that and come up with a brand new design. The puke green is not attractive whatsoever, and the color scheme is just not a good pick. Why is there a TV?

Please use tags in the future.

Oh, sorry about that. Like kickstart already asked, what exactly do you mean by "upline"?

You can update these fields directly in MySQL: UPDATE sponsors_info SET num_rate=num_rate+1, qualify=qualify+1 WHERE user_id='$sponsor_id'

Why don't you try it out first?

How is the image stored? Do you have anything done yet?

Care to elaborate? (P.S. - You don't have to create your own signature, there's one built in.)

SELECT title, MAX(vid) FROM table GROUP BY nid

A couple of things for your test page. - Use single quotes for attributes. - When using the GET method you must pass the values via URL. With that said, you have to add '$day' to the href link. - Why do you have a newline (\n) in HTML? Try something like this: echo " ". $day . "\n";

What type is your 'updated' field and what format are your POSTs in? (Note: It's conventional to use single quotes in associative arrays.) Could you elaborate on this comment? Does it return anything?

You can use the MySQL DATE_FORMAT() function.

You can let MySQL handle this with DATE_FORMAT. I'm not sure what you mean, could you clarify?

I was under the impression he was using Java.

Yes.

You crazy Canadians...