Jump to content

LEFT JOIN problem


cheeseus

Recommended Posts

Hello,

 

I am trying to merge results from two tables, but this is something I haven't done so far, so manybe my mistake will look stupid to Pro's. I get the "Warning: mysql_fetch_array(): supplied agrument is not a valid MySQL resource".

 

Here is my code:

 

$result = mysql_query("SELECT * FROM az_mustseethis LEFT JOIN az_articles ON az_mustseethis.art_id = az_articles.art_id WHERE az_articles.category = 'Must See This' ORDER BY art_id DESC LIMIT $from, $max_results",$connect);

 

Instead of adding the latest entry in the "az_mustseethis" table, I want to take it from the "az_articles" table, where it has already been added. Help please?

Link to comment
https://forums.phpfreaks.com/topic/56170-left-join-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.