JayLewis

DESC Records

JayLewis replied to JayLewis's topic in PHP Coding Help

Yer mate, its deffo ID i need it sorting by... its starting to do my nut in!

DESC Records

JayLewis replied to JayLewis's topic in PHP Coding Help

Nope, still not workin :|

DESC Records

JayLewis posted a topic in PHP Coding Help

i want to make all the records be shown in a decending order, i've tried using: $sql = 'SELECT * FROM `repair` ORDER BY `repair` . `id` DESC'; but its not working, any help please? Heres the code: <?php $host="xxxxxx"; // Host name $username="xxxxxxx"; // Mysql username $password="xxxxx"; // Mysql password $db_name="xxxx"; // Database name $tbl_name="xxx"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?> <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Search For A Birkenheader</title> </head> <body bgcolor="#0D3C8A"> <?php xxxx // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); $count=mysql_num_rows($result); ?> <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Search For A Birkenheader</title> </head> <body bgcolor="#0D3C8A"> <div align="center"> <table border="1" width="752" height="172" bgcolor="#FFFFFF" bordercolorlight="#000000" bordercolordark="#000000"> <tr> <td height="144" width="742" colspan="9"> <img border="0" src="banner.jpg" width="742" height="140"></td> </tr> <tr> <td height="20" width="13" bgcolor="#1C3867" align="center"> ID</td> <td height="20" width="104" bgcolor="#1C3867" align="center"> Contact Name</td> <td height="20" width="113" bgcolor="#1C3867" align="center"> Contact Number</td> <td height="20" width="70" bgcolor="#1C3867" align="center"> Make</td> <td height="20" width="75" bgcolor="#1C3867" align="center"> Model</td> <td height="20" width="89" bgcolor="#1C3867" align="center"> IMEI</td> <td height="20" width="136" bgcolor="#1C3867" align="center"> Fault</td> <td height="20" width="44" bgcolor="#1C3867" align="center"> Price</td> <td height="20" width="50" bgcolor="#1C3867" align="center"> Update</td></tr> <?php while($rows=mysql_fetch_array($result)) { ?> <tr> <td height="20" width="13" bgcolor="#1C3867" align="center"> <a href="reciept.php?id=<? echo $rows['id']; ?>" style="text-decoration: none"> <? echo $rows['id']; ?></a> </td> <td height="20" width="104" bgcolor="#1C3867" align="center"> <? echo $rows['name']; ?></td> <td height="20" width="113" bgcolor="#1C3867" align="center"> <? echo $rows['number']; ?></td> <td height="20" width="70" bgcolor="#1C3867" align="center"> <? echo $rows['make']; ?></td> <td height="20" width="75" bgcolor="#1C3867" align="center"> <? echo $rows['model']; ?></td> <td height="20" width="89" bgcolor="#1C3867" align="center"> <? echo $rows['imei']; ?></td> <td height="20" width="136" bgcolor="#1C3867" align="center"> <? echo $rows['fault']; ?></td> <td height="20" width="44" bgcolor="#1C3867" align="center"> <? echo $rows['price']; ?></td> <td height="20" width="50" bgcolor="#1C3867" align="center"> <a href="update.php?id=<? echo $rows['id']; ?>" style="text-decoration: none"> Edit</a></td></tr> <? } mysql_close(); ?>

Reading an ID onto another page

JayLewis replied to JayLewis's topic in PHP Coding Help

Yer, i know its easy to do. And i should be able to do it, using the $__GET[id] but its just not working for me :|

Reading an ID onto another page

JayLewis replied to JayLewis's topic in PHP Coding Help

Any one?

Reading an ID onto another page

JayLewis posted a topic in PHP Coding Help

I want to set up a profile for each ID.. So there is a list of sold items on a webpage with a "Reciept" link. I want to click that and it will take me to the reciept of the ID i click. So i click "Nokia 3310" and on the new page it give me all the details on another page from everything in the nokia 3310 row in the database. Thanks, Jay heres my code: <html> <head> <meta http-equiv="Content-Language" content="en-gb"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> <body bgcolor="#D0E0F0"> <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolor="#000000" height="52"> <tr> <td width="100%" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center"> Control Panel You are currently on page: "View Client List" Move to Pages: <a href="insert.php" style="text-decoration: none">Add A Client</a> - View Client List</td> </tr> <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolor="#3C79BD"> <tr> <td width="16" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> ID</td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Client Name</td> <td width="186" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Address</td> <td width="114" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Telephone Number</td> <td width="93" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Phone/Model</td> <td width="171" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Repair Comments</td> <td width="86" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Start Date</td> <td width="33" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA"> Cost</td> <td width="58" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center"> Receipt </td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#8DA3BA" align="center" valign="middle"> Fixed?</td> </tr> <?php $host="localhost"; // Host name $username="customcl_jay"; // Mysql username $password="123456"; // Mysql password $db_name="customcl_elitephones"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // Retrieve data from database $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); // Start looping rows in mysql database. while($rows=mysql_fetch_array($result)){ ?> <tr> <td width="16" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['id']; ?></td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['name']; ?> <? echo $rows['lastname']; ?></td> <td width="186" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['email']; ?></td> <td width="114" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['tel']; ?></td> <td width="93" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['model']; ?></td> <td width="171" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['repair']; ?></td> <td width="86" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"><? echo $rows['dropoff']; ?></td> <td width="33" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"> <? echo $rows['price']; ?></td> <td width="58" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center"> Receipt</td> <td width="76" bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B6CCE4" align="center" valign="middle"> <form method="POST" action="--WEBBOT-SELF--">  <select size="1" name="D1" style="border: 1px solid #000000; padding-left: 4px; padding-right: 4px; padding-top: 1px; padding-bottom: 1px; background-color: #8DA3BA"> <option>Yes</option> <option>BER</option> <option selected>Pending</option> </select> </form> </td> </tr> <? // close while loop } // close connection mysql_close(); ?> </body> </html>

Lottery Script... Working But...

JayLewis replied to JayLewis's topic in PHP Coding Help

n00b

Display name on site after login

JayLewis replied to ow-design's topic in PHP Coding Help

post your script up. or add me on msn Jay_Lewis@Jaydiocity.co.uk

Lottery Script... Working But...

JayLewis replied to JayLewis's topic in PHP Coding Help

i want it to work every hour like i said. but it doesnt. it just need the times sorting out, wich i cant do.

Lottery Script... Working But...

JayLewis posted a topic in PHP Coding Help

Hey everyone! I've got this Lottery Script and i want it to work like this: The lottery will be every two hours... So say the lotto starts at 12 oclock, you've got till 1 oclock to buy your tickets but after that, you must wait an hour after the last lottery for the new lottery to start. Confusing Ey? Heres the code: <?php $page = 'Lottery'; $count_aantal = 0; $q1 = mysql_query("SELECT * FROM lotterij WHERE user='$this_user->id' AND name='hour'"); while($admin = mysql_fetch_object($q1)) { $count_aantal++; } $q2 = mysql_query("SELECT * FROM lot WHERE lotterij='hour'"); $win = mysql_fetch_object($q2); $count_mny = 0; $q1 = mysql_query("SELECT * FROM lotterij WHERE name='hour'"); while($admin = mysql_fetch_object($q1)) { $count_mny++; } $price = 10000; /// prijs wat de lotterij kost $mny = $count_mny * $price; /*Cron voor lotterij van elk uur*/ $q1 = mysql_query("SELECT * FROM cron WHERE name='hour'"); $day = mysql_fetch_object($q1); /*einde van cron elk uur*/ mysql_query("INSERT INTO cron (endt) VALUES($day+3600)"); /*begin post van lotterij uur*/ if(isset($_POST['submit'])) { /*checken of de users meer als 50 loten heeft,of meer als 50 wil kopen*/ if($count_aantal >=50) { Messagebox("$page","You already have more then 50 tickets."); return; } if($tickets >=51) { Messagebox("$page","You cannot buy more then 50 tickets."); return; } $geld = $price * $tickets; $geld1 = $this_user->hand - $geld; if($this_user->hand - $geld <= -1) { MessageBox("$page","You dont have enough money."); return; } /*einde check*/ // aantal $aantal= $_POST['tickets']; //$aantal keer herhalen for($i=1;$i<=$aantal;$i++){ mysql_query("INSERT INTO lotterij (id,user,tickets,name) VALUES('','$this_user->id','1','hour')"); } MessageBox("Lotery","You bought some tickets."); mysql_query("UPDATE users SET hand='$geld1' WHERE id='$this_user->id'"); return; } /*einde post*/ AddLog($this_user->id, "$this_user->username visit lottery", $tijd); echo "<table width='300' align='center'>"; echo "<form method='post' name='lotterij'>"; echo "<tr>"; echo "<th class='pic' colspan='6'>Lottery Hour</th>"; echo "</tr>"; echo "<tr>"; echo "<th class='empty' colspan='6'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buy: <input type'text' name='tickets' maxlength='2' class='trade'> </td>"; echo "<td width='49%' class='empty'>Tickets $count_aantal / 50 </td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Ticket Cost:</td>"; echo "<td width='49%' class='empty'>".Tomoney($price)."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Money in Pot:</td>"; echo "<td width='49%' class='empty'>".Tomoney($mny)."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Start Time:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $day) ."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buying:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $tijd) ."</td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Buying Time Ends:</td>"; echo "<td width='49%' class='empty'>". date('D M jS, H:i:s', $tijd+3600) ." </td>"; echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th width='1%' class='empty'> </th>"; echo "<td width='49%' class='empty'>Last Winner:</td>"; echo "<td width='49%' class='empty'>"; if($win->winner =='0') { echo "None"; } else { echo "".to_name($win->winner)."</td>"; } echo "<th width='1%' class='empty'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th class='empty' colspan='6'> </th>"; echo "</tr>"; echo "<tr>"; echo "<th class='pic' colspan='6'> <input type='submit' name='submit' class='knop' value='Buy'> </th>"; echo "</tr>"; echo "</table>"; echo "</form>"; /*einde lotterij van elk uur*/ echo " "; ?>

Sign In

Posts

Joined

Last visited

Profile Information

JayLewis's Achievements

Member (2/5)

Reputation

DESC Records

DESC Records

DESC Records

Reading an ID onto another page

Reading an ID onto another page

Reading an ID onto another page

Lottery Script... Working But...

Display name on site after login

Lottery Script... Working But...

Lottery Script... Working But...

Display name on site after login

makecomma error

makecomma error

makecomma error

makecomma error

Browse

Activity

Important Information