wrong ouputs with php and mysql!!
ok below i have the following php code
im trying to match up to tables so i get a better and more descriptive output rg instead of and number "80" i want to output " port http-web" i thought i had it with the mysql statement below but ouputs are wrong like they dont match at all Domain Name Server 69 Domain Name Server 53 PHP Code:
|
Hard to say without knowing the other 2 SELECTs...
|
Code:
$sql = ("SELECT * FROM udphdr "); |
The results of the queries have no 'link' between them and the three results are correct, but they can go in any order. I think there can be only one SELECT used, but I don't understand the meaning fully so I don't know how to write it. COuld you explain what you'd like to get exactly (what should be the connections between results of the three queries)?
|
well one of the statements just outputs all info from a database while the other 2 are doing the same thing as each other.
i want to match up data in the udphdr table with the services table (both in the same database) instead of getting an output of lets say 80 i want to take that 80 and match it up with what the services tables says what 80 represents via the field description i kinda know why i have to only use one select statement thought by doing it this way would work too but how do i go about using one select statement i think if i do some kind of order in them i might be able to match and link them up what do ye think!? |
I think that the query may be
Code:
SELECT udphdr.cid, udphdr.sid, udphdr.udp_sport, udphdr.udp_dport, |
All times are GMT -5. The time now is 12:01 PM. |