markspec87

I have a whois checker that stores the domain in $domain. When they click order i want the php page to pass the variable $domain to the order page so it can be display. "you are purchased the domain $domain" I know this is probably really simple but i dont know how to do it. thanks :)

[!--quoteo(post=381368:date=Jun 8 2006, 02:46 PM:name=wisewood)--][div class=\'quotetop\']QUOTE(wisewood @ Jun 8 2006, 02:46 PM) [snapback]381368[/snapback][/div][div class=\'quotemain\'][!--quotec--] Create reports.php to the layout etc that you want, and select your info from the database as follows SELECT * FROM reports WHERE report_id = $_GET[id] Obviously replacing reports with your table name, and report_id with the name of the field that you auto-increment. [/quote] Thanks for that, i think ill give that a try first, seems a lot simpler then what i had in mind.

I didnt knwo what to put for the title because this is quite a range of things. Basically im making a html form, that admins can fill in and when they click sumbit, php will create a new html page, save it with all the variables in, and then display the recently added article in the last 5 added. Now vie got the form to put the information in the databse. Wisewood is hopefully sending me a script so i can learn how to create the html but my questio nis, how can i increment its name. When it saves i wanted it to be called "report#.html" basically, ill use the autonumber from the table to create the number #. my question is basically, is this do able? I can use the autonumber to reference the links on the main page? I was also thinking it could be masked by a one of those dynamic links like "index.php?reportid=2" How exactly do those kinds of links work? thanks.

markspec87@gmail.com i PMed you :)

i would be grateful if you could send me the code aswell :)

ah thanks mate works a treat. Your a life Saver :)

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Parse error: parse error, unexpected '{' in /home/terraarm/public_html/index.php on line 106[/quote] :(

Error: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 5 in /home/terraarm/public_html/index.php on line 108[/quote] Code: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]$query="SELECT * FROM news ORDER BY datum DESC LIMIT 1,1"; $result=mysql_query($query); $num=mysql_numrows($result); $i=1; $author2=mysql_result($result,$i,"author"); $text2=mysql_result($result,$i,"text"); $datum2=mysql_result($result,$i,"Datum"); $readmore2=mysql_result($result,$i,"readmore"); $image2=mysql_result($result,$i,"image"); $title2=mysql_result($result,$i,"title"); $summary2=mysql_result($result,$i,"summary"); ?>[/quote] Any ideas whats wrong? (The DB is def setup correctly, i.e the row exists.)

I put that in but then i get this error: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: mysql_result(): Unable to jump to row 2 on MySQL result index 5 in /home/.... file.php on line 110[/quote] I definitely have the records in my DB to display so im a bit stuck.

[!--quoteo(post=380426:date=Jun 6 2006, 01:11 AM:name=redarrow)--][div class=\'quotetop\']QUOTE(redarrow @ Jun 6 2006, 01:11 AM) [snapback]380426[/snapback][/div][div class=\'quotemain\'][!--quotec--] first have you got php installed and second have you got mysql or database installed. if you have the above then you need to first make the form the form will have to have the information as needed, example name surname email address age ect.............. when you no that bit then tell us then we can help ok. [/quote] I dont think hes come here not knowing some basic html or knowing how to make a form.... I know how to create a page with certain variables but i actually know how to get php to create it on its own, maybe the guy in this thread can help you. [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=95063\" target=\"_blank\"]http://www.phpfreaks.com/forums/index.php?showtopic=95063[/a] hope that helps.

[!--quoteo(post=380670:date=Jun 6 2006, 06:10 PM:name=ober)--][div class=\'quotetop\']QUOTE(ober @ Jun 6 2006, 06:10 PM) [snapback]380670[/snapback][/div][div class=\'quotemain\'][!--quotec--] [code] if($result && mysql_num_rows($result) > 0) // error checking {      while($row = mysql_fetch_array($result))      {           echo $row['column1'];           echo $row['column2'];      } } [/code] [/quote] thats almost what im looking for, however this outputs all the fields in those columns. I just want to output say the 2nd last added record, or the 3rd added record on thier own. thanks for your help.

yeh in my actual databse is called "datum". So Say in my table on my website. What code would i use to display the 2nd last record from the column "newstext". or the 2nd last date a news page was published.

Hey guys, What i need to do is select the two last added articles from the table "news" and display them on my front page. I need to, say, when i have selected the 2nd last added item display only one particular column. I.e the newstext column. [a href=\"http://img339.imageshack.us/img339/3136/example0fh.jpg\" target=\"_blank\"]http://img339.imageshack.us/img339/3136/example0fh.jpg[/a] And when a new item is added to DB, the news will drop down one, and the old "2nd to last added" will drop off. I am unsure on how to select both an individual record field, like "Newstext" and also how to select say the 2nd or 3rd last added entry. Sorry for bad explanation but thats the best i can do :) hope you guys can help me out here. Ive been stuck on this for a week or so.