Home :: Forums :: Register :: Sign In :: Links :: Downloads :: Shop
You are not signed in. Please sign in. If you have not registered, please click here.
Go Back Home >> Forums >> General PHP Nuke Help
Reload this Page Displaying more than one SQL Query in the same place

Displaying more than one SQL Query in the same place

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb   More...
#1. Thu Aug 26, 2004 11:02 am   Displaying more than one SQL Query in the same place
SpLiNteR
CZ Addict
SpLiNteR has been a member for over 4 year's 4 Year Member
uk.gif
Occupation: Student
Age: 18
Fav. Sports Team: Leeds United
Website: www.clan-tfp.co.uk
 Status: Offline
Joined: Feb 08, 2004
0.23 posts per day
Posts: 397
Points: 206,328
AIM Address Yahoo Messenger MSN Messenger ICQ Number
Hey, i'm busy there working away on my site, so i've got a search function on my site and it's working, yes i know it's amazing it worked! So, what i want is the title of the search result to also link to the page which has got that content on like normal search engines do. I just can't figure out how to do it, i tried seperating with a comma eg.

<?php echo $row_rsSearch['gameTitle', 'gameLink']; ?>


But that gives errors. I know it's possible but i don't have much of an understanding of PHP and MySQL so i don't know how to do that. Oh and what should the link on the database be, as in, where should i be relative from, or should it just be [ Register or login to view links on this board. ] ? If it's relative, should it be relative from the public html folder?

EDIT:: I've thought about this some more and spoken with someone about it, apparantly it would be better to have reviews with dynamically generated URLs rather than a static one. Although, this would mean all content needs to be access via the database.



_________________
Image
Back to top Reply with quote
#2. Thu Aug 26, 2004 9:21 pm   re: Displaying more than one SQL Query in the same place
Kelly_Hero
PayPal Donation
Asst. Admin
 Codezwiz Site Donator
Kelly_Hero has been a member for over 5 year's 5 Year Member
usa.gif southcarolina.gif
Occupation: Web Developer
Age: 43
Website: www.myleague.com/bandr
 Status: Offline
Joined: Aug 20, 2003
1.95 posts per day
Posts: 3763
Points: 351,412
   
This is how the link would look.
<?php echo "<a href='www.mysite.com/results.html?page=$pageurl'>" . $row_rsSearch['gameTitle'] . "</a>"; ?>


$pageurl would be called from a table in your database that holds the page urls. The ?page=$pageurl part after the address passes the information through the url. You would retrieve that information in the next page using $_GET[$pageurl];
Back to top Reply with quote
#3. Sat Aug 28, 2004 2:52 pm   re: Displaying more than one SQL Query in the same place
SpLiNteR
CZ Addict
SpLiNteR has been a member for over 4 year's 4 Year Member
uk.gif
Occupation: Student
Age: 18
Fav. Sports Team: Leeds United
Website: www.clan-tfp.co.uk
 Status: Offline
Joined: Feb 08, 2004
0.23 posts per day
Posts: 397
Points: 206,328
AIM Address Yahoo Messenger MSN Messenger ICQ Number
Thanks kelly it work great icon_biggrin.gif




_________________
Image
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb   More...
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum