problem in mysql query

Replies

• 

  Manish Goyal

  cummon ceans
  can anyone help me...??please suggest me something..
• 

  madhumurundi

  hi,
  for your problem go through this link SQL Server Tips, Techniques and Articles
• 

  Manish Goyal

  which link dude??
• 

  gohm

  the link has been removed
• 

  Manish Goyal

  hey i have not got any reply...
  can't any one solve my problem or my query is ill-logical according to you guys??
• 

  Manish Goyal

  Hello guys..I have seen most of guys have seen this problem ..but no replies ..But atlast I myself find the solution...
  have a look on this link
  #-Link-Snipped-#
• 

  Manish Goyal

  Orton39

  My friend Yelgnidroc thanks for your answer.I guess i made a mistake posting the code from the window of the query in Dreamweaver.
  I better give you the full code of the query so you can understand if i make a mistake somewhere.
  
  Code:
  

      = %s) AND housenumber = %s) OR ((checkin <= %s AND checkout >= %s) AND housenumber = %s)", GetSQLValueString($fromdate_availabilityCheck, "date"),GetSQLValueString($fromdate_availabilityCheck, "date"),GetSQLValueString($house_availabilityCheck, "text"),GetSQLValueString($todate_availabilityCheck, "date"),GetSQLValueString($todate_availabilityCheck, "date"),GetSQLValueString($house_availabilityCheck, "text"));
  $availabilityCheck = mysql_query($query_availabilityCheck, $BookingDB) or die(mysql_error());
  $row_availabilityCheck = mysql_fetch_assoc($availabilityCheck);
  $totalRows_availabilityCheck = mysql_num_rows($availabilityCheck);
  ?> 
  

  Now i think you can see if all is ok in the query.
  Thanks for your interest

  Thanks orton for showing you interest..My problem is to give access to database that is created in my computer...via internet
  I am using command prompt .....I don't want any code..I simply want a query ..is there any??