FUDforum: comp.lang.php » Pulling my hair out

Home » Imported messages » comp.lang.php » Pulling my hair out

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

Re: Pulling my hair out [message #172405 is a reply to message #172404]

Wed, 16 February 2011 18:01

Michael Fesser
Messages: 215
Registered: September 2010

Karma:

Senior Member

.oO(sheldonlg)

> I have this TRIVIAL code and I am pulling my hair out because of it:
>
> <?php
> function getAllEvents() {
> $sql = "SELECT * FROM events
> WHERE eventDate > NOW()
> ORDER BY eventDate LIMIT 4";
> print $sql;
> $result = mysql_query($sql);
> var_dump($result)
> $list = array();
> while ($row = mysql_fetch_assoc($result)) {
> $list[] = $row;
> }
> return $list;
> }
>
> with the two diagnostic included as above. I use the sequel statement
> in phpmyadmin and it yields four entries and they are correct. However,
> the var_dump results in boolean(false) and no results are extracted (of
> course).

What does mysql_error() say?

Micha

Report message to a moderator

[Message index]

		Pulling my hair out By: sheldonlg on Wed, 16 February 2011 17:51
		Re: Pulling my hair out By: Michael Fesser on Wed, 16 February 2011 18:01
		Re: Pulling my hair out By: sheldonlg on Wed, 16 February 2011 18:36
		Re: Pulling my hair out By: Denis McMahon on Wed, 16 February 2011 18:17
		Re: Pulling my hair out By: sheldonlg on Wed, 16 February 2011 18:38

Previous Topic:	Welcome to PhoToZfAiR
Next Topic:	PHP Malaysia Meetup 2011 : Framework Shootout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 09:04:11 GMT 2024

Total time taken to generate the page: 0.05005 seconds