[RESOLVED] Pinting more rows?

[crazylegseddie]

Hi just a quick query

currently using this code

$query  = 'SELECT cl.Client_ID,cl.Last_Name, cl.First_Name, p.Pet_ID, p.Name, p.Species 
FROM client as cl, pet as p 
where p.Client_ID = cl.Client_ID';
$result = @mysql_query($query) or die('<p>Sorry, no data to edit...</p>');
?>

  <select name="Pet_ID" id="selectClient">
<?php
while($row=mysql_fetch_assoc($result)) printf("\t<option value=\"%d\">%s, %s</option>\n",$row['Pet_ID'],$row['Last_Name'],$row['First_Name'],$row['Name'],$row['Species']);
?>

only prints the Last Name & First Name but i need it to print the Name and Species in the list menu! How do I achieve this?

Thank you in advance

[bradgrafelman]

Read the manual on [man]printf/man - there's only 3 directives in your format string, so it naturally only takes the first three arguements.

If you're not comfortable with the printf() functions... don't use them! Just do normal echo()'s...

while($row = mysql_fetch_assoc($result)) {
     echo "\t<option value=\"" . $row['Pet_ID'] . '">' . $row['Last_Name'] . '...'; // etc.
}

[crazylegseddie]

thank you 🙂