Help with the PHP coding....

[russellcox77777]

Hi

I wonder if anybody can help me code this page just to display "Travel Inn" records from the table "tickets2_info" in mysql

This is what I have but would also like to select the hotel "Travel Inn"

$sql = "select * from tickets2_info ORDER BY tickets2_info.ticket_id ASC";

*tickets2_info

$list .= "<td>".$row["hotel"]."</td>";
	  $list .= "<td>".$row["ticket_id"]."</td>";
	  $list .= "<td>".$row["name"]."</td>";
	  $list .= "<td>".$row["staff"]."</td>";
	  $list .= "<td>".$row["room"]."</td>";
	  $list .= "<td>".$row["email"]."</td>";
	  $list .= "<td>".$row["tel"]."</td>";
	  $list .= "<td>".$row["required"]."</td>";

The actual extract from "tickets2_info" is as follows:-

hotel,ticket_id,name,staff,room,email,tel,required
travelinn,1,russ,jim,121,[e-mail],1234,2
travelinn,2,russ,jim,122,[e-mail],1234,1
holidayinn,3,russ,jim,90,[e-mail],1234,1
marriott,4,russ,jim,84,[e-mail],1234,3

And so on!

I just want to select "travelinn" and display only these records on the page.

Does this make sense?

Thanks

Russ

[Installer]

$sql = "SELECT * FROM tickets2_info WHERE hotel = 'travelinn' ORDER BY ticket_id ASC";

should do it.

[russellcox77777]

You are a star!!!!!!!!!!!

$sql = "select * from tickets2 where used = 'Y' ORDER BY tickets2.expires ASC";

*tickets2

$list .= "<td>".$row["hotel"]."</td>";
	  $list .= "<td>".$row["id"]."</td>";
	  $list .= "<td>".$row["user_id"]."</td>";
	  $list .= "<td>".$row["used"]."</td>";
	  $list .= "<td>".$row["username"]."</td>";
	  $list .= "<td>".$row["password"]."</td>";
	  $list .= "<td>".$row["registered"]."</td>";
	  $list .= "<td>".$row["expires"]."</td>";
	  $list .= "<td>".$row["reminder_sent"]."</td>";

How can I also extract just "Travel Inn" from this table?

Thanks

Russ

[russellcox77777]

I want to show used = 'Y' and hotel = 'Travel Inn'

[russellcox77777]

Yes - got it!!!!!!!!!!!!!!!

$sql = "select * from tickets2 where used = 'Y' and hotel = 'holiday inn' ORDER BY tickets2.expires ASC";

Thanks Installer for your help!

Russ

[thorpe]

thanks for the multipost!!!!!!!!!!!!!!