Xtremer360 Posted February 13, 2009 Share Posted February 13, 2009 It's not showing the label next to the show name and I don't know why. I'm not getting an error. printf ( "<tr class=\"%s\">", $sClass ); print "<td valign=\"top\" align=\"center\" width=\"30\"><a href=\"#\" onclick=\"editbooking('editbooking', 'content' , '". $row ['id'] ."'); return false;\">Edit</a></td>"; printf ( "<td valign=\"top\">%s</td>", $row [showname], $row [label] ); printf ( "<td align=\"center\" width=\"80\">%s</td>", $row [bookingdate] ); printf ( "<td align=\"center\" width=\"50\">%s</td>", $row [numberofmatches] ); printf ( "<td align=\"center\" width=\"100\">%s</td>", $row [status] ); print '</tr>'; Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/ Share on other sites More sharing options...
allworknoplay Posted February 13, 2009 Share Posted February 13, 2009 uhhh ok, what's your query? Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761517 Share on other sites More sharing options...
Xtremer360 Posted February 13, 2009 Author Share Posted February 13, 2009 query = "SELECT *, DATE_FORMAT(`bookingdate`, '%m-%e-%Y') AS bookingdate FROM shows WHERE `type` = 'Weekly Event' ORDER BY `showname`"; Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761523 Share on other sites More sharing options...
allworknoplay Posted February 13, 2009 Share Posted February 13, 2009 Ok, and I take query = "SELECT *, DATE_FORMAT(`bookingdate`, '%m-%e-%Y') AS bookingdate FROM shows WHERE `type` = 'Weekly Event' ORDER BY `showname`"; Ok, and I take it that you are getting output from the other values? Do you have access to mysql CLI? Do you get output from 'showname' in mysql? Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761531 Share on other sites More sharing options...
Xtremer360 Posted February 13, 2009 Author Share Posted February 13, 2009 Everything else shows but the show label. Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761532 Share on other sites More sharing options...
samshel Posted February 13, 2009 Share Posted February 13, 2009 not sure but u may try enclosing string array key in quotes. $row ['label'] Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761540 Share on other sites More sharing options...
The Little Guy Posted February 13, 2009 Share Posted February 13, 2009 printf ( "<td valign=\"top\">%s</td>", $row [showname], $row [label] ); You only have one %s, shouldn't you have 2, or only two parameters? Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761602 Share on other sites More sharing options...
Xtremer360 Posted February 13, 2009 Author Share Posted February 13, 2009 As I tried it Little Guy was correct thank you don't know how I could have missed that. Link to comment https://forums.phpfreaks.com/topic/145105-solved-not-showing-integer/#findComment-761605 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.