current community

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -2 down vote favorite

Below is my SQL Query which i am able to run successfully in PhpMyAdmin . [ data from multiple tables similar to IMDB database ]

SELECT 
`data`.`code`,
`data`.`movie`,
`movies`.`id`,
`movies`.`name`,
`data`.`person`,
`persons`.`name`,
`persons`.`code`,
`data`.`mode`,
`modes`.`name`
FROM
`data`
INNER JOIN `movies` ON (`data`.`movie` = `movies`.`id`)
INNER JOIN `persons` ON (`data`.`code` = `persons`.`code`)
INNER JOIN `modes` ON (`data`.`mode` = `modes`.`code`)
where `data`.`movie`=1

Below is PHP CODE generated by PhpMyAdmin (create PHP Code button) from above command but not fetching any results when used in PHP page (webpage) , 

$sql = "SELECT \n"
. " `data`.`code`,\n"
. " `data`.`movie`,\n"
. " `movies`.`id`,\n"
. " `movies`.`name`,\n"
. " `data`.`person`,\n"
. " `persons`.`name`,\n"
. " `persons`.`code`,\n"
. " `data`.`mode`,\n"
. " `modes`.`name`\n"
. "FROM\n"
. " `data`\n"
. " INNER JOIN `movies` ON (`data`.`movie` = `movies`.`id`)\n"
. " INNER JOIN `persons` ON (`data`.`code` = `persons`.`code`)\n"
. " INNER JOIN `modes` ON (`data`.`mode` = `modes`.`code`)\n"
. "where `data`.`movie`=1 LIMIT 0, 30 ";
share|improve this question
1  
Please review the FAQ and revise to be a question as well as explain what you have tried and what you are trying to accomplish. –  Christopher Ickes Sep 6 '13 at 18:01
1  
what is the error you are getting? –  bansi Sep 6 '13 at 18:02
1  
Do you need the \ns in there? –  andrewsi Sep 6 '13 at 18:03
 
Remove all the " . ". Just wrap the entire SELECT statement in one set of quotes. –  Christopher Ickes Sep 6 '13 at 18:03
 
@bansi - print_r($movies); --> below text is displayed in php page SELECT data.code, data.movie, movies.id, movies.name, data.person, persons.name, persons.code, data.mode, modes.name FROM data INNER JOIN movies ON (data.movie = movies.id) INNER JOIN persons ON (data.code = persons.code) INNER JOIN modes ON (data.mode = modes.code) where data.movie=1 LIMIT 0, 30 –  user2755267 Sep 6 '13 at 18:16
show 4 more comments

1 Answer

up vote 0 down vote

Try 

$sql = "SELECT 
`data`.`code`,
`data`.`movie`,
`movies`.`id`,
`movies`.`name`,
`data`.`person`,
`persons`.`name`,
`persons`.`code`,
`data`.`mode`,
`modes`.`name`
FROM
`data`
INNER JOIN `movies` ON (`data`.`movie` = `movies`.`id`)
INNER JOIN `persons` ON (`data`.`code` = `persons`.`code`)
INNER JOIN `modes` ON (`data`.`mode` = `modes`.`code`)
where `data`.`movie`=1";

The \n and . from your question are not required.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.