Jump to content


Photo

Variable problem


  • Please log in to reply
3 replies to this topic

#1 elnuevo

elnuevo
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 16 March 2003 - 05:24 AM

Hi.. I´m having some problem with variables..
I´m working on a calendar that gets info from a database everytime a day or month is clicked... It´s a downloaded code. So the code declares this variables.. (among others.. I just put here the ones I´m trying to work with)..

$param_d[\'link_on_day\'] = $PHP_SELF.\'?date=\';

$current_day = date(\"d\", $timestamp);
$current_month = date(\'n\', $timestamp);
$current_month_2 = date(\'m\', $timestamp);
$current_year = date(\'Y\', $timestamp);

Later on the script it makes the link with those variables for each day.

<A=\"\'.$param \'link_on_day\'].$current_year.$current_month_2.$i_2.\'\">\'.$i.\'</A>


Now I get a link that is something like this:

/calend?date=20030508

¿How can I use these to grab the rows I need from the DB... ?

I´ve tried something like this with all the variables.. but It doesn´t work

@mysql_select_db($database) or die( \"No hay base de datos\");
$query=\"SELECT * FROM agenda WHERE mes=\'.$current_month\'\";
$result=mysql_query($query);

I don´t why it doesn´t read the variables.. I´ve tried using echo to see if it´s getting the value.. but it isn´t..
I know is probably a stupid thing.. but I can´t figure it out..
And yes I´m reading the Manual and I´m getting a book next week, but until then I won´t sleep well..
Thanx..

#2 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 16 March 2003 - 06:20 AM

Your link is strange, but try this:
print "<a href=\'".$param[\'link_on_day\'].$current_year.$current_month_2.$i_2."\'>".$i."</a>";

Hope that helps.

#3 elnuevo

elnuevo
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 16 March 2003 - 02:39 PM

Sorry, I wrote the link wrong. The whole line is like this

$output .= \'<TD class="calendarDays\'.$param[\'calendar_id\'].\'"><A href="\'.$param[\'link_on_day\'].$current_year.$current_month_2.$i_2.\'">\'.$i.\'</A></TD>\'."n";


And the
/calend?date=20030508
Is just the path that the browser shows for each day (obviously the numbers change for each day).

And sorry again, I´m EL Nuevo, so I still don´t get how can I use this variables to get the stuff to show from my table. I keep getting a Mysql error telling me that supplied argument is not valid when cheking for num_rows, so I assume that the variable $current_whatever is not valid so the num_rows result is 0.
I´ve tried just echoeing or printing the value of $current_whatever to see if it´s getting any.. but it is not..
Any clues?

#4 metalblend

metalblend
  • Members
  • PipPipPip
  • Advanced Member
  • 89 posts
  • LocationCalifornia, USA

Posted 16 March 2003 - 07:36 PM

Try using this:[php:1:ad01b63d88]mysql_query(\"SELECT * FROM agenda WHERE mes=\'\".$current_month.\"\'\") or die(mysql_error());[/php:1:ad01b63d88]

Let us know what error you get.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users