help with mysql inner join

[david55]

Hi all .I am have 2 tables as shown below. I run this query and i get no sets of data!! idyoutube in both tables are the same. i have 2 playlists and one video in each but the query returns nothing!! I be happy if some help me fix this query.

select F.idyoutube, F.thumbnail_url, F.title, F.view_count, F.comment_count, F.embed_status from playlist as P inner join youtubevideos2 as F on F.idyoutube = P.idyoutube where playlistname='popsong'

CREATE TABLE `playlist` (
  `User_ID` int(10) unsigned NOT NULL default '0',
  `idyoutube` varchar(93) character set latin1 NOT NULL default '0',
  `playlistname` varchar(32) character set latin1 NOT NULL default '',
  UNIQUE KEY `Index_1` (`User_ID`,`idyoutube`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


CREATE TABLE `youtubevideos2` (
  `ID` int(11) NOT NULL auto_increment,
  `author` varchar(93) NOT NULL default '0',
  `idyoutube` varchar(93) NOT NULL default '0',
  `title` varchar(93) NOT NULL default '0',
  `length_seconds` int(10) unsigned NOT NULL default '0',
  `rating_avg` int(10) unsigned NOT NULL default '0',
  `rating_count` int(10) unsigned NOT NULL default '0',
  `description` varchar(255) NOT NULL default '0',
  `view_count` int(10) unsigned NOT NULL default '0',
  `upload_time` int(10) unsigned NOT NULL default '0',
  `comment_count` int(10) unsigned NOT NULL default '0',
  `tags` varchar(93) NOT NULL default '0',
  `url` varchar(93) NOT NULL default '0',
  `thumbnail_url` varchar(93) NOT NULL default '0',
  `embed_id` varchar(93) NOT NULL default '0',
  `embed_status` varchar(93) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=237 ;

 

[r937]

your query is fine, therefore it's your data

r937.com | rudy.ca

 

[david55]

could you look at this post of mine?

http://www.tek-tips.com/viewthread.cfm?qid=1420752&page=1

It seems the problem is with my php code to display the inner join data

 

[r937]

sorry, i don't do php

have you tried running the query directly in mysql, i.e. outside of php?

r937.com | rudy.ca

 

[david55]

yes i tried it and it worked. I couldn't edit my post that is why i couldn't change it!!

 

[david55]

i fixed that problem . Could you tell me how to count the number of rows of my join query? Just like this but for my inner join query?

SELECT COUNT(idyoutube) AS numrows FROM `formyspace`

 

[r937]

there's a php function for the number of rows returned, called num_mysql_rows or something like that

or perhaps you're thinking of paging? and want to know the count while doing a LIMIT?

look up the mysql FOUND_ROWS function



r937.com | rudy.ca