raven2009

it's a problem for me does that count lol Thanks for the info i'll take a look

anyone?

hi guys is there anyway of changing the url = mydomain.com/gameinfo.php?id=288 to something like mydomain.com/gamename

can't be done then? :-\

Hi i have a question for you all how can i intergrate a premium number to an auction? e.g. (example) User uses mobile to place bid and text's LOT678 to 78901 User's bid is then registered to the current auction bid Once the bid is confirmed user is text back and charged a premium If user gets outbid then the user is text back to say they have been outbid and encoraged to bid again now i can get the premium number sorted out and the programme to do it, its just a matter of intergrating the user bid into the current bid regards

ok thanks for that ill check that up now

seems there isnt a problem with the code the date format thats the problem im in the uk so my date is displayed dd/mm/yyyy and the database wants me to add it as yyyy/mm/dd strange! lol ???

hi all i have a problem with my statements displaying the wrong date it keeps displaying Nov 30, 1999 even though i am doing it different days these are my codes user statement <?php $getUser="select * from transactions where uid='$id' order by date desc"; $getUser=mysql_query($getUser); $users=mysql_num_rows($getUser); while($row=mysql_fetch_array($getUser)) { $idDB=$row['id']; $typeDB=$row['type']; $transactionDB=$row['transaction']; $amountDB=$row['amount']; $dateDB=$row['date']; list($day, $month, $year) = split("-", $dateDB); $dateDB = date('d M, Y', mktime(0, 0, 0, $day, $month, $year)); ?> <tr> <td bordercolor="#C9D4E3" bgcolor="#5E5E5E"><div align="center"><strong><?php echo $typeDB; ?></strong></div></td> <td bordercolor="#C9D4E3" bgcolor="#5E5E5E"><div align="center"><strong><?php echo $dateDB; ?></strong></div></td> <td bordercolor="#C9D4E3" bgcolor="#5E5E5E"><div align="center"><strong><a href="statementfullview.php?tid=<?php echo $idDB; ?> and the form to add statment <?php require_once('../config.php'); if(isset($_POST['addTransaction']) && $_POST['addTransaction']=='addTransaction') { $email=$_POST['email']; $type=$_POST['type']; $date=$_POST['date']; $transaction=$_POST['transaction']; $amount=$_POST['amount']; $info=$_POST['info']; $getUser="select id from users where email='$email'"; $getUser=mysql_query($getUser); while($row=mysql_fetch_array($getUser)) { $uid=$row['id']; } $addTransaction="insert into transactions(id,uid,type,transaction,amount,date,info) values('','$uid','$type','$transaction','$amount','$date','$info')"; //echo $register; $addTransaction=mysql_query($addTransaction); if($addTransaction) { ?> <script language="javascript1.1"> alert('Transaction added successfully!'); </script> <? } else { ?> <script language="javascript1.1"> alert('addTransaction not added! please try again.'); </script> <? } } ?> thanks in advance

hi all can anyone help im looking for a way to split my stores up so after 20 products it displays a next page and so on im not sure if this is the right code <?php $topStores="select * from retailers where category='$showCat' limit 1000"; //echo $topStores; $top_Stores=mysql_query($topStores); while($row=mysql_fetch_array($top_Stores)) { ?> thanks in advance

yesssssss i did it i did the information you told me but it displayed just the retailer number so i added <?php echo $retailername; ?> in to the title and it worked i'm well happy Thanks for your supprt

thanks for that heres a sample of my code trouble is the id is just a number would i replace id with retailer name? thanks for your help $id=$_GET['id']; $retailers="select * from retailers where id='$id'"; $listRetailers=mysql_query($retailers); while($row=mysql_fetch_array($listRetailers)) { $id=$row['id']; $retailername=$row['retailername']; $category=$row['category']; $keywords=$row['keywords'];

yes it's stored in the database so what your saying is put the stored database name in the meta? so how would i implement that have you got a basic code, im not sure what your after for the code tanks for your reply

right ill try and make this easy to understand im not good at explaining things when i make a new store page its gets a new id e.g. store.php?id=254 now when i index the pages via google it comes up with the name of the main stores name e.g my site name - stores and thats displays a few hundred times how do i get it to display individual names of stores in the meta name (top of page) e.g my site name - Auto trader

hi all how can you make a category display a subcategory when clicked?

no? :'(