please correct my SQL

[Anon]

I'm trying to get my test table to join with my login table where the ID's are the same where the registration number ='s 7234907, then print the table. This doesn't work.

$result3 = mysql_query( "SELECT * FROM test JOIN login ON test.id = login.id WHERE registration = '7234907'" );
print "<table border=1\n";
while ( $a_row = mysql_fetch_row( $result3 ) )
{
print "<tr>\n";
foreach ( $a_row as $field )
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n<br><hr size=\"1\">";

[Anon]

SELECT n,... FROM test LEFT JOIN login ON test.id = login.id WHERE ??.registration = '7234907'

?

[[deleted]]

"this doesn't work" could mean an hundred things.

What exactly is going wrong? any error messages?

Anyway, I presume a registration NUMBER is stored in the database as an INT, not a string.
Try leaving out the quotes around the 7234907

Also, you may want to change the 'JOIN' to 'LEFT JOIN'

[pblamire]

$result3 = mysql_query( "SELECT *
FROM test AS t
JOIN login AS l ON t.id = l.id
WHERE l.registration = '7234907'" );

print "<table border=1\n";
while ( $a_row = mysql_fetch_row( $result3 ) )
{
print "<tr>\n";
foreach ( $a_row as $field )
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n<br><hr size=\"1\">";