TalkPHP - View Single Post

marxx · 03-20-2008, 10:44 AM

I've seen couble ways ppl to code query but now I just have to ask it from here.

Below is three examples and question is: Does it really matter how to do it?

example 1:

Code:

$query = "SELECT * FROM ´mytable´ WHERE slogan = 'kicksass'";
$do_it = mysql_query($query) or die(mysql_error());

$showme = mysql_fetch_array($do_it);

example 2:

Code:

$query = mysql_query("SELECT * FROM ´mytable´ WHERE slogan = 'kicksass'") or die(mysql_error());

$showme = mysql_fetch_array($query);

example 3: (my fav because can do it in one line)

Code:

$showme = mysql_fetch_array(mysql_query("SELECT * FROM ´mytable´ WHERE slogan = 'kickass'")) or die(mysql_error());

Thanks for all.. =)

03-20-2008, 10:44 AM	#1 (permalink)
marxx The Contributor Join Date: Sep 2007 Location: Finland Posts: 45 Thanks: 3	Does it matter how to code query? I've seen couble ways ppl to code query but now I just have to ask it from here. Below is three examples and question is: Does it really matter how to do it? example 1: Code: $query = "SELECT * FROM ´mytable´ WHERE slogan = 'kicksass'"; $do_it = mysql_query($query) or die(mysql_error()); $showme = mysql_fetch_array($do_it); example 2: Code: $query = mysql_query("SELECT * FROM ´mytable´ WHERE slogan = 'kicksass'") or die(mysql_error()); $showme = mysql_fetch_array($query); example 3: (my fav because can do it in one line) Code: $showme = mysql_fetch_array(mysql_query("SELECT * FROM ´mytable´ WHERE slogan = 'kickass'")) or die(mysql_error()); Thanks for all.. =)