MySQL help!!

[Mike]

I don't know what it is about MySQL, but it completely fucks with my head. All I want to do is pull some data from the database and display it on the page. Very simple. Yet, I've spent the past 2 hours with G**gle, Notepad++ and various PHP / MySQL sites and still can't get the required results.

$sql = mysql_query('SELECT title FROM musicvids WHERE artist LIKE "$artist"') or die (mysql_error());
while($row = mysql_fetch_array($sql))
{
    $row_array[] = $row['title'];
    echo $row['title'];
} 
echo "<br /><br />";

HELP!!

 

[casidnet]

$sql = mysql_query("SELECT title FROM musicvids WHERE artist LIKE '{$artist}'") or die (mysql_error());

Just got your quoting backwards

 

[Mike]

OMG!! That was it! Thank you casidnet! You r0x0r!

 

[RaginBajin]

If you are using LIKE then you should be using % as well, unless you are looking for exact matches. If you are looking for exact matches, you should move to = as they are much faster to process.

 

[Mike]

If you are using LIKE then you should be using % as well, unless you are looking for exact matches. If you are looking for exact matches, you should move to = as they are much faster to process.

Not sure I understand. Do you mean:

%$artist%

instead of

{$artist}

?

 

[argh01]

Not sure I understand. Do you mean:

%$artist%

instead of

{$artist}

?

The former.

% is mysql wild card for "a bunch of stuff" and is roughly equivalent to *
_ is mysql wild card for "one character" and is roughly equivalent to ?

"%acle" would match "miracle" and "pinnacle" but not "aclemitis"

like is generally only used with broad matches like wild card searches; otherwise it'll slow down your query. If you mean "equal to" use "=".

Like

"select * from artist where name = '$name'";
versus
"select * from artist where name like '%$name%'";

The wild cards can go on either side or both sides of the thing-to-match, and I'd use a statement like
"select * from artist where name like '%" .$name. "%'";
because I'd want to make sure that it was clear to both me and the computer that the wildcard wasn't part of the variable.

 

[casidnet]

'%{$artist}%'

The {} have nothing to do with the mysql, they are just for properly embedding variables inside of strings(not needed but handy when you start working with objects so I just use them for everything now...and my zend cert test said you should lol).

The % stuff is explained by argh01 above.