Maian Script World Support Forums / Receipe of the day

Re: Receipe of the day

dummy@example.com (msworld) — Thu, 22 Mar 2012 15:45:22 +0000

Its always random above. To have the same don`t use random.

Re: Receipe of the day

dummy@example.com (duceduc) — Thu, 22 Mar 2012 10:57:43 +0000

This gives me an idea.

What if we want the same image to stay for one day, when we refresh the page, will the image/recipe change as well?

Re: Receipe of the day

dummy@example.com (msworld) — Thu, 22 Mar 2012 07:31:45 +0000

Hi Lecra,

This isn`t so difficult, so here goes:

1. First you need to get a random recipe:

$q = mysql_query("SELECT * FROM mr_recipes WHERE enRecipe = 'yes' ORDER BY rand() LIMIT 1");
$RECIPE = mysql_fetch_object($q);

So, the $RECIPE object now holds the info you need. Title would be:

echo $RECIPE->name;
?>

2. Next grab an image. You can do random for that too if there are more than 1:

$q2 = mysql_query("SELECT * FROM mr_pictures WHERE recipe = '{$RECIPE->id}' ORDER BY rand() LIMIT 1");
$IMG = mysql_fetch_object($q2);

3. Display image:

picPath; ?>" alt="" title="" />

Try that. I`ll leave you to the design part of things.

Receipe of the day

dummy@example.com (lecra) — Wed, 21 Mar 2012 10:17:24 +0000

Hi all,

Anybody that has already implemented, or is willing to help me in implementing a 'recipe of the day' on the front side?

The idea is to pick up a randomly recipe from the database and put the title, and a possible image on the front side. Clicking on it (image or title) would forward the user to the recipe.

I have no clue how to implement it as I'm completely a PHP noob!

Any volunteers?

KR; Lecra