Re: Why doesn't this simple query work?

hmmm i think you need to always have quotes around string regardless of if they are variables . . . $result = mysql_query("SELECT shootID FROM shoots WHERE (location='$location')"); ----- Original Message ----- From: "Seb Frost" <seb@raceshoot.com> To: "php-general" <php-general@lists.php.net> Sent: Thursday, July 26, 2001 3:10 AM Subject: [PHP] Why doesn't this simple query work? > Driving me mad. Works if I put a string in quote marks instead of the > variable $location. > > > $result = mysql_query("SELECT shootID FROM shoots WHERE > (location=$location)"); > > > This should work shouldn't it? If it's a problem with the variable being > embedded in the query what's the easiest way to overcome this? > > cheers, > > seb > > -----Original Message----- > From: Sheridan Saint-Michel [mailto:webmaster@foxjet.com] > Sent: 19 July 2001 14:50 > To: php-general > Subject: Re: [PHP] REGEXP > > > I am not sure if I am understanding you... but if you just want to return > the boundary try > > preg_match("|boundary=\"([^\"].+)\"|Uis", $text, $regs ); > $boundary = $regs[1]; > > I am guessing that you want the boundary from the lines > > to avoid regexp (too lazy) but now I want to use it. The final result I > > would need is: ------------B42DA66C4EC07C9B572A58FC so that I can search > > If you are looking for something else let me know > Sheridan > > > -----Original Message----- > > From: Adrian D'Costa [mailto:adrian@pcsadvt.com] > > Sent: Saturday, July 14, 2001 2:54 AM > > To: php general list > > Subject: [PHP] REGEXP > > > > Hi, > > > > I am trying to capture the Header from a mail for my webmail using php > > and > > pop3. The header is something like this: > > Content-Type: multipart/mixed; > > boundary="------------B42DA66C4EC07C9B572A58FC" > > > > When I use preg_split("/[\d;]*/", $buffer), I get > > Content-Type: multipart/mixed; > > > > What I want is to return the whole line split by the ";". I usually try > > to avoid regexp (too lazy) but now I want to use it. The final result I > > would need is: ------------B42DA66C4EC07C9B572A58FC so that I can search > > in the body of the message for the rest of the parts. > > > > Any pointers would be helpful. > > > > Adrian > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net