Jump to content

Archived

This topic is now archived and is closed to further replies.

redarrow

query help please

Recommended Posts

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.

[code]

$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);


[/code]

Share this post


Link to post
Share on other sites
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.

[code]
$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>"
}
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.