Jul 20, 2008

Mysql Script Not Supported?

Free Web Hosting, No Ads > General > Hosted Members Area

free web hosting

Mysql Script Not Supported?

tariqrf
i put up a PHP and MYSQL site recently, which was hosted on tripod(loosers), where it used to work fine,

i put i up here again, it says:

CODE
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tariq/public_html/fsgr/script/orders.php on line 47


what does this mean, is the PHP or MYSQL version up to date?? or is there somthing wrong with my coding,


Please help
Tariq

Reply

beeseven
Something's wrong with your code. That happens to me a lot, too. I can usually fix it by just messing around with how I do the query. It's also sometimes a problem with variables getting lost. Try making it echo the query ($query = etc.; mysql_query($query); echo $query;) to see if it's doing it right.

Reply

tariqrf
QUOTE(beeseven @ Apr 20 2005, 09:55 PM)
Something's wrong with your code. That happens to me a lot, too. I can usually fix it by just messing around with how I do the query. It's also sometimes a problem with variables getting lost. Try making it echo the query ($query = etc.; mysql_query($query); echo $query;) to see if it's doing it right.
*





CODE
<?

$res = mysql_query("select * from orders");
while($row = mysql_fetch_array($res))

{  print "<tr><td valign=top>" . $row['orderid'] . "</td><td>" . $row['name'] . "</td><td>" . $row['tel'] . "</td><td>" . $row['address'] . "</td><td>" . $row['cart'] . "</td><td>" . $row['comments'] . "</td><td><a href=\"delete.php?id=" . $row['id'] . "\">delete</a></td></tr>";
}
?>


this is the full code,,, whats wrong???

 

 

 


Reply

Argoth
More than likely you didn't created the table orders, or perhaps there I no data there.

So make sure the table exists, has some columns is it, and has some data (but this really shouldn't matter)

Reply

serverph
when you transferred your site from tripod, you should look into it that you did not just transfer the PHP files only, but also the MYSQL database accessed by your pages as well. if you desire to start from scratch with your database, just create the appropriate DB from your cpanel. smile.gif

if it has been working with tripod before, there's no reason it wouldn't run with trap17 too.

Reply

tariqrf
COOL!! IT WORKS!! i really donno what i did, but it finally works!!

omg,

Thanx guyz,
T.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Similar Topics

Keywords : mysql script supported

  1. Could Someone Make A Php Script For Me? - Script to manage clans and players (3)
    Does someone know a script where you can 1. Add clans to a roster 2. Edit clans on a roster 3. Add
    players too a clan 4. Edit players 5. Schedule matches 6. Add clan Leaders to manage their own clan
    + members 7. Add members to edit their own information And maybe some sort of scoreboard integrated
    where you can put Wins, Draws and loses and that automaticly puts best clans on the top? If there
    isnt such a script could someone create 1 for me? (its for a league ^^)...
  2. Phpizabi Social Network Script - (0)
  3. How Do I Find My Mysql Password? [resolved] - Cannot access my MySQL (5)
    After all the recent problems, my account has been restored. I have setup my parked domain agin, and
    that works fine. However, I can no longer access my MySQL databases (I can from PHPMyAdmin, but
    that's all). I had to create a new user for my databases, and created the user with exactly the
    same username and password I had before, but some of my web pages do not let me access the pages I
    have associated with my databases. Where could i find out what my DB password is? (Although I am as
    good as sure I am using the right one). I have tried my old password, the new c...
  4. Remote Access Mysql - (8)
    Is it possible to directly access my local database from my website? For example, if somebody
    submits info on my website, the info they submitted would be transferred to my local database
    directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
    my database to my subdomain is because it would be difficult to keep the website database and my
    local database in sync . . . or is there a way to do that? Thanks for any replies....
  5. Is It Possible To Access The Mysql Remotely? - (10)
    I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
    in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
    remotely. If that's not possible, are we allowed to run Python scripts on the server?...
  6. Guestbook (cgi-script) Problems - Do u know much bout chmod and cgi-cripts? (1)
    Hi! I'd like to make a guestbook with a cgi-script I found at Lissa Explains it All .
    There were instruction bout how to install this gbook: click here QUOTE Active Guestbook
    Unzip the file, you'll find 4 separate files: guestbook.cgi mail.gif url.gif readme.txt 1.
    Open guestbook.cgi in a plain text editor like notepad. Find out your path to perl from your Web
    host, and change the first line to reflect that. The default setting, #!/usr/bin/perl, usually
    works for most servers. If not, you can try #!/usr/local/bin/perl. Save your changes. ...
  7. Installing Apache, Mysql, Phpmyadmin Locally - Solving the "php_mbstring.dll missing" (5)
    Since Trap17's CP provide the individual site's owner with goodies like MySql and
    PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
    on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
    expected that most people considering to make use of a database on their site will want to do most
    of the tedious job of developing and testing on their own local system before sending the wrapped-up
    result on their domain/subdomain. This involves four basic steps (sorry for the compuwi...
  8. Question About The Upgrade And The Mysql Usage ? - question about the upgrade and the mysql usage? (3)
    thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
    Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
    1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
    Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
    Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
    Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ...
  9. Upload Script To Transfer Files From Laptop To Desktop - (3)
    Would it be allowed to have an upload script to transfer text files (homework) from laptop to
    desktop? Because my printer is set up from my desktop, and most of my homework is done on my laptop.
    So would this be allowed? Thanks....
  10. Have There Been Any Changes? - PHP script not working anymore. (1)
    Hi, I was wondering if any changes have been made to the PHP and/or MySQL section at trap 17. All of
    a sudden a PHP script is beginneng to give errors where it never did before. I have a greeting card
    system on my website, and all of a sudden, when I try to add a card I get a load of errors, while I
    have not changed any code. These ar erthe errors i am getting: CODE Warning:
    imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions
    in /home/mrdee/public_html/kaart/admin/classes/class_images.inc.php on line 200 Warning&...
  11. Request For Coders (lots To Do) - Assisting on the Development of a Forum Script (1)
    I recently got involved in a Forum software script which is being developed and thought I should let
    everyone know that they need some assistance in the PHP, MySql, Html, and CSS areas. Also, some
    Visual Designers would be quite useful. AEF Forum Software is the name of the project. It is
    presently in version 1.0.3, and have some pretty cool features already, but in order to advance in
    its standings against such Boards as IPB, phpbb, Yabb, etc, more features and Themes are required.
    Good bunch of people working hard, but just not enough of us to do everything. Come h...
  12. How To Crate Mysql Database? - urgent help (7)
    Hi everyone!
    I'm trying to make in my site a page system that allows me to create users
    account (with a foto for every user)...
    I'm doing that in PHP, I learned all I have to
    know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
    is messing: ...
  13. Question About Adding Message Board To Site - Using mysql? (5)
    Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
    how can I set up a messageboard. Thanks. std split from another topic ...
  14. Different Log In Script... - (6)
    Ok well i picked out a new log in script..
    http://evolt.org/PHP-Login-System-with-Adm...tures#authorbio And now I get errors, like i had
    before I guess, but I still get errors. I installed everything properly, and idk why I get these
    errors.. on login screen: QUOTE Warning: session_start() : Cannot send session cache limiter
    - headers already sent (output started at /home/enrit/public_html/include/constants.php:94) in
    /home/enrit/public_html/include/session.php on line 46 and on registering screen: QUOTE
    Warning: session_start() : Cannot send session...
  15. Phpbb2.17 Mysql Problems - Just this week they started (4)
    The forum has been up and running for about a year and a half. It has been through numerous server
    upgrades, etc, including the recent HDD change, but for some reason, just this week it started
    throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
    SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
    be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
    u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,...
  16. 99 Mysql Databases? - (2)
    I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
    lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
    have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
    just prefix my tables, but I was just wondering why it would say that. If for some reason it was
    letting me get more than one database, and I wasn't supposed to, I don't want to get my
    account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m...
  17. Mysql Access Error[resolved] - (5)
    The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
    never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
    Please kindly look into this....
  18. Mysql Server Problems [resolved] - (3)
    hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
    ERRORS, like that the server is going down so now and often is it due to my cms or is the server
    having some probs ? this is what i just saw from the statistics: QUOTE Service Status
    named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
    (5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
    Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17...
  19. Cpanel And Mysql Problem. [resolved] - (3)
    hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
    to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
    ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
    loads with a blank page. however both worked earlier today. so is there a problem with the server?
    and if there is, will it be fixed?...
  20. Mysql Database Setup : Setting Up Mysql Database - Guide to use MySQL database in your site (4)
    A SMALL INTRODUCTION TO DATABASE ============================= I have seen that many members have
    problems with Database. Here is a small INFO which should give you the IDEA. mySQL is a DATABASE
    server. You can access it using the link in Cpanel. Cpanel can be accessed by
    "www.YOUR-SITE.com/Cpanel" There you have 4 Main Options :- 1> CREATE A DATABASE 2> CREATE A USER
    3> ADD USER TO DATABASE 4> PHPMYADMIN CREATE : IT ALLOWS YOU TO CREATE A DATABASE CREATE USER
    : IT ALLOWS YOU TO CREATE A USER. USING THIS, YOU CAN ACCESS THE DATABASE. A DATABASE CANNOT BE...
  21. Sites Disapeard, Mysql Errors? Also Server Folders Deleted - (18)
    Hello its 15:40 and I login see if everything runs oke, and I see numerus things deleted my mysql is
    working again. Whats going on? My Webpage couple websites got deleted, and server folder files now
    whats going on? /sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> my
    forum also give errors but mysql db stil there /sad.gif" style="vertical-align:middle" emoid=":("
    border="0" alt="sad.gif" />......
  22. The Difference Between Mysql And Postgresql ? - (4)
    I found those two in cPanel and they loofed nearly the same as each other but what is the difference
    ? I tried to go to phpMyAdmin and phpPgAdmin and they are nearly the same too. Do you know that ?
    Please reply , thanks a lot....
  23. Mysql Backup Cronjob - How to? : / (6)
    Well, I want basically a cron job that will run and backup my MySQL database. I've been told
    in the shoutbox that you can do it via cron job. Didn't told me how. Now, I just want help on
    how to do it and what commands I should put in the cPanel. ...
  24. Does Trap17 keep back-ups of my MySQL Databases? - (6)
    ok, well i screwed up yes i admit it i screwed up big time... anywho, umm i was wondering is
    trap17 kept back-ups of the MySQL Databases??? and if they do would it be possible for me to get a
    copy of the backup for my forums sent to me somehow? because stupid me, i was re-installing my
    forums, and went to make a backup of my MySQL database jsut in case, and selected all and hit make
    backup, and well it only made a backup of only one of the databses, so right now i am without the
    many posts i had ten minutes ago so if you so keep backups thats awsome!! youv...
  25. How Do You Check Mysql Info, And Act According To It's Content? - (6)
    As part of a web-game on my site, I have a php form that requires people to enter their username,
    and information about the characters they want to have in the game. All this information is stored
    into a MySQL table. I want the players to be able to visit a page where every character they have
    registered with their username can be seen. My question is simply, how can I check the values of
    the MySQL data, and act accordingly? What I need to do is check for a Username and a character
    number, and if it finds it, takes the data in that part and acts on it, eg. by showing th...
  26. I Can Not Create Mysql Databases In Control Panel Using Phpmyadmin - Phpmyadmin says i don't have permissions to create databases (3)
    I went to phpmyadmin script a few minutes ago and i could not create a database. Since it says
    there on my control panel that i have unlimited mysql databases, plus i am using only a couple of
    databases, please respond and fix this, please....
  27. Help With Running A Cgi Script - (2)
    i am having a problem running a cgi script written in perl in my site , the path to perl and file
    permissions and anyother thing that may cause a problem i have checked and found none , the response
    i get is 500 , internal server error ,i am pretty new to perl but i am sure it's nothin wrong
    with the code , so if anybody can throw me a light on what may be wrong i will be most grateful
    ,thanks in anticipation...
  28. Mysql? - (15)
    My board has a mySQL error on it and when i went to cpanel it says for mySQL databases /99 instead
    of 1/99 or 0/99. I tried making new one but it didn't appear after i created it /unsure.gif"
    style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" />...
  29. Mysql Version4.0.27 - mysql version is old (2)
    I have came to my control cpanel,And I saw the mysql version,It is old,and with this version we
    don't have to install into computer before use it,that is the way make it to hard to use to me
    when I try to use it on my computer.So I want to ask you,Admin.Do you plan to upgrade mysql to
    higher version like mysql 5.1.?If yes,please do it as soon as posible.Because right now i'm
    using mysql 5.1 and I don't know how to use mysql 4.0.27. Otherwise,can I upload my exist
    database to my account. I don't know how to create it in my account.It is so hard for me be...
  30. Fantastic Script - How ? (2)
    Hi all iam sorry posting here but i think here admins read my post i write some script like famp3 ,
    fanewsletter , famail and .... and i submit my script at hotscripts i want to know how can send my
    script in Fantastic at cpanel for example phpbb it show in Fantastic or wordpress it show at
    Fantastic and users can install script by 1 click i want my script locate at Fantastic with cpanel ?
    cpanel admin or developers must add my script or server admin can add my script in Fantastic !
    thanks...



Looking for mysql, script, supported

Searching Video's for mysql, script, supported
Could
Someone Make
A Php Script
For Me?
Script to
manage clans
and players
Phpizabi
Social
Network
Script
How Do I
Find My
Mysql
Password?
[resolved]
Cannot
access my
MySQL
Remote
Access Mysql
Is It
Possible To
Access The
Mysql
Remotely?
Guestbook
(cgi-script)
Problems Do
u know much
bout chmod
and
cgi-cripts?
Installing
Apache,
Mysql,
Phpmyadmin
Locally
Solving the
"php_mb
string.dll
missing"
;
Question
About The
Upgrade And
The Mysql
Usage ?
question
about the
upgrade and
the mysql
usage?
Upload
Script To
Transfer
Files From
Laptop To
Desktop
Have There
Been Any
Changes? PHP
script not
working
anymore.
Request For
Coders (lots
To Do)
Assisting on
the
Development
of a Forum
Script
How To Crate
Mysql
Database?
urgent help
Question
About Adding
Message
Board To
Site Using
mysql?
Different
Log In
Script...
Phpbb2.17
Mysql
Problems
Just this
week they
started
99 Mysql
Databases?
Mysql Access
Error[resolv
ed]
Mysql Server
Problems
[resolved]
Cpanel And
Mysql
Problem.
[resolved]
Mysql
Database
Setup :
Setting Up
Mysql
Database
Guide to use
MySQL
database in
your site
Sites
Disapeard,
Mysql
Errors? Also
Server
Folders
Deleted
The
Difference
Between
Mysql And
Postgresql ?
Mysql Backup
Cronjob How
to? : /
Does Trap17
keep
back-ups of
my MySQL
Databases?
How Do You
Check Mysql
Info, And
Act
According To
It's
Content?
I Can Not
Create Mysql
Databases In
Control
Panel Using
Phpmyadmin
Phpmyadmin
says i
don't
have
permissions
to create
databases
Help With
Running A
Cgi Script
Mysql?
Mysql
Version4.0.2
7 mysql
version is
old
Fantastic
Script How ?
advertisement



Mysql Script Not Supported?



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE