Jump to content

Comenius

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

Comenius's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I've found the problem: I called the field user_id in the table, but then id when trying to connect to it. It now all works well. Thanks very much for your help.
  2. dbdata.php connects to the mysql server ok - it's the same script used by all my form processing scripts, which enter information into the database without any problems. The code is: [code] $server = mysql_connect("localhost", "*user*", "*pass*"); $connection = mysql_select_db("camlawsoc_com_-_data"); [/code] Where *user* and *pass* are obviously substituted for the username and password.
  3. Ok, I now get the error: [code] Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/tickets_add.php on line 18[/code] And the same error if I use mysql_fetch_array(). This was happening earlier, and I couldn't work out why, so in a rather rookie-ish way I just decided to try and do it a different way...
  4. Hey, I'm rather new to php and am suffering from what is probably termed as a "rookie error"... I have 100 tickets for sale for a society event, and people are reserving tickets online. Their information is sent to a mysql database such that each reservation takes up one row. I've set up a php script which tries to access row x of the mysql table. If it finds row x, then it sends the user's data to a waiting list table. If not, then it sends it to the ticket reservation table. I got it working last night, then started fannying around with it this afternoon and now I can't get it to work again (I'm sure the code is the same as last night but obviously not...). The 'if' section doesn't seem to work, so the script just always includes tickets_success.php... Here's the code: [code]<?php // Open database connection include 'dbdata.php'; // Check the number of tickets already sold $result = mysql_query("SELECT id FROM tickets WHERE id = '100'"); // Determine which table to send the data to and include the script   if ($result == '100')   {   include('tickets_waiting.php');   }     else   {   include('tickets_success.php');   } ?>[/code] Any pointing out of general idiocy on my part would be much appreciated... :)
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.