PHP Help

[iUnknown]

Hello,

$get_spy_info = mysql_query("SELECT 'Radio_IP1', 'Radio_Port1', 'Radio_IP2', 'Radio_Port2', 'Radio_IP3', 'Radio_Port3', 'Radio_IP4', 'Radio_Port4', 'Radio_IP5', 'Radio_Port5' FROM radio_spy FROM 'radio_spy' WHERE id='1'") or die(mysql_error());

Could anyone tell me what's wrong with this sytax?

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM 'radio_spy' WHERE id='1'' at line 1

I'm attempting to make a script, for experience with PHP as well as use.

Fastest, best solution will get +rep. Thanks.

[Dentafrice]

Because you specify FROM radio_spy twice..

<?php
$get_spy_info = mysql_query( "SELECT 'Radio_IP1', 'Radio_Port1', 'Radio_IP2', 'Radio_Port2', 'Radio_IP3', 'Radio_Port3', 'Radio_IP4', 'Radio_Port4', 'Radio_IP5', 'Radio_Port5' FROM radio_spy WHERE id='1'" ) or die( mysql_error() );
?>

If you are going to use that much, just use a wildcard * and then you can just pull it out of the array, without having to specify those, you are probably not working on a highly used application, so specifying what you are selecting isn't needed.

[iUnknown]

Removed that, silly me, still same error

Edit: Ok done as you've said but still same error.

[Dentafrice]

Whoops.

<?php
$get_spy_info = mysql_query("SELECT * FROM radio_spy WHERE id='1'") or die(mysql_error());
?>

[iUnknown]

Whoops.

<?php
$get_spy_info = mysql_query("SELECT * FROM radio_spy WHERE id='1'") or die(mysql_error());
?>

Ah that works now. Thanks +rep