If data exists in the field print, else don't

If data exists in the field print, else don't

El Forum
Guest

#17

07-02-2009, 08:22 AM

[eluser]jedd[/eluser]
[quote author="slowgary" date="1246562183"]Oh...I see it. Your model is assigning the query results to $query but not returning any of it.[/quote]

[url="http://ellislab.com/forums/viewreply/603760/"]I wish I'd noticed that.[/url] Wink

Quote:Get rid of the variable and just return it directly.

For the sake of completeness, you'd probably want to check that you had something to return - say with num_rows - and perhaps return FALSE if you did not. I know you can check this at the other end - in the controller or even pass it straight to the view and let it deal with it - but I think it's more elegant to do this in the model, and always pass back consistently formatted data.

By consistently-formatted, I mean never passing NULL'd variables around unintentionally.

Messages In This Thread

If data exists in the field print, else don't - by El Forum - 07-01-2009, 05:00 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 05:28 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:15 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:24 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:36 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 06:52 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:00 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:12 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:13 PM

If data exists in the field print, else don't - by El Forum - 07-01-2009, 09:50 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:20 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:29 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:40 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 05:51 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:02 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:16 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:22 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:31 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 08:34 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 09:16 AM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:07 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:22 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 01:23 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:29 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 03:37 PM

If data exists in the field print, else don't - by El Forum - 07-02-2009, 05:09 PM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 12:44 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 12:55 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 03:58 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 08:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 08:16 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:00 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:33 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 09:49 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 10:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 10:08 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:01 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:08 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:38 AM

If data exists in the field print, else don't - by El Forum - 07-03-2009, 11:53 AM