Annulleret

vBulletin & MySql Queries

How to integrate simple sql queries into a vBulletin template, and then write the results on the vBulletin page? I created a small table in vBulletin db and a php query (below) that: checks if not postback->select last db record else->insert new data->select last db record assign results to vars write vars I am working on a clients site so cannot allow access to the server, but believe this is a very simple request for someone well versed in vBulletin & php. I want to integrate this into my vBulletin code so I drop the template in many places. would appreciate a full explanation of how the code was modified for vb thanks! $postback = $_POST["postback"]; if (empty($postback)) { //no new input so get last $sql="SELECT num, headline, news FROM cNews ORDER BY num DESC LIMIT 1"; $result = mysql_query($sql, $conn) or die(mysql_error()); } else { //insert new data then get last $headline = $_POST["headline"]; $news = $_POST["news"]; $sql = "INSERT INTO cNews VALUES (num,'".$headline."','".$news."')"; $result = mysql_query($sql, $conn) or die(mysql_error()); $sql="SELECT num, headline, news FROM cNews ORDER BY num DESC LIMIT 1"; $result = mysql_query($sql, $conn) or die(mysql_error()); } while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $num = $row['num']; $headline = $row['headline']; $news = $row['news']; }

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

php unix mysql vbulletin

Evner: Ingeniørarbejde, MySQL, PHP, Software Arkitektur, Software Testning, Web Hosting, Hjemmeside Management, Hjemmeside Testning

Se mere: write mysql query vbulletin template, how to write vb, web die, very simple data insert, sql queries, queries, postback, vbulletin php mysql, mysql else insert, php select insert sql, mysql select platform, order query platform, write sql queries, table queries, php mysql select exist, insert mysql table, sql select order, mysql record, amp sql, access table query form

Om arbejdsgiveren:
( 73 bedømmelser ) Providence, United States

Projekt ID: #3250419