php, mysql from_unixtime

[darryncooke]

I have a select function in php.

$month_recordEventsmonth = "April";
if (isset($_GET['month'])) {
  $month_recordEventsmonth = $_GET['month'];
}
mysql_select_db($database_theGREENbar, $theGREENbar);
$query_recordEventsmonth = sprintf("SELECT * FROM wp_cgm_cal_entries WHERE FROM_UNIXTIME(start_date_time) = %s", GetSQLValueString($month_recordEventsmonth, "text"));
$recordEventsmonth = mysql_query($query_recordEventsmonth, $theGREENbar) or die(mysql_error());
$row_recordEventsmonth = mysql_fetch_assoc($recordEventsmonth);
$totalRows_recordEventsmonth = mysql_num_rows($recordEventsmonth);

Using

FROM_UNIXTIME(start_date_time, "%M")

did not work (however it works as a select statement in MySQL). Neither does what i have now. I need the timestamp to equal the month that is being passed in the url.

any help is appreciated.

thank you,

Darryn Cooke

http://www.darryncooke.com

| The New Orange County Graphic designer and Marketing and Advertising Consultant

http://www.bloobie.com

| Marketing and Advertising blog

 

[jpadie]

you forgot the quotes

$query_recordEventsmonth = sprintf("SELECT * FROM wp_cgm_cal_entries WHERE FROM_UNIXTIME(start_date_time) = [red]'[/red]%s[red]'[/red]", GetSQLValueString($month_recordEventsmonth, "text"));
$recordEventsmonth = mysql_query($query_recordEventsmonth, $theGREENbar) or die(mysql_error());

 

[darryncooke]

that gave me this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'April''' at line 1

Darryn Cooke

http://www.darryncooke.com

| The New Orange County Graphic designer and Marketing and Advertising Consultant

http://www.bloobie.com

| Marketing and Advertising blog

 

[darryncooke]

I figured it out

$colname_recordEventsmonth = "April";
if (isset($_GET['month'])) {
  $colname_recordEventsmonth = $_GET['month'];
}
mysql_select_db($database_theGREENbar, $theGREENbar);
$query_recordEventsmonth = sprintf("SELECT *, FROM_UNIXTIME(start_date_time, '%%M') AS month FROM wp_cgm_cal_entries WHERE FROM_UNIXTIME(start_date_time, '%%M') = %s", GetSQLValueString($colname_recordEventsmonth, "text"));
$recordEventsmonth = mysql_query($query_recordEventsmonth, $theGREENbar) or die(mysql_error());
$row_recordEventsmonth = mysql_fetch_assoc($recordEventsmonth);
$totalRows_recordEventsmonth = mysql_num_rows($recordEventsmonth);

Darryn Cooke

http://www.darryncooke.com

| The New Orange County Graphic designer and Marketing and Advertising Consultant

http://www.bloobie.com

| Marketing and Advertising blog

 

[jpadie]

unless getsqlvaluestring is a function that also enquotes variables, you will still need to enquote the %s.