Page 1 of 1

Help with a PHP and mySql question.

Posted: Sun Jul 08, 2007 11:18 am
by bos45430
I am trying to search the ALBUMS database to see if there is already and album with the same name with the current logged in user. Why wont this work? sorry such an amateur question. Im learning :) All help appreciated.

$query_albumcheck = "SELECT * FROM albums WHERE owner = '$_COOKIE[email]' & name = '$_POST[albumname]'";

Posted: Sun Jul 08, 2007 3:32 pm
by volka
try

Code: Select all

$query_albumcheck = "SELECT * FROM albums WHERE owner = '$_COOKIE[email]' & name = '$_POST[albumname]'";
echo '<div>Debug: ', htmlentities($query_albumcheck), "</div>\n";
Does $query_albumcheck contain what you expect?

Re: Help with a PHP and mySql question.

Posted: Sun Jul 08, 2007 4:04 pm
by renatopedigoni
bos45430 wrote:$query_albumcheck = "SELECT * FROM albums WHERE owner = '$_COOKIE[email]' & name = '$_POST[albumname]'";
try

Code: Select all

$query_albumcheck = "SELECT * FROM albums WHERE owner = '".$_COOKIE['email']."' AND name = '".$_POST['albumname']."'";

Posted: Sun Jul 08, 2007 11:52 pm
by bos45430
THANKS! That worked! You guys kick gerbal ass.