Hello, im new coding in php, iv got a good backing in programming but as far as this goes im a tad lost. to start i and decided to go with a simple script that counts the rows in a mySQL database returns a result, randomises between 1 and that result and then should select and display that record :-/
unfortunatly it seems to break down after the "randomise" part, any ideas?
<?php $host= "localhost"; $user="username"; $password="password"; $dbname="dbname // connect to the database $cxn = mysqli_connect($host,$user,$password,$dbname) or die ("connection failed"); // set the query to the variable so when used below it runs this query $entries="SELECT * FROM Review"; $result = mysqli_query($cxn,$entries) or die ("couldn't collect data"); // counts and randomises between 1 and the returned query number $numresult = mysqli_num_rows($result); echo rand(1,$numresult); //below is the query that should select the record with the number in the variable numresult set above // attempts to select all records from the table review where they = the number in the variable $name="SELECT * FROM Review WHERE id = $numresult"; $nameresult = mysqli_query($cxn,$name) or die ("couldent get c name"); //print or echo the result, eventually i hope to use an array to hold for e.g the comment, first name and last name for indervidual use. print_f $nameresult; ?>
thanks in advance for any help :)