FUDforum: comp.lang.php » MYSQL PHP Query Not Working

Home » Imported messages » comp.lang.php » MYSQL PHP Query Not Working

Show: Today's Messages :: Polls :: Message Navigator

Re: MYSQL PHP Query Not Working [message #185484 is a reply to message #185483]

Thu, 03 April 2014 16:18

Salvatore
Messages: 38
Registered: September 2012

Karma:

Member

On 2014-04-03, cuteywithlove(at)gmail(dot)com <cuteywithlove(at)gmail(dot)com> wrote:
> I've spent hours on this and can't understand why this doesn't work.
>
> [snip]
> $blog_id = filter_input(INPUT_GET, 'blogId', FILTER_SANITIZE_NUMBER_INT);
> [snip]
> if (!$stmt->bind_param("ii", $id, $blog_Id)) {
> [snip]
>
> If I copy and paste the query into phpmyadmin and run it with the values
> hard coded it works.
>
> No errors are returned.
>
> The user has privileges to delete and everything else.
>
> Is there anyway I can check it? or see any errors any other way?

The first thing I see wrong is that you mistyped "$blog_id" as
"$blog_Id".

--
Blah blah bleh...
GCS/CM d(-)@>-- s+:- !a C++$ UBL++++$ L+$ W+++$ w M++ Y++ b++

Report message to a moderator

[Message index]

		MYSQL PHP Query Not Working By: cuteywithlove on Thu, 03 April 2014 15:46
		Re: MYSQL PHP Query Not Working By: Salvatore on Thu, 03 April 2014 16:18
		Re: MYSQL PHP Query Not Working By: Jerry Stuckle on Thu, 03 April 2014 17:08
		Re: MYSQL PHP Query Not Working By: The Natural Philosoph on Thu, 03 April 2014 17:30
		Re: MYSQL PHP Query Not Working By: Jerry Stuckle on Thu, 03 April 2014 18:38
		Re: MYSQL PHP Query Not Working By: cuteywithlove on Fri, 04 April 2014 07:48
		Re: MYSQL PHP Query Not Working By: Erwin Moller on Fri, 04 April 2014 10:28
		Re: MYSQL PHP Query Not Working By: bill on Fri, 04 April 2014 10:45
		Re: MYSQL PHP Query Not Working By: M. Strobel on Sat, 05 April 2014 19:30

Previous Topic:	Strange but true! Working with interfaces in PHP
Next Topic:	PDF extract text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 02:37:35 GMT 2024

Total time taken to generate the page: 0.06946 seconds