glennn.php

TRUNCATE will kill all existing records? or no? what the original poster was hoping for is that if he were to delete all but say, the first 5 records, that Auto-Increment would revert to starting at "5" for the next entry instead of at whatever value it had reached before the deletion of said records. or hoping for a way to see that the table does that at some point without having to delete all the records and starting over... i've always wondered the same thing, but as you pointed out earlier, it's not necessary. i guess that's what you meant.

it's really kinda funny - of course there's not really a need to, it's just a counter, but i understand what he's talking about (i think) 'cause my OCD (Obssessive-Compulsive Disorder bothers me when there's a bunch of numbers that are "skipped" by the deletion of records before the database is put into operation. :o). it matters none at all, but when i'm about to launch a "new" install of something, i kinda like to know that the table is starting at "0" instead of "9". at least, i'm just guessin' that's what he's looking at. You ever watch "Monk"? The PI with OCD? if so, you'll know what i'm talking about. ain't nuthin'. they talked of firin' Torre at the end of the season last. i think the world's a better place now that the yankees have been brought to task and back down to this galaxy. effin' yankees.

Fenway, that worked after i removed "cat = '518' AND ... LIMIT 1". Only condition i needed was userid... got it, thanks to you. [quote author=fenway link=topic=116214.msg473405#msg473405 date=1164422658] if ($mp3 = '518') You mean "==". [/quote]

let me clarify - i want to print that particular portion of $line ONLY IF a cat with value 518 exists for $userid. for some reason the query as i have it now prints that line whether the userid possesses a cat of 518 or not (all userid's possess a cat of something else - some ALSO have a 518, or two or several, in which case i'd want the link "Playlist" printed along with the other info...) hope that clarifies my Greek for whomever is inclined to assist this lost soul. TIA

you need to flush the table or start a new table to get your increments zeroed out, as far as i know. if you want to keep your records, copy them to a new table, and the increment will start after the last good table, I'M PRETTY SURE. if someone knows i'm wrong, please correct me...

nope. still prints the line regardless. man, and i'm a BIG BoSox fan, i was thinking GoBoSox!!! this is such a simple fix, i know. i'm just so new at it...

you mean all that looks right except for THAT??? i'm picking myself up off the floor laughing. i've attempted every reasonable script configuration known to man, woman and dolphin, and ... well. i'm a novice. let's go give this a try. i'll let you know. TIA.

the kind of help i need is with this stupid little query that i can't make behave... this is an old query i've been remodelling to work with an ever changing script (any suggestions as to its cleanliness and efficiency are most welcome)... i'm trying to print "$line <a href// Playlist</a>" ONLY IF any number of cats with the value of 518 exist for each userid. doesn't matter how many records with such a cat - that's handled elsewhere. i just don't want to print that line if there are no 518s for $userid. can anyone show me the error of my ways? (not like my mom tried to show me - that NEVER worked). thanks, in all seriousness, and regards, gn [code] $res = mysql_query("SELECT id, userid, user, cat, bigimage, description, extra1 FROM pp_photos ORDER BY rating DESC"); while ($row = mysql_fetch_array($res)) { $img = $row["bigimage"]; $bio = $row["description"]; $url = $row["extra1"]; $userid = $row["userid"]; $name = $row["user"]; $id = $row["id"]; $cat = $row["cat"]; $catArray[] = $cat; $mp3Array[] = $mp3; $picsArray[] = $img; $useridArray [] = $userid; $nameArray[] = $name; $urlArray[] = $url; $idArray[] = $id; $bioArray[] = $bio; } $idx = 0; $pos = 0; $purl = $picUrl[$pic]; $i = (count($picsArray) - 1);                 while ($idx <= $i) { $pic  = $picsArray[$idx]; $url  = $urlArray[$idx]; $name  = $nameArray[$idx]; $cat  = $catArray[$idx]; $userid  = $useridArray[$idx]; $id  = $idArray[$idx]; $bio  = $bioArray[$idx]; $name = str_replace("'", "\'", $name); $bio = str_replace("'", "\'", $bio); $bio = preg_replace("/&quot;/", "\'", $bio); $bio = preg_replace("/&#039;/", "\'", $bio); if ($pos == 0) { print "<tr>\n"; } $line = "<a href=\"pp/showphoto.php?photo=$id&cat=$cat&ppuser=$userid\" target=\"\" onmouseover=\"return overlib ('<b><a href=$url target=_blank>Website</a></b><br><img src=imgs/spacer.gif width=100 height=3><br>"; $resa = mysql_query("SELECT cat FROM pp_photos WHERE cat = '518' AND userid = '$userid' LIMIT 1"); while ($row = mysql_fetch_array($resa)) { $mp3 = $row["cat"]; echo "$mp3"; } if ($mp3 = '518') { $line .= "<b><a href=mediaPlayer/player.php?userid=$userid target=player>Playlist</a> </b>"; } $line .= "<br><img src=imgs/spacer.gif width=100 height=3><br><b>$bio</b><br><img src=imgs/spacer.gif width=100 height=3>', STICKY, CAPTION, '<b>$name</b>', MOUSEOFF);\" onmouseout=\"return nd();\"><img src=\"pp/data/".$cat."/".$pic."\" border=\"0\" height=\"100\" width=\"100\"></a>"; [/code]

man it looks awesome - thanks for your help instead of being so stuffy : o ) [quote author=pvtpyro link=topic=106175.msg424444#msg424444 date=1156909965] xoops.org is wonderful! check them out. [/quote]

thanks - will do... [quote author=pvtpyro link=topic=106175.msg424444#msg424444 date=1156909965] xoops.org is wonderful! check them out. [/quote]

right, i came here from Hotscripts - actually i'm looking for something that would have a Blog, Calendar, and various other options... are these the types of things that come with most CMS platforms? any suggestions?

we've developed a site for members (entertainers), the site realizing growing needs - a calendar, so i went and installed a Calendar (with sessions Auth.). A Blog, so i went and installed a Blog - right, with its own Sessions... the members' area where they can store their own data, including videos and mp3's uploaded... it's occuring to me that there MUST be something that offers ALL this (preferably something of some Quality Blogging Scripts, etc) with one Felled Swoop. I"ve never looked, but are these the kind of things i'd find in Joomla, etc...? can anyone offer a suggestion or direction? i'm guessing something customized would run me more than 39.95, huh. :o) thanks for your input - glenn

ok, let me rephrase the polite and respectful request: i would like to change those two submit buttons to radio buttons in such a way as to have the necessary data properly submitted. is there anyone that wouldn't mind going to the trouble of showing me how it would be done? i hate to be a bother...

i would like to convert these two submit buttons to a radio button choice - is there anyone that can help? [code] function send_data( selection ) { if (chkform()) {   document.jnl2_sign_form.method = "post";   if ( selection == "sign_in" )    { //** changed $sign_in_page to maillist.php **/   document.jnl2_sign_form.action = "../new1/maillist.php?do=sign_in&language=$language&ml_id=$ml_id";   } if ( selection == "sign_out" ) { document.jnl2_sign_form.action = "../new1/maillist.php?do=sign_out&language=$language&ml_id=$ml_id"; } document.jnl2_sign_form.submit(); } } </script> <div class="jnl2"> <div class="mini_sign_form"> <form name="jnl2_sign_form">   <nobr><b>{$loc_lang["email_address"]}</b></nobr><br>   <input type="text" name="email" style="width: 70%" maxlength="45"><br>   <p align="center">   <nobr>         <input type="button" value="{$loc_lang["sign_in_newsletter"]}" name="sign_in" onclick="send_data(this.name)" class="buttons"><br />         <input type="button" value="{$loc_lang["sign_out_newsletter"]}" name="sign_out" onclick="send_data(this.name)" class="buttons">   </nobr>   </p>   </form> [/code] thanks in advance, g

i need to get an array into this javascipt, and i'm unable - can someone offer a hand? global $onMouseOver, $onMouseOut, $picsArray, $textArray, $picUrl;                                                    $idx = 0;                 while ($idx <= 6) {                         $pic  = $picsArray[$idx];                         $purl = $picUrl[$pic];                         $text  = $textArray[$idx];                                         ?>                 <script language="JavaScript" type="text/javascript">                   Text[8]=["<?php print "$text"; ?>","next line..."]                   applyCssFilter()                                 </script> <?         ////// $line = "<td width=\"100\" background=\"stars/".$pic."\"><a href=\"".$phpLink."\" target=\"_blank\"> <img src=\"stars/gold.gif\" width=\"100\" height=\"100\" border=\"0\" onMouseOver=\"stm(Text[8],Style[5])\" onMouseOut=\"htm()\" /></a></td>";                         }                         print $line."\n";                         $idx++; 

i need to add a "CREATE TABLE IF NOT EXISTS $picId" query in this. for some reason my attempts have failed - can this be done?    function edituser($picId,$firstname,$lastname,$password,$aka,$email,$url,$website,$city,$state,$talent,$biography,$approved,$customerid) {       $sql = "update stars set picId='$picId',password='$password',email='$email',firstname='$firstname',lastname='$lastname',aka='$aka',website='$website',url='$url',city='$city',state='$state',talent='$talent',biography='$biography',approved='$approved' where customerid='$customerid'";      $results = $this->update($sql);       return $results;     } (also, $picID will have a .jpg extension which needs to be removed) can anyone help me with this? thanks in advance g

i've recently encountered a completely unnacceptable situation with webscribble.com and a script they sell for 200.00, that, once modified (by THEM), is unable to be upgraded to the new versions, a feature they offer as part of the purchase (of course). my client and i have had nothing but problems with them for over a month (it took literally weeks to get a support ticket responded to - whereby the Tech, Alexander, threatened to move my client to the end of the line if she continued to harrass him with emails questioning the status of the ticket.) wnated to warn everyone of this team of incompetants (i am clearly not the only one with problems with them): 1 - [a href=\"http://www.getafreelancer.com/proje...HP-Problem.html\" target=\"_blank\"]http://www.getafreelancer.com/proje...HP-Problem.html[/a] " We have bought an application named webjobs from a company called webscribble.com. The software had some problems and the company support people told us to upgrade to PHP5. Know the site couldnot be seen and the support people doesnt respond. I need someone to be able to make it work with php5. " 2 - [a href=\"http://badbusinessbureau.com/reports/ripoff187984.htm\" target=\"_blank\"]http://badbusinessbureau.com/reports/ripoff187984.htm[/a] " I was going to buy a date site package from Webbizideas, it was going to cost me over $3,100.00 for very thing. All I can say is DONT BUY ANYTHING FROM THEM, you would be much better off, picking a name out of the phone book and just send them your heard earn money. They are also working with webscribble who is on this site to, they ripped me off $800.00 if you send emails you will never hear from them , if you call you will never get to talk to any one. And most of all webbizieda said that are backed by BBBonline YA right I went to the main site and they have no clue who they are, so dont buy that little box. Dan you are a ripoff. To all if you want to do somthing like a casino or date site, make sure they are real. Charles Chandler, Arizona U.S.A. " 3 - [a href=\"http://www.programmingtalk.com/arch...php/t-3681.html\" target=\"_blank\"]http://www.programmingtalk.com/arch...php/t-3681.html[/a] Online Dating Software that could RIP YOU OFF! We are out $565.00.If you are interested in starting your own online dating website, chances are you will find a dating software program called Webdate authored and sold by Webscribble Solutions, Inc. I would like to share my experiences with this company and their script as to help others from getting scammed and ripped-off by this company. When we first purchased this dating script and installed it, many key features didn't even work and we found a huge security hole which could leave the script open to hacking attacks. Webscribble acknowleged our claims and sort of got the script at least working. But it didn't work "off the shelf." That's the least of any problems you could have. The company has a very deceptive license agreement and you should BEWARE and read it carefully before buying anything from this company. ONCE YOU BUY IT, ITS YOURS FOREVER...it is non-transferable and it is a ONE-WAY transaction and they CONTROL YOUR website. You are at their mercy! The company claims you can sell or transfer the license in their license agreement for an adminstrative fee, but what is deceptive and what they don't tell you in their license agreement is that the adminstrative fee is the same amount of money that you bought their dating website software. So, what's the point in trying to sell or transfer the software license if the person who buys it from you has to pay the same amount of money you bought it for to Webscribble. They might as well buy it direct from the company. We contacted and addressed the company about the issue by Email and never received a response. We contacted them on the telephone and the company representative was rude, unflexible and could care less about retaining customer loyalty or customer satisfaction or future business with the person interested in assuming our software license to the dating code.We tried to do everything legitimately and to respect their license agreement by being upfront and sincere with them. But this company is very sneaky and deceptive by making you think you can sell or transfer the license to the dating script because most people don't read software license agreements and anaylze all scenarios before they buy.The reality is that YOU CAN'T SELL OR TRANSFER THE LICENSE to the Webdate dating code unless you pay the full purchase price AGAIN to Webscribble, Inc. Not only that but the company uses "spyware" in their code which constantly communicates with their company web server so at anytime they can turn off your entire website or block your access to your own website by not letting you access your administrative area. Don't let a company have total control of your business with the power to shut you down whenever they feel like it or have technical problems.DO NOT SUPPORT companies that don't care about helping you or your business unless you want to be stuck with their lack of support and to leave you with no alternative if you are unhappy, or wish to sell or transfer your software license. READ THEIR LICENSE AGREEMENT VERY CAREFULLY. Remember, in the pre-sales stage, they are all your best friends...then after the sale, they will give you the middle finger and say "see ya!" Oh yeah, thanks for your money!

[!--quoteo(post=371447:date=May 4 2006, 11:40 PM:name=glennn.php)--][div class=\'quotetop\']QUOTE(glennn.php @ May 4 2006, 11:40 PM) [snapback]371447[/snapback][/div][div class=\'quotemain\'][!--quotec--] i have this login script but the author provided no logout feature - i'd like to be able to kill the session without the user having to close his browser: [code] if (!$errortag){     session_register("CID");     $_SESSION["CID"] = $customerid;     $CID = $customerid;     $showtable = false; } [/code] can anyone help? have i provided enough info? I know this is simple - the reason i love these forums is that ya'll can't see me turn red in embarrassment at such times... thanks, g [/quote] figured it out, thanks

i have this login script but the author provided no logout feature - i'd like to be able to kill the session without the user having to close his browser: [code] if (!$errortag){     session_register("CID");     $_SESSION["CID"] = $customerid;     $CID = $customerid;     $showtable = false; } [/code] can anyone help? have i provided enough info? I know this is simple - the reason i love these forums is that ya'll can't see me turn red in embarrassment at such times... thanks, g

beautiful - almost... since i didn't know where to put mysql_fetch_assoc() i just did this: [code]for ( $i=0;$i<$lines;$i++ ) {     $row = mysql_fetch_array($result);     if  (!empty($row['CustomField15']))     {   $url = $row['CustomField15'];     } else {   $url = $row['CustomField1']; }     print "$url<br>"; }[/code] and i got what i wanted; almost. you're right, i gotta concat those two fields from the query, not later... fields 1 and 2 are first name, last name - field 15 is nickname, if they so choose... since i'm printing a member's list, if they use a nick then i'll alphebetize by that - if they don't, then by last name... so now i just have to CONCAT fields 1 and 2 in the query and i'm good to go. thanks for your help...

ok, here goes: [code]$sql = "SELECT CustomField1, CustomField2 , CustomField15, CustomField16 FROM oemp_members WHERE CustomField2 LIKE 'n%' OR CustomField15 LIKE 'n%' ORDER BY CustomField2 ASC"; $result = mysql_query($sql) or die("Query failed"); $lines = mysql_num_rows ( $result ); for ( $i=0;$i<$lines;$i++ ) {     $row = mysql_fetch_array($result);     print "<a href=\"http://${row[3]}\">${row[0]} ${row[1]}</a><br>"; }[/code] Sometimes CustomField15 will contain data. Sometimes CustomField1 and 2 will contain data (sometimes all three...?) what i'd love to be able to print is IF there's data in CF15 (regardless of whether 1 and 2), then print 15, else IF there's no data in 15, then print 1 and 2. i attempted if else staements above my print function up there, but it's likely in the wrong place; i was printing 15 regardless... can someone help? thanks much... how ya doin', Darkness? :o) that's your code up there... :o)

[!--quoteo(post=367009:date=Apr 20 2006, 05:39 PM:name=businessman332211)--][div class=\'quotetop\']QUOTE(businessman332211 @ Apr 20 2006, 05:39 PM) [snapback]367009[/snapback][/div][div class=\'quotemain\'][!--quotec--] I don't currently know databasing yet, I am working on it though. [/quote] this is what worked: select u,h from customer where username LIKE 'A%'; versus what i DID have, " ...LIKE 'A'; "

[!--quoteo(post=366982:date=Apr 20 2006, 03:57 PM:name=Darkness Soul)--][div class=\'quotetop\']QUOTE(Darkness Soul @ Apr 20 2006, 03:57 PM) [snapback]366982[/snapback][/div][div class=\'quotemain\'][!--quotec--] Try the code now.. like it: [code]$sql = "SELECT username , homepage FROM customer ORDER BY username , homepage"; $result = mysql_query($sql , $conn) or die(print "Query failed: ". mysql_error() ); $lines = mysql_num_rows ( $result ); for ( $i=0;$i<$lines;$i++ ) {     $row = mysql_fetch_array($result);     print "${row[0]} - ${row[1]} <br>"; }[/code] If wont work, let's see what we can do. D.Soul [/quote] both of these worked, and Barand even broke it up for me, like i need - i really need to put each into a separate table cell - i'd like to get each query by alphabet letter - i've tried "select u,h from customer WHERE username LIKE 'a';" but it returned nothing. how can i properly get each letter separately?

thanks, you guys, that did it...

kind people, i'm attempting to print results of a mysql query into alphabetized groups - i can get the results, but i can't figure out how to separate them and sort them... can someone help? from this: [code] $sql = "SELECT `customer`.`username` , `customer`.`homepage` FROM customer ORDER BY `customer`.`username` ASC , `customer`.`homepage` ASC"; $result = mysql_query($sql) or die("Query failed"); $row = mysql_fetch_array($result); // change to suit your needs print "${row[0]} - ${row[1]}"; [code] obviously i'm only getting the first record's results... i need to get all the records as their added to the db... what i'd like to be able to do is print 26 groups according username... can someone show me how to get these results into some kind of array, and then printed, or whatever i need to do? thanks glennn