[Insert only date where month is not previous month]

In you PHP code, before you run the INSERT statement, do a quick if statement to check $ETD_month != $date_now.

 

if($ETD_month==$date_now)
{
    // Insert
}

 

~awjudd

[Insert only date where month is not previous month]

Why aren't you just kicking it out on the PHP side of things?  Why should the query be preventing this insert?

 

The INSERT INTO statement when used with VALUES shouldn't accept a WHERE clause because it doesn't make sense at all.

 

~awjudd

[inserting data into a table]

You are missing a , between the two values that you are updating.

 

$sql_rating = "UPDATE movie SET rating='$sum_rating', num_votes='$sum_num_votes' WHERE title='$title'";

 

~awjudd

[URL Shortener - lnked.me]

As will I ... I already started using it on Google Plus

 

~awjudd

[Host asking me to optimize my database tables]

Is the photo column a BLOB?  Is your table properly indexed?  Run an EXPLAIN on the query to get more information on the actual query.

 

~awjudd

[Load times really slow - Please Review]

You are logging slow queries to "/var/lib/mysql/vps-slow.log" ... so show us what is in that file.

 

~awjudd

[can't create view]

Because that is an invalid query.  It should be IS NOT NULL.

 

CREATE VIEW loDensity AS
SELECT Name, SurfaceArea, Population,
Population / SurfaceArea AS popDensity,
LifeExpectancy
FROM country
WHERE LifeExpectancy IS NOT NULL

 

With views, when in doubt, just try to copy and past the SQL and see the error message.

 

~awjudd

[insert select]

Inserting using the set-based notation doesn't need the () around the values.

 

The following should work:

safe_query("INSERT INTO ".PREFIX."cup_matches ($type, $type_opp, matchno, clan1, clan2, comment, 1on1)
        SELECT a.$type, a.$type_opp, a.matchno, a.clan1, b.clan2, a.comment, a.1on1
        FROM ".PREFIX."cup_matches a, ".PREFIX."cup_matches b
        WHERE a.clan2 != b.clan2 AND a.matchno = '$ID' AND b.matchno = '$ID' AND a.$type='h' AND b.$type='h'");

 

~awjudd

[search and replace using a sql statement]

You can use MySQL's REPLACE function

 

http://dev.mysql.com/doc/refman/5.0/en/replace.html

 

Either do it in a SELECT statement (non-permanent) or an UPDATE statement (changing the actual values in the table).

 

~awjudd

[query from multiple tables]

If you aren't trying to join the table together, then add semi-colons between each of your queries and you can run more than 1.

 

~awjudd

[inserting a record in a specific place?]

Unless you have a key which you can order by, there is no way of doing what you are wanting.

 

The only way would be to add a "DisplayOrder" column and then fill that in with the corresponding order and then when selecting out of your table, you would add "ORDER BY DisplayOrder" to your query.

 

~awjudd

[select from multiple tables error]

You will need to prefix your tables in the WHERE and ORDER BY clauses.  That said, you are currently doing a CROSS JOIN between these two tables which I don't think that is what you want.  As Maq said, you probably want to do a JOIN.

 

~awjudd

[getting paid to chat]

@KingPhilip - You said what was said in the Gold Room stayed in the Gold Room ...

[getting paid to chat]

Stupid question ... but why would anyone pay to talk to you?

[Bug Tracker]

I don't mind using Mantis (http://www.mantisbt.org/) for logging bugs and stuff ...

[Every derived table must have its own alias]

As AyKay47 said, your query is doing the exact same as just a straight SELECT on that table.  However that said, to answer your question it is because you have a subquery so you need to alias that table in order for SQL to know what to refer to it as:

 

SELECT cadetId, lastName, firstName FROM
(
SELECT tblcadets.pkCadetId AS cadetId, tblcadets.lastName AS lastName, tblcadets.firstName AS firstName
FROM tblcadets AS tblcadets
)  AS a

[Math Errors and Problems]

If that is all you are doing ... why don't you just do the math in the database?

 

SELECT (SUM(value_one) - SUM(value_two)) AS totalDifference FROM table

[Mysql error message, HELP ME PLEASE.]

It means your query failed.

 

Try adding or die(mysql_error()) to your query line ...

 

$query = mysql_query("SELECT ´article_id´ , ´article_title´ , ´article_likes´ FROM ´articles´ ") OR die(mysql_error()) ;

[Newbie: need help with formulating a Query]

SELECT DISTINCT r.id, r.title AS 'Recipe Title' , r.summary AS 'Recipe Summary', r.image , r.status AS 'Recipe Status', c.id, c.title ,c.summary, c.body, c.status,c.createdate,c.createuser,c.customerid,r.createdate, `firstname` , `lastname`
FROM `recipies` AS r
JOIN `customer` AS cu ON r.customerid = cu.id
JOIN `comments`AS c ON cu.id = c.customerid
WHERE r.status =1
LIMIT 0 , 30

[Syntax Error]

Please Note: it is extremely helpful if you provide the actual error you are getting.

 

~awjudd

[Most Technologically advanced country]

We recently moved up from igloos into huts.  I hear there is this thing called the internet in the outside world, they haven't installed it on any of our servers up in Canada yet.

 

~awjudd

[after a little help in moving data from one table to another.]

As Muddy_Funster said, you use joins.

 

Step 1 - write a SELECT query that will get the data how you need it (use joins as needed)

Step 2 - use the query from Step 1 and put it into the INSERT

Step 3 - sit back watch as the table gets filled

[after a little help in moving data from one table to another.]

By using the set based insert.  Write your SELECT statement from your first table to get the data like you need it in the destination table (where you are copying to) and then with that SELECT use it as you INSERT.

 

INSERT INTO newTable ( f1, f2, f3 )
SELECT f1, f2, f3
FROM links

[PHP Freelancer looking for some work]

Hi everyone,

 

I have been coding with PHP / mySQL for 6 years now and have been freelancing on and off throughout that time.  I am now looking for a some small projects to work on.

 

My strengths are around the back end of the application (making them work well) but I tinker with the front-end as well (however, I am not a web designer).  I also have a decent knowledge of JavaScript (I prefer to use jQuery to make my life easier).

 

How to contact me:

i) PM me on the PHPFreaks IRC Channel (judda)

ii) PM me on the forums

iii) Send me an email: http://bit.ly/rqsgxT

 

Resume: http://bit.ly/rA0Hj9

Development Projects: http://bit.ly/iemZYM

Blog: http://bit.ly/uMHTRB

 

Please feel free to contact me if you have any questions.

 

Thanks,

Andrew

[Logical if statements.]

Since it returns a boolean no matter what, you don't even need the if statement.

 

return $row->cash > $finalcash &&
               $row->core1 > $finalcore1 &&
               $row->core2 > $finalcore2 &&
               $row->core3 > $finalcore3 &&
               $row->core4 > $finalcore4;