mysql_fetch trouble.

[dubc07]

How can i make this work.

<?php
$month ="july";
$day ="29";

  //display all the news
   $result = mysql_query('SELECT * FROM `rentem` WHERE month="'.$month.'" day="'.$day.'"' ); 

?>

[GingerRobot]

Is this a joke? Make what work? What doesn't work? What would you like it to do?

[dubc07]

I'm trying to call from the database where month = july & day = 29

$result = mysql_query('SELECT * FROM `rentem` WHERE month="'.$month.'" day="'.$day.'"' ); ////does not work///

 

error message = Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

 

Just trying to see if it is possible to get data like this.

 

By the way I'm pretty new to php stuff so give me a break.

[kenrbnsn]

I don't see a mysql_fetch_array() in the quoted code, but you should do:

<?php
$q = "SELECT * FROM `rentem` WHERE month='".$month."' day='".$day."'";
$result = mysql_query($q) or die("Problem with the query: $q on line " . __LINE__ . '<br>' . mysql_error());
?>

so you can see whether the query actually worked.

 

Ken