Gregg
-
Posts
61 -
Joined
-
Last visited
Never
Posts posted by Gregg
-
-
Ok, i created a new table in my database and i have built a form in php to submit to it and update sp on.
But i cant seem to get the info from it. what i want to do is display it on my page under stats.
Here is the new table:
CREATE TABLE IF NOT EXISTS `se_donations` ( `active` int(1) NOT NULL default '1', `com_tokens` int(20) NOT NULL default '0', `com_donatids` int(20) NOT NULL default '0', PRIMARY KEY (`active`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `se_donations` -- INSERT INTO `se_donations` (`active`, `com_tokens`, `com_donatids`) VALUES (1,9044, 23);
And in the .PHP file i have this code to get the info from it:
////// GET TOTAL DON ////// $total_tokens = $database->database_query("SELECT com_tokens FROM se_donations"); $smarty->assign('total_tokens', $total_tokens); ////// END //////Just a heads up, the code is connecting but displaying ether a 1 or a name "resource id #37" not the value in the columm = 9044!
More info:
$database-> is the custom code that store my connect data: pass id db name so on...
$smarty-> is part of my smarty .php that allows the code to run and print on the pages...
BALANCE: {$total_tokens} is how i call it on my .tpl pages.
Now my question is, how do i get it to call the data 9044 not the id or row count??
I cant seem to get it to call the info beside the id row count or resource name... arg lol ???
-
Ok, i finial got my cam pages open and working on a URL to cam basis.
But i was wondering how to set it for direct linking to the cam?
I would need a "Go Live" download and have it link to the pages but how??
See my cam site here: [url=http://darkwaterstudio.net/datingsite/CamPortal/index.php]http://darkwaterstudio.net/datingsite/CamPortal/index.php[/url]
Any help would be great, or thoughts on how tomake it work.. -
Hahah, your right it dident work still loaded the code just not the images...
Do you know how to make [b]PHP[/b] load a cam?
-
I will try it as soon as i get it on the page,only one needed for me.
Or i need to find away to post the web cam in a safer way.
I used html as a loader cause i never did it befor and its a pain to find a load cam script for free lol. -
I found it, and i am not worried about my php but other sensitive info.
I just dont want my streaming info loaded on there home pc...
The code i found uses a hidden page as the "save as" page lol. So when they save any of my pages it will download a BLANK page saying NO HACKERS ALLOWED! -
Haha,i thought the same thing but came up empty handed.
I searched javascript todeath, i'll try a diffrent search EN -
Ok, i want to know how i would go about making it sowhen a user trys to,
"Save Page As" it will block it?
I have seen this done of at least 4 diffrent sites but am stumped on how they did it.
I was thinking they did it with php cause it dont show in the source...
Or at least make an alternate "Page" for saving. -
You did it kid... Worked like a charm!
[quote]That's right... who's laughing now... who's laughing *now*?[/quote] -
Ok, i am trying to make it so if a user isent logged in the image will show thecensored version.
I have 2 foldes for the photos, "One unedited" & "One Censored" but i keeps loading "THE IMAGE CODE" and errors?
[code]<?if($UsErCoOkIe)
include("Users3Rate/Gerard.gif");
else
include("Users3Censored/Gerard.gif");?>[/code]
Theni heard you cant use that function on images? Anyone got and an ideah how to fix this or why it keeps loading the image code and not the image! -
Are you refering to the "Tracker php" or somthing else?
Give me the exact page and i will look ok.
Because they have about 6 diffrent php running on there that i see. -
Thanks, worked great. :D
-
Ok, here is a question i havent figured out in a while.
How do i display the load time of the curent "Page", like:
[b][color=red]It Took 4.9 Seconds To Load Results.[/color][/b]
I remember doing it years back but i dont want it in js but php. ??? -
Thanks "Barand" worked great!
And sorry i posted this kind of confusing i was on the way out so needed to save it befor i left lol..
I needed the right code to get all of the genders and the one posted worked when i inter graded it into the head code so thanks.
:D -
Ok, the feild i am trying to pull the info from has serveral values.
It's on my results page, and it shows all the users matching there discription..
(0)
(1) Male
(2) Female
(3) Couple
(4) Group
(5) Couple FF
(6) Couple MM
And i can get it to work using this but it wont pull all the values.
[code]<?
if($rowuser["genderid"]%2==0)
echo Female;
else
echo Male;
?>[/code]
-
I belive i know what you mean, i also use this feature but not in flash.
I just included a "LiveStream" link in the mail and it loads right in there mail account or Outlook.
And i set up a "Mail*Stream*DB" for the usage.
My users send live mail all the time lol.
You will also need to include it in your MAIL FORM and USER LISTINGS if you have um?
[quote]Say hello to my BOOM STICK!![/quote] -
It wouldent be just in php,
Just the call function in the php "On Submit" then it would load the "Progress Bar" then close on file completion! -
[url=http://darkwaterstudio.net/TestUpload/upload.php]PREVIEW YOUR UPLOAD SCRIPT HERE[/url]
I all ready made it,yeah i included a "Ban" function for you.
It allows only the files you want and places in folder securly!
If you want an "Image Loading Bar" just ad it tothe config file.
Mail me for the files here: [url=http://darkwaterstudio.net/datingsite/contactus.php]Mail Me Here[/url] -
[url=http://darkwaterstudio.net/TestUpload/upload.php]PREVIEW YOUR UPLOAD SCRIPT HERE[/url]
I all ready made it,yeah i included a "Ban" function for you.
It allows only the files you want and places in folder securly!
If you want me to match it to your php give me the link ok.
You dont need to edit anything just upload them and "777"
OPTIONS:
**********************************************
Upload up to 10 files, with no interupt!!
If one file fails it will still uplod the others..
Ban files and ections..
Ban users who upload bad content!!
By IP
By Userid
Change thetheme & style
Secure Transfer!!
View Uploaded Files
Diffrent Catogorys!
***********************************************
Mail me at my site, and i will mail it to you ok.
[url=http://darkwaterstudio.net/datingsite/contactus.php]Mail Me Here[/url]
If you need live help just find me in my chat room or [url=http://darkwaterstudio.net/datingsite/Whos_Online(FreeView).php]LIVE SUPPORT[/url]!
-
Do you still need help with this,i can make you a working upload script and mail it to you.
-
I am not shure about the "$last"
is there a way around it? -
This is it, i am not shure where it went i belive this page was an error a long while back and i never fixed it:
[code]
<td class="big_txt" height="24" align=center valign="top"><br>
<font size="2"> <? echo $total1?> people have found you interesting in last
<?
if($last=="15 day")
{
$last1="15 days";
}
if($last=="7 day")
{
$last1="7 days";
}
if($last=="1 month")
{
$last1="1 month";
}
if($last=="6 month")
{
$last1="6 months";
}
echo $last1?>
</font><br>
<br> </td>
</tr>
<?if($totalrows>0){?>
<tr>
<td><table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="2%" valign="bottom"> </td>
<td width="95%" class="curve_top"> </td>
<td width="3%" valign="bottom"> </td>
</tr>
<tr>
<td colspan="3>
<table width="100%" border="0" cellspacing="0" cellpadding="0"><?
for($i=0;$i<$totalrows;$i++)
{
$loverow=mysql_fetch_array($result1);
$userid=$loverow["userid"];
$query="select * from users where userid='$userid'";
$result=mysql_query($query,$db);
$rowuser=mysql_fetch_array($result);
$useridentity=$rowuser["identity"];
$sql1="select * from photo where username='$useridentity' and main='Y'";
$res1=mysql_query($sql1,$db);
$row1=mysql_fetch_array($res1);
if($row1["photo"])
$photo=$row1["photo"];
else
$photo="";
$PRODUCTIMAGES="photoimage/";
?>
<tr>
<td><table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="22%"><table width="99%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="39%" align="center"><? if($photo)
{?>
<a href="#" onClick="openWindow('<?echo $PRODUCTIMAGES.$photo?>')"> <img class=black_border name="<?$row1["quote"]?>" src=" <? echo $PRODUCTIMAGES.$photo?>" alt="<?$row1["quote"]?>" border=1 width=60 height=75 align=absmiddle></a>
<?}
else
{?>
<img src="images/no_photo.jpg" alt="no photo" width="60" height="75">
<?}?> </td>
</tr>
<tr>
<td colspan="2" align="center" height="55"><a href="viewprofile.php?id=<? echo $rowuser["userid"]?>"> <img src="images/view_profile.jpg" alt="view photos" width="100" height="13" border="0"></a>
<?if($photo){?>
<a href="#" onClick="openpicWindow('<?echo $rowuser["identity"]?>')"> <img src="images/view_photos.jpg" alt="view photos" width="101" height="13" border="0"></a>
<?}?> </td>
</tr>
</table></td>
<td width="78%" valign="top"><table width="99%" border="0" cellspacing="0" cellpadding="0" align="center" class="border_main">
<tr bgcolor="#FFE9E0">
<td height="25" class="big_txt" colspan="2"><a href="viewprofile.php?id=<? echo $rowuser["userid"]?>" class="side"><font size="3"> <? echo $rowuser["identity"]?> </font></a> ,
<?
$birth=$rowuser["birthdate"];;
$date=date("Y");
$age=$date-$birth;
echo $age?>
<?if($rowuser["genderid"]%2==0)
echo Female;
else
echo Male;?> </td>
</tr>
<tr class="normal_txt">
<td valign="top" width="46%"><table width="100%" border="0">
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top">Seeking
a
<? $country1=$rowuser["lookingfor"];
$rescon=mysql_query("select * from lookingfor where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["ethnicity"];
$rescon=mysql_query("select * from ethnicity where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["personality"];
$rescon=mysql_query("select * from personality where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["bodytype"];
$rescon=mysql_query("select * from bodytype where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
</table></td>
<td valign="top" width="54%"><table width="100%" border="0">
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["city"];
$rescon=mysql_query("select * from city where id_city='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->city_name.", "?>
<? $country1=$rowuser["state"];
$rescon=mysql_query("select * from state where id_state='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->state_name?> </td>
</tr>
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["marital_status"];
$rescon=mysql_query("select * from maritalstatus where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["livingsituation"];
$rescon=mysql_query("select * from livingsituation where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<?if($i<$totalrows-1){?>
<tr>
<td height="30"><hr color=#FFF0EA size="1"> </td>
</tr>
<?}}?>
</table></td>[/code]
MOD EDIT: Use code tags -
Well heres all the code maby you can see the error:
[code]<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"> </td>
</tr>
<tr>
<td height="20"><img src="images/line wink.gif" alt="who found you interesting" width="50" height="50"></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top" class="small_txt"><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="big_txt" height="24" align=center valign="top"><br>
<font size="2"> <? echo $total1?> people have Winked at you in last
[color=red]<?
if($last=="15 day")
{
$last1="15 days";
}
if($last=="7 day")
{
$last1="7 days";
}
if($last=="1 month")
{
$last1="1 month";
}
if($last=="6 month")
{
$last1="6 months";
}
echo $last1?>[/color]
</font><br>
<br>
</td>
</tr>
[color=red] <?if($totalrows>0){?>[/color]
<tr>
<td><table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="98%" valign="bottom"> </td>
<td width="1%" class="curve_top"> </td>
<td width="1%" valign="bottom"> </td>
</tr>
<tr>
<td colspan="3>
<table width="100%" border="0" cellspacing="0" cellpadding="0">[color=red]<?
for($i=0;$i<$totalrows;$i++)
{
$loverow=mysql_fetch_array($result1);
$userid=$loverow["userid"];
$query="select * from users where userid='$userid'";
$result=mysql_query($query,$db);
$rowuser=mysql_fetch_array($result);
$useridentity=$rowuser["identity"];
$sql1="select * from photo where username='$useridentity' and main='Y'";
$res1=mysql_query($sql1,$db);
$row1=mysql_fetch_array($res1);
if($row1["photo"])
$photo=$row1["photo"];
else
$photo="";
$PRODUCTIMAGES="photoimage/";
?>[/color]
<tr>
<td><table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="22%"><table width="99%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="39%" align="center"><? if($photo)
{?>
<a href="#" onClick="openWindow('<?echo $PRODUCTIMAGES.$photo?>')"> <img class=black_border name="<?$row1["quote"]?>" src=" <? echo $PRODUCTIMAGES.$photo?>" alt="<?$row1["quote"]?>" border=1 width=60 height=75 align=absmiddle></a>
<?}
else
{?>
<img src="images/no_photo.jpg" alt="no photo" width="60" height="75">
<?}?>
</td>
</tr>
<tr>
<td colspan="2" align="center" height="55"><a href="viewprofile.php?id=<? echo $rowuser["userid"]?>"> <img src="images/view_profile.jpg" alt="view photos" width="100" height="13" border="0"></a>
<?if($photo){?>
<a href="#" onClick="openpicWindow('<?echo $rowuser["identity"]?>')"> <img src="images/view_photos.jpg" alt="view photos" width="110" height="50" border="0"></a>
<?}?>
</td>
</tr>
</table></td>
<td width="78%" valign="top"><table width="99%" border="0" cellspacing="0" cellpadding="0" align="center" class="border_main">
<tr bgcolor="#FFE9E0">
<td height="25" colspan="2" bgcolor="#E1E1E1" class="big_txt"><a href="viewprofile.php?id=<? echo $rowuser["userid"]?>" class="side"><font size="3"> <? echo $rowuser["identity"]?> </font></a> ,
<?
$birth=$rowuser["birthdate"];;
$date=date("Y");
$age=$date-$birth;
echo $age?>
<?if($rowuser["genderid"]%2==0)
echo Female;
else
echo Male;?>
</td>
</tr>
<tr class="normal_txt">
<td valign="top" width="46%"><table width="100%" border="0">
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top">Seeking
a
<? $country1=$rowuser["lookingfor"];
$rescon=mysql_query("select * from lookingfor where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["ethnicity"];
$rescon=mysql_query("select * from ethnicity where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["personality"];
$rescon=mysql_query("select * from personality where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
<tr class="normal_txt">
<td height="20" width="8%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="92%" valign="top"><? $country1=$rowuser["bodytype"];
$rescon=mysql_query("select * from bodytype where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
</table></td>
<td valign="top" width="54%"><table width="100%" border="0">
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["city"];
$rescon=mysql_query("select * from city where id_city='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->city_name.", "?>
<? $country1=$rowuser["state"];
$rescon=mysql_query("select * from state where id_state='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->state_name?>
</td>
</tr>
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["marital_status"];
$rescon=mysql_query("select * from maritalstatus where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
<tr class="normal_txt">
<td height="20" width="7%" valign="top"><font face="Webdings">4</font></td>
<td height="20" width="93%" valign="top"><? $country1=$rowuser["livingsituation"];
$rescon=mysql_query("select * from livingsituation where id='$country1'",$db);
$rowcon=mysql_fetch_object($rescon);
echo $rowcon->name?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<?if($i<$totalrows-1){?>
<tr>
<td height="30"><hr color=#FFF0EA size="1">
</td>
</tr>
<?}}?>
</table></td>
</tr>
<tr>
<td width="98%" valign="top"> </td>
<td width="1%" class="curve_down"> </td>
<td width="1%" valign="top"> </td>
</tr>
</table>
<br>
</td>
</tr>
<?}?>
</table>
<?if($totalpages>0){?>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="50%" height="48"><?
if($pg>1)
{
$PrevPageNo = $pg -1;
?>
<div align="left" ><a href="interestinme.php?+<?php echo $PrevPageNo; ?>+&last=<?echo $last?>"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">Previous</font></a></div>
<? }?>
</td>
<td width="50%" height="48"><?
if($pg<$totalpages)
{
$NextPageNo = $pg + 1;
?>
<div align="right"><a href="interestinme.php?+<?php echo $NextPageNo; ?>+&last=<?echo $last?>"> <font size="2">Next</font> </a></div>
<?}?>
</td>
</tr>
</table>
<?}?>[/code] -
I did and it says:
[code]Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL
server version for the right syntax to use near ') order by time desc' at line 1 with query select * from
interest where loveid='36' and time>=date_sub(sysdate(),interval ) order by time desc[/code] -
Thanks to "AndyB" for helping me in the last topic i have only one error left to fix!
On the "Who Winked At Me.php" i recive this error..
[code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
/home/darkwate/public_html/datingsite/interestinme.php on line 10[/code]
"LINE 10" IS: $total1=mysql_num_rows($result1);
THE HEAD CODE IS:
[code]<?
include("cookie.php");
include("connect.php");
$resuser=mysql_query("select * from users where identity='$UsErCoOkIe'");
$rowuser=mysql_fetch_object($resuser);
$sql1="select * from interest where loveid='$rowuser->userid' and time>=date_sub(sysdate(),interval $last) order by time desc";
$result1=mysql_query($sql1,$db);
$total1=mysql_num_rows($result1);
if(!$argv[1])
{
$pg = 1;
}
else
{
$pg = $argv[1];
}
if(!$pg)
{
$pg = 1;
}
$total=$total1;
$StartRow = $PRODUCTSPERPAGE * ($pg-1);
$totalpages = (int) ($total / $PRODUCTSPERPAGE);
if(($total % $PRODUCTSPERPAGE)!=0)
$totalpages++;
$sql1 .= " LIMIT $StartRow,$PRODUCTSPERPAGE";
$result1=mysql_query($sql1,$db);
$totalrows = mysql_affected_rows();
?>[/code]
I checked the DB, and the user has 5 winks so it aint empy i know that!
I used the check error code and recived this message:
[code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
/home/darkwate/public_html/datingsite/interestinme.php on line 10
Error: You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near ') order by time desc'
at line 1 with query select * from interest where loveid='36' and time>=date_sub(sysdate(),interval )
order by time desc[/code]
Getting data from a columm in a table not showing...
in PHP Coding Help
Posted
I am not sure what that has to do with mine, i am not to great at sql haha.
I mean do i need to add anything to it like COUNT or GET to actually load the data inside it?
I have no issue connecting to it thats all fine its getting the data i am stuck at...