NamePros
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.

Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
FAQ & TOS Register Search Today's Posts Mark Forums Read

Go Back   NamePros.com > Website Development Discussion Forums > Programming
Reload this Page Fix this script attempt?

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.

Advanced Search


Closed Thread
 
LinkBack Thread Tools
Old 03-01-2007, 04:09 PM THREAD STARTER               #1 (permalink)
Senior Member
 
Shorty's Avatar
Join Date: Sep 2005
Location: England
Posts: 1,034
Shorty is just really niceShorty is just really niceShorty is just really niceShorty is just really nice
 



Fix this script attempt?


Hey guys, I've got to make a hotel booking system in PHP and MySQL for a project, and i've ran into a brick wall. I'm working on the part where I check to see if the slot a user wants is available.

This a bit more complicated than it sounds. First of all the user also specifies a room type, so I first have to get a list of all rooms in the room table where the room type is what the user inputted.

I then have to take the roomid, and check the bookings table to see if there's a booking with that roomid during the given period, based on a start date and duration given in the form.

I have this:
http://pastebin.com/891815

As a rough idea, but I wrote it on the fly so I didnt test it as it went along. I'm hoping thats a sound enough basis for a kind person to repair the script, mainly the SQL query which I basically guessed.
????: NamePros.com http://www.namepros.com/programming/300104-fix-this-script-attempt.html

If you want paying post your price here and i'll consider it. Thanks!
Shorty is offline  
Old 04-03-2007, 03:49 AM   #2 (permalink)
NamePros Member
Join Date: Sep 2005
Posts: 32
artofmobile is an unknown quantity at this point
 



Check this link, http://pastebin.com/891815, I gotta an error 145:

Query failure: Can't open file: 'pastebin.MYI'. (errno: 145)
select *,date_format(posted, '%a %D %b %H:%i') as postdate from pastebin where pid='891815' and domain=''


Error 145 refers to:

# perror 145
MySQL error code 145: Table was marked as crashed and should be repaired
artofmobile is offline  
Old 04-03-2007, 09:32 AM   #3 (permalink)
NamePros Expert
 
Peter's Avatar
Join Date: Nov 2003
Location: Scotland
Posts: 5,069
Peter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond repute
 


Child Abuse Save The Children Save The Children Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009
Yes looks like pastebin have got database problems at the moment.
Peter is offline  
Old 04-03-2007, 09:39 AM   #4 (permalink)
Senior Member
 
Hitch's Avatar
Join Date: Aug 2005
Location: Uk, South Yorkshire
Posts: 1,225
Hitch is a splendid one to beholdHitch is a splendid one to beholdHitch is a splendid one to beholdHitch is a splendid one to beholdHitch is a splendid one to beholdHitch is a splendid one to beholdHitch is a splendid one to behold
 


Winner
PHP Programming - May 2007
Animal Rescue Third World Education Find Marrow Donors!
The PasteBin Error is still there for me too.

Though, i suggest you read up on LEFT JOIN
__________________
Cueburst - Support System - FAQ Knowledge Base, Tickets and more.
Hitch is offline  
Old 04-03-2007, 09:56 AM   #5 (permalink)
NamePros Regular
 
bliss's Avatar
Join Date: Dec 2005
Posts: 951
bliss is a name known to allbliss is a name known to allbliss is a name known to allbliss is a name known to allbliss is a name known to allbliss is a name known to allbliss is a name known to allbliss is a name known to all
 



Sounds pretty easy to code. What is the exact problem?
bliss is offline  
Old 04-03-2007, 10:51 AM   #6 (permalink)
NamePros Regular
Join Date: Jul 2006
Location: England
Posts: 722
chicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to allchicker is a name known to all
 


Save The Children
Past bin is amiting to problems:

Quote:
Problems

Sorry folks, this hasn't been performing too well recently. Fixes are coming!
Maybe use another paste bin type site
chicker is offline  
Old 04-03-2007, 10:59 AM THREAD STARTER               #7 (permalink)
Senior Member
 
Shorty's Avatar
Join Date: Sep 2005
Location: England
Posts: 1,034
Shorty is just really niceShorty is just really niceShorty is just really niceShorty is just really nice
 



Dont worry about this any more guys, thanks for your replies though.

On a side note, how long has pastebin been malfunctioning?
Shorty is offline  
Old 04-04-2007, 07:59 PM   #8 (permalink)
Senior Member
 
superprogrammer's Avatar
Join Date: Aug 2004
Location: Washington
Posts: 4,327
superprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud ofsuperprogrammer has much to be proud of
 



Are you talking about this?
http://pastebin.com/
__________________
Download youtube videos at www.HugYouTube.com -NO LINKS TO PARKED PAGES-
Anonymous access at www.Banned.net
superprogrammer is offline  
Old 04-05-2007, 01:00 AM   #9 (permalink)
NamePros Expert
 
Peter's Avatar
Join Date: Nov 2003
Location: Scotland
Posts: 5,069
Peter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond reputePeter has a reputation beyond repute
 


Child Abuse Save The Children Save The Children Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009 Help The Homeless - Holiday 2009
yes, if you look at the original post and click on the link you will see the problem.
Peter is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


Liquid Web Smart Servers  
All times are GMT -7. The time now is 10:15 PM.

Managed Web Hosting by Liquid Web
Domain name forum recommended by Domaining.com Powered by: vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0 Ad Management plugin by RedTyger