[RESOLVED] IF THEN ELSE Statement not working.

[crzyman]

Can anyone please tell me why this isn't working and how I get it to work? Thanks.

$name = "#";

if ($name = "#") then
{$result = mysql_query("SELECT FROM artist WHERE(artist_name LIKE '1%' OR artist_name LIKE '2%' OR artist_name LIKE '3%' OR artist_name LIKE '4%' OR artist_name LIKE '5%' OR artist_name LIKE '6%' OR artist_name LIKE '7%' OR artist_name LIKE '8%' OR artist_name LIKE '9%' OR artist_name LIKE '0%') ORDER BY artist_name"); }
else
{$result = mysql_query("SELECT FROM artist WHERE artist_name LIKE '$name%' order by artist_name");}

[thorpe]

= is an assignment operator. you need to use == to compare values.

[tekky]

there is no 'then' keyword in PHP....

[crzyman]

Thanks. You are right, but it still will not work. Any ideas as to why?

[tekky]

crzyman wrote:

Thanks. You are right, but it still will not work. Any ideas as to why?

what are you using to validate working or not working?

resultsets? if so, does your SQL validate with phpMyAdmin...

[crzyman]

Great. Thank you tekky and thorpe. Between the two of you I got it to work. I appretiate you help. crzyman.