SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    JavaScript Guru (Big Ego) Arielladog's Avatar
    Join Date
    Jul 1999
    Location
    SC, USA
    Posts
    390
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey guys,

    I've got another stupid question

    I assign a variable in the URL part like this:

    URL.html?WID=2

    Then, I call it in PHP:

    $WID

    However, once I call it in a MySQL query (I can use it in PHP and re-use it), it seems to unset it's value for some reason. I've tried saying:

    $WID=$WID

    But that still doens't work. Here;s my first MySQL query and the first time a variable unsets.

    Code:
    $sqlW = mysql_query("SELECT ID, Name AS WName, MA AS WMA, City AS WCity, State AS WState, Zip AS WZip FROM work WHERE ID=$WID");
    $result = mysql_fetch_array($sqlW);
    aDog
    Last edited by Arielladog; Apr 5, 2001 at 14:32.

  2. #2
    imagine no limitations exbabylon's Avatar
    Join Date
    Dec 2000
    Location
    Idaho, USA
    Posts
    452
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try this:

    Code:
    $sqlW = "SELECT ... WHERE ID='$WID'";
    Blamestorming: Sitting around in a group discussing why a deadline was missed or a project failed and who was responsible.

    Exbabylon- Professional Internet Services

  3. #3
    JavaScript Guru (Big Ego) Arielladog's Avatar
    Join Date
    Jul 1999
    Location
    SC, USA
    Posts
    390
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey

    Thanx for help. I got it figured out

    aDog


Bookmarks

Posting Permissions

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