Search:

Type: Posts; User: JamieWarren09

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Add multiple percentages to a starting figure by pulling stats from mysql.

    so basically using php code to add the percentages or subtract the percentages as an accumulative figure from the $startingfigure. So first add on 10.7% onto 20,000 and then minus 10.3% and update...
  2. Add multiple percentages to a starting figure by pulling stats from mysql.

    Hi all,

    If I have the following


    $startingfigure = "20,000";
    $startdate = "2016-02-01";


    and then in my database I have the following :
  3. Show all text after specific word in a string.

    Hi,

    I am trying to pull what ever text is after a certain part of a string. For example

    $string = "Radio that plays Justin Timberlake";

    I want it to display what ever text is after 'Radio...
  4. Is there a better way for this code? also is there a way to remove duplicates?

    <?php

    $genre1 = mysql_query ( "SELECT * FROM `Genres` WHERE `ID` = '$sta->Genre1'" );
    $gen1 = mysql_fetch_object ( $genre1 );

    $genre2 = mysql_query ( "SELECT * FROM `Genres` WHERE `ID` =...
  5. only display specific image from foreach()

    foreach($get->artist->image as $image) {
    $image = (array) $image;
    echo 'İmage Text = '.$image['#text'].'<br />
    İmage Size = '.$image['size'].'<br />';
    }

    Displays
    İmage Text =...
  6. Re: Why does this SELECT DISTINCT querie not work?

    Any one able to help?
  7. Why does this SELECT DISTINCT querie not work?

    Hi Guys,

    For some reason this isnt working and wont display any results...

    Any ideas?
    <?
    $query1 = mysql_query ( "SELECT DISTINCT `artist` FROM `Artists` WHERE `Genre1` = '$usr->Genre1' OR...
  8. Replies
    1
    Views
    1,295

    Check timestamp is over 5 minutes ago?

    Hi guys, does anybody know a way of only inserting the same thing into the database if they are 5 minutes apart? For example :

    Jamie Warren listened to Capital FM - goes in at 12:06pm

    but if i...
  9. Replies
    13
    Views
    2,467

    Re: Not returning results.

    I tried that, It still will not work,

    Any other ideas?

    Jamie.
  10. Replies
    13
    Views
    2,467

    Re: Not returning results.

    Hey,

    Thanks for your reply.

    I am echoing it the way you told me too, and yes I am using that plugin, but its not made to work with a database, so that's what I am trying to add to it.

    Any...
  11. Replies
    13
    Views
    2,467

    Re: Not returning results.

    HI mate, this is the code to fetch the data..


    $(document).ready(function() {
    $('#field1').smartSuggest({
    src: 'assets/php/search_multiple.php',
    minChars: 1
    });
  12. Replies
    13
    Views
    2,467

    Re: Not returning results.

    Hi that shows the array and is showing all the stations like it should, but the search bar that checks the data.php page with that code on just returns 0 results.

    This is how the array looks and...
  13. Replies
    13
    Views
    2,467

    Re: Not returning results.

    Well when it checks the php page with the code on when a user types in the search box it is coming back 0results found.

    I echo'd $fruits; on the page, and it just shows 'Array' once rather than a...
  14. Replies
    13
    Views
    2,467

    Re: Not returning results.

    THanks for your reply, how ever that still didn't manage to work.

    This is what the sample data usually looks like when not using php to create the data...



    $fruitss = array(...
  15. Replies
    13
    Views
    2,467

    Not returning results.

    Hi Guys, For some reason my code is returning no results and is not working, Basically I've created an ajax search box that searches a php file with the code below, I basically need it to be in the...
  16. Replies
    1
    Views
    1,006

    if string changes then run some code?

    Hi guys, I have a string that is echo'd on my PHP page

    $output_string

    and a piece of javascript updates $output_string with the current song being played on the radio, now is it possible to...
  17. Replies
    1
    Views
    1,468

    MYSQL Duplicate entry error

    Hi guys,

    Does anybody know how I can allow duplicated for a field in my mysql database?

    I keep getting this error!

    INSERT INTO `welovera_assets`.`ratingItems` (

    `id` ,
    `Cat` ,
  18. Replies
    2
    Views
    1,111

    Why is this not counting correctly?

    Hi guys, I am trying to make it count for each indiviual item and display the number next to it.



    <?$query = mysql_query ( "SELECT * FROM `Stations` LIMIT 6" ); while ( $fea =...
  19. automatically add in to text2.text where ever there is a new line

    hi guys, is it possible that when i enter text into text1.text and press command1 it automatically adds "<br> at the end of the line where ever a new line is started? For example


    text1.text =
    ...
  20. Re: Classic VB - How can I read/write a text file?

    Hi for some reason when i do this, i put text1.text = Text1.Text = sFileText

    and it only loads the last line ?

    Any ideas (I'm using the first code example you gave!)
  21. Replies
    7
    Views
    12,538

    Re: Checkbox in listview?

    Hi guys,

    I'm trying to make a filter listview, like excel's filter option.

    Basically a checkbox of names, and what i want is when you tick each name then it will filter the database with each...
  22. Replies
    7
    Views
    12,538

    Re: Checkbox in listview?

    Thanks a lot guys, really appreciate it, is it possible to add a check box in one of the subitems as appose to the first column in the listview?

    thanks
    Jamie
  23. Replies
    7
    Views
    12,538

    Checkbox in listview?

    Hi guys, is it possible to have a checkbox in a listview for each item? and when the checkbox is ticked it do some code?

    Thanks
    Jamie
  24. Replies
    6
    Views
    1,022

    Re: How to divide numbers

    Hi mate,

    For some reason the code you provided is not returning any values, so it is just displaying empty results and not actually showing any numbers.

    Any ideas?
  25. Replies
    6
    Views
    1,022

    Re: How to divide numbers

    fantastic thank you, by anychance do you know how i can make it choose the number to divide it by automatically?

    Basically i have 2 dtpicker boxes and a user selects 2 diffrent dates, is it...
  26. Replies
    6
    Views
    1,022

    How to divide numbers

    Hi guys does anybody know how i can make it divide the numbers put in text1 and text 2?

    for example

    text 1 = 100
    text 2 = 4

    when command1 is pressed it then divides text1 by text2
  27. Replies
    12
    Views
    1,221

    Re: Sort Numbers in order in listview?

    Zvoni, either example codes would be handy, this is killing me!

    Madnessman, that code is used for dates, as appose to numbers / values.
  28. Replies
    12
    Views
    1,221

    Re: Sort Numbers in order in listview?

    Hi guys, thanks for the replies,

    Do you have any example codes?

    Regards,
    Jamie
  29. Replies
    12
    Views
    1,221

    Re: Sort Numbers in order in listview?

    Any ideas?

    Thanks
    Jamie
  30. Replies
    12
    Views
    1,221

    Sort Numbers in order in listview?

    Hi guys, I have a list view which has numbers in subitems(3)

    now how can I make it so when Command1 is pressed it will sort by highest Value first. at the moment when I sort it it sorts by the...
  31. Replies
    4
    Views
    760

    what is the code to launch a file?

    Hi guys, is it possible that when command1 is pressed, it opens the file c:\test.pdf
  32. Re: Copy selected file (CommonDialog) to another folder?

    Hi guys, I'm getting a run time error '52' bad file name which then highlights -


    dest = "\\server\Attachments\"
    FileCopy Text1.Text, dest



    any ideas?
  33. Copy selected file (CommonDialog) to another folder?

    Hi guys is it possible that when a user selects a file from commondialog1 (Open) and press the command button it will copy the file and paste a copy of it into the folder C:\New

    ?
    thanks
    Jamie
  34. Replies
    3
    Views
    2,001

    Re: If error number is 3050 then ignore?

    Set WS = DBEngine.Workspaces(0)
    dbfile = Form1.Text3.Text
    pwdstring = "passs"
    Set db = DBEngine.OpenDatabase(dbfile, False, False, ";PWD=" & pwdstring)


    Set rs = db.OpenRecordset("SELECT *...
  35. Replies
    3
    Views
    2,001

    If error number is 3050 then ignore?

    Hi guys on my vb project which connects to my microsoft access database I keep getting an error : 3050: Could not lock file.

    Is there away to either ignore the error throughout the entire project...
  36. Replies
    26
    Views
    150,906

    Re: VB - Color a row in a ListView

    Hi Martin, Is it possible to make this code color subitems(3)

    and if subitems(3) contains 'high' then it automatically color to red? as apose to the whole column being colored red?

    Thanks
    Jamie
  37. Replies
    2
    Views
    712

    Better icon for .exe file?

    Hi guys, is there away to give my .exe app a better icon? Higher quality as it looks quite crap at the moment as you can only select an icon from one of the forms.

    any ideas?

    Jamie
  38. Searching database not working properly

    Hi guys, Im searching a database with the following code



    Set rs = db.OpenRecordset("SELECT * FROM Leads WHERE `agent` = " & "'" & Form1.Text1.Text & "' AND " & _
    "UCase( [Company...
  39. Replies
    1
    Views
    1,169

    Add text to a panel in status bar?

    Hi guys, is it possible to add text on form_load to the 3rd panel i added in StatusBar1?

    Thanks
    Jamie
  40. Re: Vb6 - Sort Listview By Dates/numbers/text

    Hi mate, I'm really confused as to where I should put that code.

    Basically at the moment in the listview when I sort it, it will go by the first number not the whole figure...

    Any ideas?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width