I'm having trouble forming the query to my database properly to retrieve the info I'm needing. All I'm trying to get is a single result where the DAY column of the DB is the same as today's day name and the START column (which is a time field) is less than the current time.
Here's the code I have:
CODE
// Query the DB and retrieve the program information from the table
$result = mysql_query("SELECT * FROM `programming` WHERE DATE = DAYNAME() AND START < CURRENT_TIME() LIMIT 1");
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
while ($row = mysql_fetch_assoc($result)) {
echo '<p class="now"><strong>On Air Now:</strong> '.$row["NAME"].'<br />'.$row["HOST"].'</p>';
}
?>
And here's the error message I'm getting:
Invalid query: 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 ') AND START < CURRENT_TIME() LIMIT 1' at line 1
Whole query:
jeffmc21 Trouble forming MYSQL query properly 25 Aug, 2009 - 09:54 AM
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
25 Aug, 2009 - 09:54 AM
| 
