The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 6 of 6

Thread: [PHP MySQL] Query Problems

  1. #1
    jw06's Avatar
    657
    posts
    Registered User

    [PHP MySQL] Query Problems

    Alright, I am trying to make a script that will automaticly update some URL's in a table. I've used this format of a query in order to get the content before, but this time its only returning the number of entries in the table.

    PHP Code:
                 $query "SELECT COUNT(*) AS url FROM urls";
        if (
    $r mysql_query($query)) {
            while (
    $row mysql_fetch_array ($r)) {
                
    $url $row['url'];
                echo 
    "$url";
                
    $gather = new Harvest_Keywords($url);
                
    $gather->process();
            }
        } else {
            die (
    'Error: ' mysql_error() . '');
        } 
    Any ideas on what I'm doing wrong?

  2. #2
    use "SELECT * " instead of "SELECT COUNT(*) ", obviously what select count does is just count...

  3. #3


    Don't ya hate silly mistakes

  4. #4
    it happens all the time me first

  5. #5
    yeah i do dumb stuff too

  6. #6
    jw06's Avatar
    657
    posts
    Registered User
    Yea, dumb mistake Now it wont happen again though, thanks for pointing it out guys! lol

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012