Posted 16 March 2003 - 05:24 AM
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.
Now I get a link that is something like this:
¿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\'\";
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..
Posted 16 March 2003 - 06:20 AM
print "<a href=\'".$param[\'link_on_day\'].$current_year.$current_month_2.$i_2."\'>".$i."</a>";
Hope that helps.
Posted 16 March 2003 - 02:39 PM
$output .= \'<TD class="calendarDays\'.$param[\'calendar_id\'].\'"><A href="\'.$param[\'link_on_day\'].$current_year.$current_month_2.$i_2.\'">\'.$i.\'</A></TD>\'."n";
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..
Posted 16 March 2003 - 07:36 PM
Let us know what error you get.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users