Can someone make this a little smaller and simpler?

PHP Code:

<?php
require('inc/config2345.php'); 

// get adds from the database
$sql = mysql_query("SELECT * FROM addvert") or die (mysql_error());

// add results to an array so can be displayed
$rows = mysql_fetch_array($sql);

// echo the codes for the adds and stripslashes or it wont display properly.
echo stripslashes($rows['code'])."<br />".stripslashes($rows['code1'])."<br />".stripslashes($rows['code2']);
?>

Is there a reason why you need it to be simplified? It is already pretty simple.

As Nullpointer said it seem quite simple already.
It may get a tiny bit simpler by correcting data (using stripslashes for example) before putting it in your database, instead of when you're retrieveing it. That way you can do all the necessary checks on all data at the same place and you know that all data in the database is correct and won't need any extra formatting when being output.

And, correct me if I'm wrong, but by using mysql_fetch_array() the keys in $rows will be 0, 1 and 2, not 'code', 'code1' and 'code2'. You shoule be using mysql_fetch_assoc().

Originally Posted by lizciz

And, correct me if I'm wrong, but by using mysql_fetch_array() the keys in $rows will be 0, 1 and 2, not 'code', 'code1' and 'code2'. You shoule be using mysql_fetch_assoc().

mysql_fetch_array has three different fetch modes: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH. The default is both, meaning that you can index the array using keys or numeric indicies.

So the code is simplified and the shortest it can be? If it is, then thank you.

Short answer: Yes

Long answer:

I'm not sure what your goal is here. If you're trying to somehow optimize that small chunk of code you're probably not spending your time wisely. Code that appears simple, in terms of the number of lines or the amount of code, can often be misleading. The number of lines in a program is probably the worst way to estimate the performance of that program. There are plenty of cases where you can replace a function call with several lines of code and improve the performance of your program. You should try to focus on the efficiency of your code rather than the size of it.

This advice isn't really helpful in this particular case, but if there were some function that allowed you to do what you are doing in 1 or 2 lines of code it wouldn't necessarily be a better solution.