Good project to better my Php skills?

[killaklown]

What would be a good project to better my php skills? Im new at php and finish coding a simple script at: http://www.netsnatch.com/script (which checks to see if the entered domain contains a valid license)

I dont think im ready with mysql, as most of the mysql information in the above script was copied from other scripts i bought.

 

[Dan]

http://www.netsnatch.com/script/

Doesn't work.

MySQL basically has 3 commands (insert, select, update; the others aren't used as much) that you need to know. It isn't hard at all.

 

[killaklown]

im working on making the script do more right now so it may give errors at times.

The things im not understanding right now about mysql is
mysql_query
mysql_fletch_array
etc.


Edit:

How can i get the number in a row in the database?

<?
$query = "SELECT downloads FROM counter WHERE id='1'";
$result = mysql_query($query);
$myrecord = mysql_fetch_row($result);

echo''.$myrecord.'';
?>

I have that, i want it to show the number in the 'downloads' column that has an id of 1, but all it does it show 'Array'.

 

[wackyjoe]

i would use mysql_fetch_array().

 

[Dan]

Use mysql_fetch_array instead of mysql_fetch_row.

I don't know why you are doing echo '', since the '' doesn't do anything.

$myrecord is an array with the row you got from the database. If you do mysql_fetch_array instead of mysql_fetch_row, you can do $myrecord['something'], where something is the name of the column in the database.

 

[killaklown]

i tried using mysql_fetch_array() but it still showed array.

 

[Tree]

You can't echo an array. Try print_r($myrecord) with mysql_fetch_array

 

[Flubber]

<?
$query = "SELECT downloads FROM counter WHERE id='1'";
$result = mysql_query($query);
$myrecord = mysql_fetch_row($result);

echo $myrecord['0'];
?>

Should work.

Flubb.

 

[killaklown]

thanks flubber, works.