Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 2 1 2
Showing results 1 to 25 of 32
Search took 0.10 seconds. Search: Posts Made By: destas
Forum: JavaScript programming 03-29-2013, 12:17 PM
Replies: 2
Views: 209
Posted By destas
can anyone edit this code for me?

can anyone edit this code for me?
Forum: PHP 03-27-2013, 10:37 AM
Replies: 13
Views: 446
Posted By destas
Code doesn't show genre_name if I have genre_name...

Code doesn't show genre_name if I have genre_name in genres table but i don't have movie with this genre. How to fix that? :)
SELECT m.id, g.genre_name
FROM movies m
INNER JOIN moviegenres mg ON...
Forum: PHP 03-27-2013, 12:26 AM
Replies: 13
Views: 446
Posted By destas
yes i have script:) ohh i forget to change...

yes i have script:) ohh i forget to change &currentactorname to &currentactorid. I use &currentactorname in my previous code. I was join the actor using their names (localhost/actor/john+doe) but i...
Forum: PHP 03-26-2013, 11:12 PM
Replies: 13
Views: 446
Posted By destas
Did you know what this code does? $_GET['q'];

Did you know what this code does?

$_GET['q'];
Forum: PHP 03-26-2013, 07:44 PM
Replies: 13
Views: 446
Posted By destas
I have one more question. If I click on...

I have one more question. If I click on http://localhost/actor/107 107 is actor ID and on this page i want to get actor name of this ID.

Now show for me:
Movies where actor 107 was acted:
...
Forum: PHP 03-26-2013, 03:37 PM
Replies: 13
Views: 446
Posted By destas
I don't understand what i must change in my query...

I don't understand what i must change in my query to work with this code..


GROUP_CONCAT(DISTINCT a.actor_name ORDER BY a.actor_name) AS actors,
GROUP_CONCAT(DISTINCT a.actor_id ORDER BY...
Forum: PHP 03-26-2013, 12:39 PM
Replies: 13
Views: 446
Posted By destas
My SQL : movies table... id, title,...

My SQL :

movies table...

id, title, year..


actors table

`actor_id`, `actor_name`
Forum: PHP 03-25-2013, 03:38 AM
Replies: 13
Views: 446
Posted By destas
Actor ID and Name

I want to create link to every actor. But with code above i get only one actor ( Bradley Cooper ). Movie have five actors ( Bradley Cooper Ed Helms Zach Galifianakis Justin Bartha Heather Graham ).
...
Forum: MySQL 03-19-2013, 06:22 PM
Replies: 26
Views: 1,576
Posted By destas
Error from OR m.id IN Invalid query: Unknown...

Error from OR m.id IN

Invalid query: Unknown column 'ma2.movie_id' in 'field list'.


SELECT m.id, m.title, m.year,
GROUP_CONCAT(DISTINCT g.genre_name SEPARATOR ', ') AS genres, ...
Forum: MySQL 03-18-2013, 06:10 PM
Replies: 26
Views: 1,576
Posted By destas
Now just loading window 2 hours and nothing. ...

Now just loading window 2 hours and nothing.

if i type in to search panel movie name, query must select and count only from movies table...


SELECT COUNT(*)
FROM movies, movieactors, actors,...
Forum: MySQL 03-18-2013, 08:21 AM
Replies: 26
Views: 1,576
Posted By destas
Yes, but now i'm getting hundreds of results and...

Yes, but now i'm getting hundreds of results and hundreds of pages. I will make some image when i back to home.
Forum: MySQL 03-17-2013, 06:08 PM
Replies: 26
Views: 1,576
Posted By destas
up:rolleyes:

up:rolleyes:
Forum: JavaScript programming 03-16-2013, 07:57 AM
Replies: 2
Views: 209
Posted By destas
Search with button

Hello, can anyone help to make this script work with button? Now when i type some text in to search panel i must click ENTER...

<script type="text/javascript">
$(document).ready(function()...
Forum: MySQL 03-15-2013, 09:43 PM
Replies: 26
Views: 1,576
Posted By destas
I use ini_set('memory_limit', '-1'); and now i...

I use ini_set('memory_limit', '-1'); and now i see tons of pages :D wrong query.


SELECT COUNT(*)
FROM movies, movieactors, actors, moviegenres, genres
WHERE movies.title = '$movie_name'
OR...
Forum: MySQL 03-15-2013, 05:07 PM
Replies: 26
Views: 1,576
Posted By destas
same...

same...
Forum: MySQL 03-15-2013, 12:52 PM
Replies: 26
Views: 1,576
Posted By destas
tried to make pagination for search. From: ...

tried to make pagination for search.

From:

SELECT COUNT(*)
FROM movieactors, actors
WHERE movieactors.actor_id = actors.actor_id
AND actors.actor_name = '$actor_name'
Forum: MySQL 03-15-2013, 12:19 AM
Replies: 26
Views: 1,576
Posted By destas
Forget about it :D Ok i have a last question. ...

Forget about it :D Ok i have a last question.

Trying to make search. How to get FROM 3 tables ?

"SELECT * FROM `movies` WHERE `title` = '%s'


OR `actor_name` = '%s' OR `genre_name` = '%s'...
Forum: MySQL 03-12-2013, 07:20 AM
Replies: 26
Views: 1,576
Posted By destas
Doesn't work with this query. SELECT m.id,...

Doesn't work with this query.

SELECT m.id, m.title, m.year,
GROUP_CONCAT(DISTINCT g.genre_name SEPARATOR ', ') AS genres,
GROUP_CONCAT(DISTINCT a.actor_name SEPARATOR ', ') AS actors
FROM...
Forum: MySQL 03-12-2013, 12:50 AM
Replies: 26
Views: 1,576
Posted By destas
Can you explain for me why when i use WHERE...

Can you explain for me why when i use WHERE a.actor_name = 'john ugu' all movies from list have only one actor (john ugu)? :D How to get movies where john ugu was acted and all genres/actors?

...
Forum: MySQL 03-11-2013, 12:23 PM
Replies: 26
Views: 1,576
Posted By destas
I will give you an example: I click on actor...

I will give you an example:

I click on actor name john ugu (http://www.../john ugu) and on this page i need to get/count all movies where actor john ugu was acted.
Forum: MySQL 03-09-2013, 04:04 PM
Replies: 26
Views: 1,576
Posted By destas
pagination

Hello, can anyone help me with pagination?
How it must work: I need to count movies where one of the actor have acted in this movie.


i have 3 tables:

INSERT INTO `movies` (`id`, `title`,...
Forum: MySQL 03-02-2013, 10:44 AM
Replies: 21
Views: 1,559
Posted By destas
Can you help me with one more thing? How to get...

Can you help me with one more thing? How to get actor which has appeared in the most movies? count from movieactors and get his name from Actors ?

And if you can help me please with getting...
Forum: MySQL 03-01-2013, 09:48 AM
Replies: 21
Views: 1,559
Posted By destas
I use WHERE `genre` LIKE '%s' Now i...

I use

WHERE `genre` LIKE '%s'


Now i change it to

WHERE g.genre LIKE '%s'
Forum: MySQL 02-27-2013, 09:17 AM
Replies: 21
Views: 1,559
Posted By destas
Now for each movie i get only one genre. If i...

Now for each movie i get only one genre. If i click to show movies with Comedy all movies have Comedy genre now written by one-time where is another genres for this movie... I don`t understand why...
Forum: MySQL 02-26-2013, 09:23 AM
Replies: 21
Views: 1,559
Posted By destas
SELECT m.id, m.title, m.year, m.aa, m.bb, m.cc,...

SELECT m.id, m.title, m.year, m.aa, m.bb, m.cc, m.dd, GROUP_CONCAT(g.genre) AS genres, GROUP_CONCAT(a.actor) AS actors



GROUP BY m.id, m.title, m.year, m.aa, m.bb, m.cc, m.dd


Same...
Showing results 1 to 25 of 32
Page 1 of 2 1 2

 
Forum Jump

All times are GMT +1. The time now is 05:35 PM.