killerbud99

[quote author=opioq link=topic=111488.msg472767#msg472767 date=1164316619] I am having this error when trying to purchase a spot on the train Error: Can not perform query select count(*) as count from whore_purchase where user_id = 5 and myspace_id = '1342355' and train_id = 7 and train_position = 1 and round = 141 and transaction_status = 'requested'. Unknown column 'user_id' in 'where clause' Server busy. Try later How did you fix your error? Where is the field that you chaned? [/quote] In your sql Table: whore_purchase I changed The field from id to user_id and this corrected the problem

Hello, I am asking a question refering to this on the main page [url=http://www.phpfreaks.com/tutorials/142/0.php]http://www.phpfreaks.com/tutorials/142/0.php[/url] I want to view the output of a sql as html or php as so it can be viewed as such not as a list [code]      // echo out the results to the screen   while ($list = mysql_fetch_array($result)) {       echo "{$list['image_url']} <br>";   } // end while[/code] Also I would like to pull more info not just the ['image_url'] can this be done? Thanks in advance  :)

Thanks Andy for your quick and correct reply  :) The field was set to id insted of user_id I changed this and it now works. Thanks again for your help

Hello all, I have a question I have a script that is giving me errors. Basicly the script allows a user to Purchase a spot on a myspace train. When the user clicks on Purchase they are directed to a page that allows them to choose there spat and a price. When the user chooses it should call the database and collect the users info and then direct them to the paypal payment page. The error I get is. Error: Can not perform query select count(*) as count from whore_purchase where user_id = 2 and myspace_id = '35453393' and train_id = 21 and train_position = 20 and round = 5 and transaction_status = 'requested'. Unknown column 'user_id' in 'where clause' I have created a demo account [url=http://www.gamehost-online.com/train/login.php]http://www.gamehost-online.com/train/login.php[/url] The user name is demo and the password is 012345 these are all numbers. You can check the purchase script here [url=http://www.gamehost-online.com/train/buy.php?train_id=21&position=20]http://www.gamehost-online.com/train/buy.php?train_id=21&position=20[/url] The script was obtained from here [url=http://www.smarterscripts.com/myspace-whore-train/]http://www.smarterscripts.com/myspace-whore-train/[/url] Please let me know if you need more info and I will provide. Thanks in advance for your support.