Jump to content


Photo

query help please


  • Please log in to reply
1 reply to this topic

#1 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 20 April 2006 - 12:05 AM

How can i pull out the data with all the database values and results but it a user has posted twice the same result shows on the same page via there ip matches cheers.

i have tried list and each on a while loop but the order by ip didnt work any idears.

so if a user post 5 times, there information shown on one page but also shows all values and results ordered buy the ip matching.


$query="select feedback.name ,feedback.email , feedback.comment , feedback.stateus , 

feedback.department , feedback.spam , feedback.date , feedback.time , feedback.ip from 

feedback where name like '%".$name."%'";
$result=mysql_query($query);



Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#2 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 20 April 2006 - 05:32 PM

what can i add at the end of my select query to get all members with the same ip displayed on a single page
any idears please cheers.

at the moment i use a while loop to get the ecohed results.

what about using the mysql num rows if result = ip will that get the users deatils together if the ip are the same.

$query="select feedback.name ,feedback.email , feedback.comment , feedback.stateus , 

feedback.department , feedback.spam , feedback.date , feedback.time , feedback.ip from 

feedback where name like '%".$name."%'";
$result=mysql_query($query);

while($record=mysql_fetch_assoc($result) {
while(list($title,$data)=each($result) {

echo"<br>'".$title."' : '".$data."'<br>";

}

echo"<br>"
}

Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users