fenway

You can't combine two statements into one query. So use a second variable, and run both.

I don't know what you mean by "cell", "data", and "template". But I would still do one each.

That's not a valid date format... you need YYYY-MM-DD.

That's not possible... echo the value of the counter variable, if it's more than one, then there's something else going on.

Email as PK? No.

What do price1 and price2 represent?

A few things: 1) you likely don't need left joins except for the tables with senderid and notificationdate. 2) it would be preferable to store createdtime as a proper datetime field or timestamp, not integer. 3) your date restriction for created time means you don't need != 0 or IS NOT NULL. 4) if you simply want to null out everything for senderid = 1, that's different than excluding them altogether.

Since it doesn't sound like the details are shared, make tables called guitar_detail, laptop_detail, etc., corresponding to your category name.

No, you're not... that not's what fetch_array() does.

Another table....

You want single quotes around your string literal, not back-ticks: $result = mysql_query("SELECT * FROM $bookseriesfordisplay WHERE book_title = '$booktitlefordisplay'")

Shouldn't be anything wrong with that at all...

How are you storing the date? What column type?

Nope... not unless you change the IDs.

What does "Includes numbers" mean? Echo $sql.

Well, you can push then onto an array in php and join them with commas, or you can use group_concat.

Well, you can push then onto an array in php and join them with commas, or you can use group_concat.

This is being discussed in another thread right now...

Yes, but only to return true/false.

I'm a bit sleepy this morning... maybe something like this (untested): SELECT loc, tallly FROM ( SELECT loc, COUNT(loc) AS tally FROM $table WHERE DAYNAME(thedate)='$today' GROUP BY loc ) AS counts GROUP BY loc HAVING tally = MIN(tally)

Yes, now I see what you mean... you can't accomplish that in a single statement... you'll have to join the table back to it, and then use MIN().

Well, a REGEXP can do that, too.

try id IN ( 1,3,7,etc.)

Why not order by LEFT(movieName, 1)?

That's nice... do you have an actual mysql question? Because there are plenty of tutorials if you want the entire code written for you.