tariqrf
Apr 20 2005, 07:01 AM
| | 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
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.
Reply
tariqrf
Apr 21 2005, 06:46 AM
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
Apr 21 2005, 12:54 PM
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
Apr 21 2005, 02:40 PM
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.  if it has been working with tripod before, there's no reason it wouldn't run with trap17 too.
Reply
tariqrf
Apr 22 2005, 07:36 AM
COOL!! IT WORKS!! i really donno what i did, but it finally works!! omg, Thanx guyz, T.
Reply
Similar Topics
Keywords : mysql script supported- 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 ^^)...
Phpizabi Social Network Script
- (0)
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...
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....
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?...
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. ...
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...
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 ...
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....
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&...
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...
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: ...
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 ...
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...
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,...
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...
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....
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...
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?...
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...
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" />......
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....
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. ...
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...
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...
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....
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...
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" />...
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...
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
|
advertisement
|
|