Wednesday, September 27, 2023

Sequential Numbering with MySQL

 This example will update position field of table tb_documents with sequential numbers.update tb_documents set position =(select @rownum:=@rownum+1 rownum FROM (SELECT @rownum:=0) r)Source :


Making connection to database<?php$con=mysql_connect("server","username","password");if(!con)    {        die('Could not connect: '. mysql_error());    }mysql_select_db("database_name", $con);?> Displaying record from table<?php$query=mysql_query("SELECT * from tablename");while($row=mysql_fetch_array($query))    {    echo $row['field_name_1'];    echo $row['field_name_2'];    }mysql_close($con);?> Inserting record into table<!--php script & HTML form in one…

Great tutorials

1stoptutorials is a different that most tutorial websites because you will be doing full courses. You will learn the basics in creating photoshop templates, slicing photoshop templates, dreamweaver, css , websites creation and many more.…