[RESOLVED] Search Search?

zcollvee

<?php
 include("muzikhead.php");
 $name = $_GET['name'];
  $artist = $_GET['artist'];
   $album = $_GET['album'];
    include("config.php");
    //database connected now
            //the query to show the stuff
       $query = "SELECT name,artist,album,art FROM music WHERE album = '".$album."', artist = '".$artist."' and name = '".$name."'";
       $result = mysql_query($query);
       while(list($name,$artist,$album,$art) = mysql_fetch_row($result)){
       echo '<table><tr><td rowspan="4"><img src="'.$art.'" width="50" height="50"></td><td>
       <a href="song.php?songid='.$songid.'" target="_parent">'.$name.'</a><br />
       <a href="songsearch.php?artist='.$artist.'" target="_parent">'.$artist.'</a><br />
       <a href="songsearch.php?album='.$album.'" target="_parent">'.$album.'</a></td></tr></table><br />';
       }
include("muzikfoot.php");
?>

http://coolcenter.latestdot.net/music.php
^thats where you type in everything^
The error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /host/z/c/o/zcollvee/songsearch.php on line 11
I need this to happen.
people search for the title/artist/album two of them or all three of them. and it has to show the result.
And also is it illegal to do such a site?

halojoy

hi comrade!

Try change this line like below.

It is good to use function: [man]mysql_error[/man]
because there are more frequently MYSQL db sql errors,
than there are pure PHP Code Errors, if we should count them all .. 😃

This is why I do not often use SQL databases, myself.
SQL syntax is way to complicated for a normal person
.. and those we are plenty many of !!!
😉

Regards 🙂
halojoy

<?php      

  $result = mysql_query($query) 
           OR exit( 'As usual, there is SQL error:<br />' . mysql_error() );

?>

zcollvee

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' artist = 'Baha Men' and name = ''' at line 1
That means you have to fill out all the fielsds i guess? no:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' artist = 'Black Eyed Peas' and name = 'Pump It'' at line 1

halojoy

zcollvee wrote:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' artist = 'Baha Men' and name = ''' at line 1
That means you have to fill out all the fielsds i guess? no:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' artist = 'Black Eyed Peas' and name = 'Pump It'' at line 1

yeah, I think you are right ( tenker du har rett, riktigt )

you know what,
sometimes things can show pretty good if you this ( just for DEBUG )

we ECHO the query .. to see what it is like!!!!

       $query = "SELECT name,artist,album,art FROM music WHERE album = '".$album."', artist = '".$artist."' and name = '".$name."'";
echo $query; // just DEBUGGING
echo '<br /><br />'; //put in a break
       $result = mysql_query($query);

halojoy

A guess

you maybe have to use:
album=xxx AND artist = yyyy AND name = zzzz

instead of:
album=xxx , artist = yyyy AND name = zzzz

zcollvee

for the earlier one
are you like mocking me?
Gimme an answer people! I need a search engine!

halojoy

zcollvee wrote:
for the earlier one
are you like mocking me?

no!
you may have to use AND instead of a comma

zcollvee

halojoy wrote:
no!
you may have to use AND instead of a comma

Thanks it worked